These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Lazy load still tranverses collections
PostPosted: Tue Jul 24, 2007 12:49 pm 
Newbie

Joined: Thu Jul 19, 2007 3:53 pm
Posts: 7
I have a problem with lazy loading still transversing the relationships.
Here's my config file:
Code:
<class name="MasterLogVO" table="tblMasterLogs" lazy="true">
<bag name="logVersion" inverse="true" cascade="persist, merge, save-update, lock, refresh" lazy="true">
            <key column="masterLogVO"/>             
<one-to-many class="LogVersionVO"/>
</bag>       
</class>
<class name="LogVersionVO" table="tblLogVersion" lazy="true">
<many-to-one name="masterLogVO" class="MasterLog" cascade="persist, merge, save-update, lock, refresh" lazy="proxy">
            <column name="masterLogVO"/>
</many-to-one>
</class>


When i call:

session.createQuery("from MasterLogVO").list();

I see the sql output:


Code:
Hibernate: select masterlogv0_.masterLogId as masterLo1_15_, masterlogv0_.logTitle as logTitle15_, masterlogv0_.logRevision as logRevis3_15_, masterlogv0_.watchstationVO as watchsta4_15_ from tblMasterLogs masterlogv0_
Hibernate: select logversion0_.masterLogVO as masterL14_1_, logversion0_.logVersionId as logVersi1_1_, logversion0_.logVersionId as logVersi1_14_0_, logversion0_.editedBy as editedBy14_0_, logversion0_.editedOn as editedOn14_0_, logversion0_.systemName as systemName14_0_, logversion0_.comments as comments14_0_, logversion0_.reviewedBy as reviewedBy14_0_, logversion0_.reviewedOn as reviewedOn14_0_, logversion0_.approved as approved14_0_, logversion0_.condition as condition14_0_, logversion0_.version as version14_0_, logversion0_.defaultVersion as default11_14_0_, logversion0_.status as status14_0_, logversion0_.logRev as logRev14_0_, logversion0_.masterLogVO as masterL14_14_0_ from tblLogVersion logversion0_ where logversion0_.masterLogVO=?
Hibernate: select logpagevos0_.logVersionVO as logVersi7_1_, logpagevos0_.logPageId as logPageId1_, logpagevos0_.pageOrder as pageOrder1_, logpagevos0_.logPageId as logPageId6_0_, logpagevos0_.title as title6_0_, logpagevos0_.periodicity as periodic3_6_0_, logpagevos0_.pageOrder as pageOrder6_0_, logpagevos0_.primaryWindow as primaryW5_6_0_, logpagevos0_.axis as axis6_0_, logpagevos0_.logVersionVO as logVersi7_6_0_ from tblLogPages logpagevos0_ where logpagevos0_.logVersionVO=?
Hibernate: select logsensorb0_.logPageVO as logPageVO1_, logsensorb0_.logSensorId as logSenso1_1_, logsensorb0_.sensorPosition as sensorPo5_1_, logsensorb0_.logSensorId as logSenso1_8_0_, logsensorb0_.sensorName as sensorName8_0_, logsensorb0_.hull as hull8_0_, logsensorb0_.plant as plant8_0_, logsensorb0_.sensorPosition as sensorPo5_8_0_, logsensorb0_.routePosition as routePos6_8_0_, logsensorb0_.sensorMin as sensorMin8_0_, logsensorb0_.sensorMax as sensorMax8_0_, logsensorb0_.sensorUnits as sensorUn9_8_0_, logsensorb0_.normalRange as normalR10_8_0_, logsensorb0_.displayFormat as display11_8_0_, logsensorb0_.defaultValue as default12_8_0_, logsensorb0_.logPageVO as logPageVO8_0_, logsensorb0_2_.calculatedName as calculat2_10_0_, logsensorb0_3_.previousName as previous2_11_0_, logsensorb0_3_.previousType as previous3_11_0_, logsensorb0_3_.previousValue as previous4_11_0_, decode(logsensorb0_.logSensorId, logsensorb0_1_.logSensorId, 1, logsensorb0_2_.logSensorId, 2, logsensorb0_3_.logSensorId, 3, 0) as clazz_0_ from tblSensors logsensorb0_, tblLogSensors logsensorb0_1_, tblCalculatedSensors logsensorb0_2_, tblPreviousSensors logsensorb0_3_ where logsensorb0_.logSensorId=logsensorb0_1_.logSensorId(+) and logsensorb0_.logSensorId=logsensorb0_2_.logSensorId(+) and logsensorb0_.logSensorId=logsensorb0_3_.logSensorId(+) and logsensorb0_.logPageVO=?
Hibernate: select logsensore0_.logSensorVO as logSenso4_1_, logsensore0_.logSensorEnumerationId as logSenso1_1_, logsensore0_.logSensorEnumOrder as logSenso3_1_, logsensore0_.logSensorEnumerationId as logSenso1_12_0_, logsensore0_.description as descript2_12_0_, logsensore0_.logSensorEnumOrder as logSenso3_12_0_, logsensore0_.logSensorVO as logSenso4_12_0_ from tblLogSensorEnumerations logsensore0_ where logsensore0_.logSensorVO=?




I've tried various configurations but I still see it going through this every time.
Is there something I am missing?

Thanks


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 02, 2007 12:45 am 
Newbie

Joined: Mon May 08, 2006 1:01 pm
Posts: 5
Any resolution to this issue?


Top
 Profile  
 
 Post subject: Lazy Loading
PostPosted: Thu Aug 02, 2007 8:11 am 
Newbie

Joined: Thu Jul 19, 2007 3:53 pm
Posts: 7
This issue has been resolved. We originally generated the pojo's via castor. The issue was in modifing the Castor generated code to work with Hibernate. Castor generates collections as ArrayLists and in the setter methods it passes in an Array[] to populate. We modified the setters to accept a List without changing the field definition as an ArrayList so in the setter it was this.myList = new ArrayList(myList);

This caused Hibernate to eager load everything.

Lesson learned the hard way!!

Thanks


Top
 Profile  
 
 Post subject: Same concept different source
PostPosted: Thu Aug 02, 2007 10:07 am 
Newbie

Joined: Mon May 08, 2006 1:01 pm
Posts: 5
We were including a nice little reflection based toString method from jakarta commons: ToStringBuilder

public String toString() {
return ToStringBuilder.reflectionToString(this);
}

When the class was instantiated by hibernate, ToStringBuilder tookover and tried to build the toString method by hitting all the getters in the class - thus eagerly fetching everything.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.