hi

im using some objects with collections

A -> B
A -> C

im using lazy loading on all collection

im using oql to query some A items with constraints on B object and need loading C objects

select a from com.object.a as a inner join com.object.b as b, com.object.a as a2 left join fetch a2.bs where b.field1:=val1 and b.field2:=val2

its works : i could see the select clause in console with A,B and C object

but when im retrieved elements (A object) on the query result and when i get a.bs.iterator(), hibernate execute select command to load B object

what does i mean ?

fetch keyword dont work ?

you"re fetching an object that is not returned a2, so I don't think Hibernate will fetch bs for real

ok emmanuel, thanks for your reply

but have you got a solution ?
what can i do to use constraints on parent and using fetch together ?

Actually I don't understand the point of your query (functional meaning).