« Return to Thread: Join Table with additional columns: One SQL Select to fetch data?

Re: Join Table with additional columns: One SQL Select to fetch data?

by Joe Mc. :: Rate this Message:

Hi,

thanks again J.Sutherland!
I study the chapters about Join Fetch or Batch reading (e.g:
http://wiki.eclipse.org/Optimizing_the_EclipseLink_Application_(ELUG)#How_to_Use_Batch_and_Join_Reading_for_Optimization etc)

and for example with
q.setHint(QueryHints.LEFT_FETCH, "c.mapCourses");
q.setHint(QueryHints.LEFT_FETCH, "c.mapCourses.course");
and removing the @JoinFetch at the properties I get the wanted result.

I playing now with LEFT_FETCH and BATCH to get the perfect (performance optimal) queries.

Thanks!

McJoe

« Return to Thread: Join Table with additional columns: One SQL Select to fetch data?