JPA Hibernate left join fetch generating mutiple queries

Question

I have a jpql query to eagerly fetch multi level associations as follows

 select distinct s from Singer s left join fetch s.singerIdentifiers si //singerIdentifiers is collection in Singer object left join fetch si.identifier i left join fetch i.identifierReportedAreas ira left join fetch irc.reportedArea ra left join fetch rc.reportingSystem rs where s.id in (?);

This generates multiples queries, though I am getting all the required information in the first select itself. All extra queries are for querying SingerIdentifier table data for distinct IdentifierIds from the first query.

Any help in this regard is highly appreciated.

I deleted my "answer". I just tried, and similar query with as deep level of join fetches seems to work (Hibernate 3.5.6). — Mikko Maunu
– Mikko Maunu, Commented Oct 5, 2011 at 17:49
Hi Mikko Maunu,thanks for your effort. Did you try using associations with collections or just OneToOne associations? and How many queries it generated ? just want to know... — user877016
– user877016, Commented Oct 6, 2011 at 13:43
Hi, with @OneToMany Set<Ent[1-6]>, six levels: SELECT DISTINCT e FROM Ent1 e LEFT JOIN FETCH e.entities e2 LEFT JOIN FETCH e2. entities e3 LEFT JOIN .... — Mikko Maunu
– Mikko Maunu, Commented Oct 7, 2011 at 7:09
looks like issue mentioned here:hibernate.onjira.com/browse/HHH-4935 I have bidirectional oneToOne association between identifier and singerIdentifier. I changed it to manyToOne & oneToMany, and it is generating just one query now. — user877016
– user877016, Commented Oct 13, 2011 at 17:07
Can you write the SQL query being generated on console for this HQL ? — Priyank Doshi
– Priyank Doshi, Commented Jan 10, 2013 at 13:57

KoW · Accepted Answer · 2013-11-01 22:57:34Z

1

Maybe a typo?

 left join fetch i.identifierReportedAreas -->ira<-- left join fetch -->irc<---.reportedArea ra

answered Nov 1, 2013 at 22:57

KoW

7845 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

JPA Hibernate left join fetch generating mutiple queries

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related