Hello!

I have created a query like this:

"from VirtualAsset va " +
"inner join fetch va.currency " +
"inner join fetch va.extendedCashFlow " +
"inner join fetch va.extendedCashFlow.contract " +
"where va.extendedCashFlow.contract.portfolio = :portfolio " +
"order by va.extendedCashFlow.contract.objId"

The contract has some one-to-one associations. I tried some suggestions to avoid lazy loading of these associations. But no one was successful. Can anyone help?

Thanks
olli73

Please be more specific and provide mappings and explicitly specify things you have tried.

By the way, did you specify hibernate.max_fetch_depth?

Thanks for your reply!

Modifying the property hibernate.max_fetch_depth did not change the behavior.

Here are the one-to-one mappings in my contract:

Contract.hbm.xml
<one-to-one name="contractEssentials" cascade="all" class="db.vag.ContractEssentials"/>
<one-to-one name="externalAssessment" cascade="all" class="db.vag.ExternalAssessment"/>
<one-to-one name="charges" cascade="all" class="db.vag.Charges"/>
<one-to-one name="refinancing" cascade="all" class="db.vag.Refinancing"/>
<one-to-one name="interestAndAmortization" cascade="all" class="db.vag.InterestAndAmortization"/>
<one-to-one name="legalAspects" cascade="all" class="db.vag.LegalAspects"/>
<one-to-one name="externalData" cascade="all" class="db.vag.ExternalData"/>

On the other side of the associations I do this:

ContractEssentials.hbm.xml
<one-to-one name="contract" constrained="true" class="db.vag.Contract"/>



olli73

Please try the "fetch" attribute.

http://www.hibernate.org/hib_docs/v3/re ... e-fetching

Geir