Re: Multiple LEFT JOIN FETCH clauses in EJBQL

2008-01-16 Thread Dain Sundstrom
On Jan 16, 2008, at 3:03 PM, Alexander Saint Croix wrote: Thank you, Dain. This is helpful in that it reinforces my intuition to avoid eager loading for anything that can be replaced by well-written queries. I'd rather the extra data were optionally retrieved than enforced across all app

Re: Multiple LEFT JOIN FETCH clauses in EJBQL

2008-01-16 Thread Alexander Saint Croix
Thank you, Dain. This is helpful in that it reinforces my intuition to avoid eager loading for anything that can be replaced by well-written queries. I'd rather the extra data were optionally retrieved than enforced across all applications regardless of circumstance. I asked one of the Universit

Re: Multiple LEFT JOIN FETCH clauses in EJBQL

2008-01-16 Thread Dain Sundstrom
On Jan 16, 2008, at 7:16 AM, Alexander Saint Croix wrote: Hey, guys. Is it possible to write an EJBQL query with more than one LEFT JOIN FETCH clause? Sure. Just be careful with outer joins. I always seem to end up getting too much data with them, and end up using trial and error to

Multiple LEFT JOIN FETCH clauses in EJBQL

2008-01-16 Thread Alexander Saint Croix
Hey, guys. Is it possible to write an EJBQL query with more than one LEFT JOIN FETCH clause? I have a number of entities with more than collection-valued references that are lazy loaded by default. I'm trying to avoid flagging them as FetchType.EAGER. The O'Reilly book on EJB 3 has exactly [---