Eclipse Community Forums: EclipseLink » How to avoid additional sql query for nested left join

Home

Home » Eclipse Projects » EclipseLink » How to avoid additional sql query for nested left join

How to avoid additional sql query for nested left join [message #1733983]

Thu, 02 June 2016 11:25

Eclipse User

I have the following entities:

@Entity
class A{
 @OneToMany
 private List<B> bs;
 ...
}

@Entity
class B{
 @OneToMany
 private List<C> cs;
 ...
}

@Entity
class C{
 ...
}

So I do the followin query:

SELECT a FROM A a LEFT JOIN FETCH a.bs b LEFT JOIN b.cs

This code works, the only problem that A and B are read from database in one join query, but for reading C (LEFT JOIN b.cs) separate sql query is executed to read only C entities. How to read A,B,C in one sql query.

Re: How to avoid additional sql query for nested left join [message #1734850 is a reply to message #1733983]

Mon, 13 June 2016 09:46

Eclipse User

JPQL doesn't support nesting fetch joins, so the only way to do this would be to use EclipseLink's "eclipselink.join-fetch" query hint: http://www.eclipse.org/eclipselink/documentation/2.5/jpa/extensions/q_join_fetch.htm

Re: How to avoid additional sql query for nested left join [message #1734886 is a reply to message #1733983]

Mon, 13 June 2016 09:46

Eclipse User

Re: How to avoid additional sql query for nested left join [message #1734893 is a reply to message #1733983]

Mon, 13 June 2016 09:46

Eclipse User

Previous Topic:	EclipseLink: weaving, inheritance - entities in different jar
Next Topic:	Re: JPA: EntityGraph -> FetchGroupException [CLOSED]

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Oct 28 18:02:42 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter