Hi ,

I have a mapping like this, i give it one-to-many the lazy=true and i want to use left join fetch to get my two children list, here is my query

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="com.sp.fbb.businessobject.investpolicy.InvestPolicy" table="FBB_INVESTMENT_POLICY">

<id column="INVPOL_ID" name="investPolicyID" type="long" >
<generator class="assigned"/>
</id>

<property column="INVPOL_DESCRIPTION" length="1024" name="comments" type="string"/>
<property column="INVPOL_INVESTMENT_AMOUNT" name="investAmount" type="long"/>
<property column="INVPOL_INVESTABLE_AMOUNT" name="investableAmount" type="long"/>
<property column="INVPOL_TIMEHORIZON" length="30" name="timeHorizon" type="string"/>
<property column="INVPOL_TAXSTATUS" length="1" name="status" type="string"/>
<property column="INVPOL_ASSOCIATED_FEES" name="associatedFee" type="long"/>
<property column="LAST_MODIFIED_DATE" name="lastModifiedDate" type="java.util.Date" update="false" insert="false"/>


<bag name="industryRestriction" table="FBB_INVPOL_INY_BRIDGE" lazy="true" inverse="true" cascade="delete" >
<key column="INVPOL_ID" />
<one-to-many class="com.sp.fbb.businessobject.investpolicy.InvestPolicyIndustryRestriction" outer-join="true"/>
</bag>

<bag name="instrumentRestriction" table="FBB_INVPOL_SIR_BRIDGE" lazy="true" inverse="true" cascade="delete" >
<key column="INVPOL_ID" />
<one-to-many class="com.sp.fbb.businessobject.investpolicy.InvestPolicyInstrumentRestriction" outer-join="true"/>
</bag>
</class>
</hibernate-mapping>

Query:
queryString =
"from InvestPolicy as x left join fetch x.industryRestriction left join fetch x.instrumentRestriction where x.investPolicyID=?";
Query q = session.createQuery(queryString);
q.setParameter(0, investPolicyID);
List result = q.list();

but the application can't initialize the IndustryRestriction list, once I call get the IndustryRestriction List, the following errors displayed:net.sf.hibernate.LazyInitializationException: Failed to lazily initialize a collection - no Session.

The second child list instrumentRestriction is initialized successfully

Can anyone help me to solve this?

thanks

if you are trying to access a lazy-loaded property after session.close() this will happen. You either need to access the property before ending the session or call Hibernate.initialize(obj.getProperty()) before ending the session to "preload" the lazy reference

I believe that the fetch option can only be used to eagerly fetch one association per HQL.

Only one collection. You can fetch as many many-to-ones as you like.

since I am using tread local for get the hibernate session, does it mean that there is no way to load more than one one-to-many collection using left join fetch? Can Hibernate.initialize(obj.getCollection1()) and Hibernate.initialize(obj.getCollection2()) get two collections at the same time?

If not, does Hibernate going to support it? I think lazy load more than one collections is common usage for hibernate.

Thanks

eh? I think you are very confused. What on earth does thread local session have to do with this?