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? -- View this message in context: http://n2.nabble.com/Multiple-SQL-select-statements-for-JPQL-select-with-multiple-left-join-fetch-tp681851p681851.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
