jpa fetch join query

Question

This is how my domain looks:

public class Template implements Serializable {
    private static final long serialVersionUID = 1L;    
    @OneToOne(cascade=CascadeType.ALL)
    private FieldConfig fieldConfig;
}

public class FieldConfig implements Serializable {
    private static final long serialVersionUID = 1L;

    @OneToMany(cascade= CascadeType.PERSIST)
    @JoinColumn(name = "fieldConfigId")
    private Set<Field> fieldSet;
}

I want to achieve if I load a template from the db that automatically the fieldConfig is loaded and the fieldSet of that fieldconfig.

my current JPQL:

TypedQuery<Template> query = em.createQuery("SELECT t from Template t LEFT JOIN FETCH t.fieldConfig"
                + " fconfig LEFT JOIN FETCH fconfig.fieldSet where t.id = :id", Template.class);

my exception:

Internal Exception: NoViableAltException(80@[()* loopback of 477:9: (node= join )*])
Exception Description: Syntax error parsing the query [SELECT t from Template t LEFT JOIN FETCH t.fieldConfig fconfig LEFT JOIN FETCH fconfig.fieldSet where t.id = :id], line 1, column 55: unexpected token [fconfig].

Any thoughts on creating such a query?

Are @Template and @FieldConfig annotated as entities or configures so in the descriptor? — Piotr Nowicki
– Piotr Nowicki, Commented Nov 19, 2011 at 16:05
The query looks correct to me. What's your JPA engine? Have you tried using AS fconfig to see if it makes a difference? — JB Nizet
– JB Nizet, Commented Nov 19, 2011 at 16:14
I'm using EclipseLink, tried adding AS got => Exception Description: Syntax error parsing the query [SELECT t from Template t LEFT JOIN FETCH t.fieldConfig AS fconfig LEFT JOIN FETCH fconfig.fieldSet where t.id = :id], line 1, column 55: unexpected token [AS]. — Frédéric Gobert
– Frédéric Gobert, Commented Nov 19, 2011 at 16:19

James · Accepted Answer · 2011-11-21 15:24:29Z

3

You cannot use an alias on a join fetch in JPQL, this is disallowed by the spec.

EclipseLink does allow nested join fetch through the query hint,

"eclipselink.join-fetch"="t.fieldConfig.fieldSet"

answered Nov 21, 2011 at 15:24

James

18.5k13 gold badges100 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Frédéric Gobert Over a year ago

TypedQuery<Template> query = em.createQuery("SELECT t from Template t JOIN FETCH t.fieldConfig" + " JOIN FETCH t.theme" + " JOIN FETCH t.dataConfig" + " JOIN t.fieldConfig.fieldSet fs" + " JOIN t.dataConfig.textSet ts where t.id = :id", Template.class); query.setParameter("id", id); query.setHint(QueryHints.FETCH, "t.fieldConfig.fieldSet"); query.setHint(QueryHints.FETCH, "t.dataConfig.textSet"); return query.getSingleResult();

Collectives™ on Stack Overflow

jpa fetch join query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related