Author Login
Post Reply
Hi, when running a JPQL query for OpenJPA 1.0.2 with multiple left outer join
fetch clauses such as:
SELECT x FROM Magazine x left outer join fetch x.articles left outer join
fetch x.authors WHERE x.title = 'JDJ'
it seems multiple SQL select statements are executed, 1 for each join fetch
clause. Calling getResultList returns the result set of the last select
statement. In the above statement, for example, I see articles is null, but
authors is not null. Wondering if this is a known issue and if there are
workarounds?
--
Sent from the OpenJPA Users mailing list archive at Nabble.com.