Hello,

I have a common question regarding the object graph loading.
We have a lot of many-to-one associations in our application, so it would be great if hibernate would resolve them by using outer join (we use OracleDialect, so it should be possible), and not by executing extra queries for each association. I've already played with different initialization parameters (e.g. max_fetch_depth) with no effect.

Is there any way to let hibernate generate as few queries as possible without using proxies?
Or may be there is a possibility to let many-to-one associations be lazy initialized (like collections)? I've read that it could be possible via proxies, but proxies have several limitations that are not acceptable in our case...

Thanks in advance

The one-side of a many-to-one can only be lazyli fetched using a proxy. Read http://www.hibernate.org/162.html. The same reasons on why this is only possible with proxys apply in this case.

Hi,

at first, thanks a lot for the quick reply!

So, the situation with proxies and lazy initialization seems to be clear. But beyond lazy initialization, what about outer join fetching? This would drastically decrease the number of generated queries...

Regards,
Michail.

You can use outer join loading by using hibernate.max_fetch_depth > 0 and outer-join=true on the collections or the many-to-one element.