Hey,

I have Person->Address->*Contacts (collection of elements)

(in my model i have heirarchy with more levels).

i use the following query:
from Person person left join fetch Address address left join fetch address.contacts

in the SQL that hibernate generate i notice that it excute select for each person references, so if i load 10 persons it will run 10 selects for address + 10 selects for contacts instead of load them in a join.

Any idea how to start debug this?

Thank you