Re: [eclipselink-users] Join Table with additional columns: One SQL Sele

["Joe Mc." <m_joe_c@xxxxxxxxxxx>]

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

-- 
View this message in context: http://www.nabble.com/Join-Table-with-additional-columns%3A-One-SQL-Select-to-fetch-data--tp24304704p24334463.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.