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