Hello,

We are trying lazy data fetching using fetchMode. But it is not working as mentioned in

documentation. We tried this property with primitive, and also with collection but did't get

required results, means it is not fetching collection items lazily but fetching these with the

main object. Please let me know how to use this property. I am giving the mapping files and code

segment of example:



Mapping file for collection (Document.LineItem):
-------------------------------------------------

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="com.aceva.rms.knowledge.config.Document" table="Document"

proxy="com.aceva.rms.knowledge.config.Document">
<id name="id" column="document_id" type="long" unsaved-value="null">
<generator class="hilo"/>
</id>
<property name="documentAmount" column="document_amount" type="float"/>
<property name="documnetDate" column="document_date" type="date"/>

<set name="docExceptions" cascade="all" inverse="true" lazy="true">
<key column="document_id"/>
<one-to-many class="com.aceva.rms.knowledge.config.Exception_To_Document"/>
</set>
<set name="docScopes" cascade="all" inverse="true" lazy="true">
<key column="document_id"/>
<one-to-many class="com.aceva.rms.knowledge.config.Document_To_Scope"/>
</set>
<set name="lineItems" cascade="all" inverse="true" lazy="true">
<key column="document_id"/>
<one-to-many class="com.aceva.rms.knowledge.config.Line_Item"/>
</set>

<joined-subclass name="com.aceva.rms.knowledge.config.Adjustment" table="Adjustment"

proxy="com.aceva.rms.knowledge.config.Adjustment">
<key column="sid"/>
<property name="accountNumber" column="account_number" type="string"

length="30" not-null="true"/>
</joined-subclass>
</class>

</hibernate-mapping>

Code :
--------------

private void testDocument(){
Session session = null;
try{ //
session = HibernateUtils.currentSession();
Criteria criteria = session.createCriteria(Document.class)
.add( Expression.eq( "id", new Long(65537)))
.setFetchMode("lineItems", FetchMode.LAZY)


List list = criteria.list();
for (int i = 0; i < list.size(); i++)
{
Document document = (Document) list.get(i);
logMessage("document Fetched! > " + document);
Collection lineItems = document.getLineItems();
logMessage("size : " + lineItems.size());
logMessage("asked for definition!");
}
}
catch(Throwable ex){
logMessage("Exception while fetching document! msg > " + ex.getMessage());
ex.printStackTrace();
}
finally{
try{
session.flush();
session.connection().rollback();
HibernateUtils.closeSession();
}
catch(Throwable daoExp){
logMessage("Exception while closing session! msg > " + daoExp.getMessage());
daoExp.printStackTrace();
}
}
}




Thanks,

asking lineItems.size() will load the collection.

You are right, that listItems.size should fetch the collection items. We achieved this by setting lazy property in mapping file. But can we achieve this using fetch mode as well?

And also whats about other associated data objects, if we want to fetch these lazily.