deep join fetch with one-to-many in path

codehawk · **Posted:** Fri Oct 24, 2003 6:48 am

Ls,

A collegae and I were just trying to execute a query that fetched a many relationship and at the same time fetches a many-to-one association on the elements of that first many relationship.

The above sentence is probably totally illegible :-) , so an example :

Code:

select from com.dhl.ncg.ums.model.UldRepair uldRepair
left outer join fetch uldRepair.uldRepairParts
--> left outer join fetch uldRepair.uldRepairParts.currency
where ...

The documentation describes in section "9.3. Associations and joins" :

"Note that, in the current implementation, only one collection role may be fetched in a query"

We're not sure whether this means it can't be done, or not.

Any ideas welcome !

Dimitry D'hondt.

gavin · **Posted:** Fri Oct 24, 2003 4:12 pm

Quote:

from UldRepair uldRepair
left outer join fetch uldRepair.uldRepairParts parts
left outer join fetch parts.currency
where ...