Hi,

I have a problem with migrating an exsisting access-ctrl model of our to hibernate. The problem is that hibernate seams to get stuck in an infinite loop of queries ( or at least a very long loop.. can't let it loop to long since it's not a local/private db). Here's an overview of my model.



The problem occurs when I e.g. do a find or get of UserProfileDTOs. If I set lazy="true" on the bag of AccessRoleReferences in UserProfileDTO mapping it works fine but unfortunatly I cannot have lazy loading in this case since I cannot keep the session open for the entire life of the UserProfileDTO. I have elaborated with the inverse and outer-join attributes in my mapping files but nothing seams to solve the problem. I have also tried different hibernate.max_fetch_depth but that doesn't do any difference at all?

I'd appreciate all input that can shine some light on this problem.

Mapping files and sql output is pasted below

tnx

/andreas

Hibernate version: 2.1.8

Mapping documents:
<class name="se.marakanda.maccess.entity.model.UserProfileDTO" table="SYTUSERPROFILE" >
<id name="did" type="long" unsaved-value="0" column="USERPROFILEDID">
<generator class="sequence">
<param name="sequence">SEQ_MACCESS_DEFAULT</param>
</generator>
</id>
<property name="partyshipDID" type="long" column="PARTYSHIPDID" not-null="true" length="22"/>
<property name="ownerName" type="java.lang.String" column="OWNERNAME" length="80" />
<property name="lastUsed" type="java.util.Date" column="LASTUSEDDATE" length="7" />
<property name="disabled" type="boolean" column="DISABLED" length="22" />
<!-- bi-directional one-to-many association to Sytacl -->
<bag name="accessRoleReferencesSet" lazy="false" inverse="true" cascade="all-delete-orphan">
<key column="USERPROFILEDID"/>
<one-to-many class="se.marakanda.maccess.entity.model.AccessRoleReferenceDTO"/>
</bag>
<!-- bi-directional many-to-one association to Sytrealmuser -->
<many-to-one name="realmUser" class="se.marakanda.maccess.entity.model.RealmUserDTO" cascade="all" not-null="true">
<column name="REALMUSERDID" />
</many-to-one>
</class>

<class name="se.marakanda.maccess.entity.model.AccessRoleReferenceDTO" table="SYTACL">
<id name="accessRoleReferenceDID" type="long" unsaved-value="0" column="ACLDID">
<generator class="sequence">
<param name="sequence">SEQ_MACCESS_DEFAULT</param>
</generator>
</id>
<property name="validFrom" type="java.util.Date" column="VALIDFROM" length="7" />
<property name="validTo" type="java.util.Date" column="VALIDUNTIL" length="7" />
<!-- bi-directional many-to-one association to Sytuserprofile -->
<many-to-one name="userProfile" class="se.marakanda.maccess.entity.model.UserProfileDTO" outer-join="false" not-null="true">
<column name="USERPROFILEDID" />
</many-to-one>
<!-- bi-directional many-to-one association to Sytaccessrole -->
<many-to-one name="accessRole" class="se.marakanda.maccess.entity.model.AccessRoleDTO" not-null="true">
<column name="ACCESSROLEDID" />
</many-to-one>
</class>

<class name="se.marakanda.maccess.entity.model.AccessRoleDTO" table="SYTACCESSROLE" >
<id name="did" type="long" unsaved-value="0" column="ACCESSROLEDID">
<generator class="sequence">
<param name="sequence">SEQ_MACCESS_DEFAULT</param>
</generator>
</id>
<property name="accessRole" type="java.lang.String" column="ACCESSROLE" not-null="true" length="80"/>
<property name="isDefaultRole" type="boolean" column="ISDEFAULTROLE" length="22" />
<property name="companyDID" type="long" column="COMPANYDID" not-null="true" length="22" />
<!-- bi-directional one-to-many association to Sytfuncaccess -->
<set name="functionReferencesSet" lazy="false" inverse="true" cascade="none">
<key column="ACCESSROLEDID" />
<one-to-many class="se.marakanda.maccess.entity.model.FunctionReferenceDTO" />
</set>
<!-- bi-directional one-to-many association to Sytacl -->
<set name="accessRoleReferencesSet" lazy="false" inverse="true" cascade="none">
<key column="ACCESSROLEDID" />
<one-to-many class="se.marakanda.maccess.entity.model.AccessRoleReferenceDTO" />
</set>
</class>

<class name="se.marakanda.maccess.entity.model.FunctionReferenceDTO" table="SYTFUNCACCESS">
<id name="did" type="long" column="FUNCACCESSDID">
<generator class="sequence">
<param name="sequence">SEQ_MACCESS_DEFAULT</param>
</generator>
</id>
<!-- bi-directional many-to-one association to Syxfunc -->
<many-to-one name="function" class="se.marakanda.maccess.entity.model.FunctionDTO" not-null="true">
<column name="FUNCDID" />
</many-to-one>
<!-- bi-directional many-to-one association to Sytaccessrole -->
<many-to-one name="accessRole" class="se.marakanda.maccess.entity.model.AccessRoleDTO" outer-join="false" not-null="true">
<column name="ACCESSROLEDID" />
</many-to-one>
</class>

<class name="se.marakanda.maccess.entity.model.FunctionDTO" table="SYXFUNC">
<id name="did" type="long" column="FUNCDID">
<generator class="sequence">
<param name="sequence">SEQ_MACCESS_DEFAULT</param>
</generator>
</id>
<property name="name" type="java.lang.String" column="FUNCCODE" not-null="true" unique="true" length="80"/>
<property name="labelKey" type="java.lang.String" column="LABELKEY" not-null="true" length="80" />
<property name="bundle" type="java.lang.String" column="BUNDLE" not-null="true" length="18" />
</class>

Name and version of the database you are using: Oracle 8.1.7

The generated SQL (show_sql=true):

Hibernate: select this.USERPROFILEDID as USERPROF1_1_, this.PARTYSHIPDID as PARTYSHI2_1_, this.OWNERNAME as OWNERNAME1_, this.LASTUSEDDATE as LASTUSED4_1_, this.DISABLED as DISABLED1_, this.REALMUSERDID as REALMUSE6_1_, x0_.REALMUSERDID as REALMUSE1_0_, x0_.USERID as USERID0_, x0_.PWD as PWD0_, x0_.PWDHINT as PWDHINT0_, x0_.PWDLASTCHANGE as PWDLASTC5_0_, x0_.LANGUAGECODE as LANGUAGE6_0_, x0_.COUNTRYCODE as COUNTRYC7_0_, x0_.VARIANT as VARIANT0_, x0_.LASTUSEDDATE as LASTUSED9_0_, x0_.DISABLED as DISABLED0_, x0_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE this, SYTREALMUSER x0_ where x0_.USERID like ? and this.REALMUSERDID=x0_.REALMUSERDID
Hibernate: select accessrole0_.USERPROFILEDID as USERPROF4___, accessrole0_.ACLDID as ACLDID__, accessrole0_.ACLDID as ACLDID1_, accessrole0_.VALIDFROM as VALIDFROM1_, accessrole0_.VALIDUNTIL as VALIDUNTIL1_, accessrole0_.USERPROFILEDID as USERPROF4_1_, accessrole0_.ACCESSROLEDID as ACCESSRO5_1_, accessrole1_.ACCESSROLEDID as ACCESSRO1_0_, accessrole1_.ACCESSROLE as ACCESSROLE0_, accessrole1_.ISDEFAULTROLE as ISDEFAUL3_0_, accessrole1_.COMPANYDID as COMPANYDID0_ from SYTACL accessrole0_, SYTACCESSROLE accessrole1_ where accessrole0_.USERPROFILEDID=? and accessrole0_.ACCESSROLEDID=accessrole1_.ACCESSROLEDID(+)
Hibernate: select accessrole0_.USERPROFILEDID as USERPROF4___, accessrole0_.ACLDID as ACLDID__, accessrole0_.ACLDID as ACLDID1_, accessrole0_.VALIDFROM as VALIDFROM1_, accessrole0_.VALIDUNTIL as VALIDUNTIL1_, accessrole0_.USERPROFILEDID as USERPROF4_1_, accessrole0_.ACCESSROLEDID as ACCESSRO5_1_, accessrole1_.ACCESSROLEDID as ACCESSRO1_0_, accessrole1_.ACCESSROLE as ACCESSROLE0_, accessrole1_.ISDEFAULTROLE as ISDEFAUL3_0_, accessrole1_.COMPANYDID as COMPANYDID0_ from SYTACL accessrole0_, SYTACCESSROLE accessrole1_ where accessrole0_.USERPROFILEDID=? and accessrole0_.ACCESSROLEDID=accessrole1_.ACCESSROLEDID(+)
Hibernate: select functionre0_.ACCESSROLEDID as ACCESSRO3___, functionre0_.FUNCACCESSDID as FUNCACCE1___, functionre0_.FUNCACCESSDID as FUNCACCE1_1_, functionre0_.FUNCDID as FUNCDID1_, functionre0_.ACCESSROLEDID as ACCESSRO3_1_, functiondt1_.FUNCDID as FUNCDID0_, functiondt1_.FUNCCODE as FUNCCODE0_, functiondt1_.LABELKEY as LABELKEY0_, functiondt1_.BUNDLE as BUNDLE0_ from SYTFUNCACCESS functionre0_, SYXFUNC functiondt1_ where functionre0_.ACCESSROLEDID=? and functionre0_.FUNCDID=functiondt1_.FUNCDID(+)
Hibernate: select accessrole0_.ACCESSROLEDID as ACCESSRO5___, accessrole0_.ACLDID as ACLDID__, accessrole0_.ACLDID as ACLDID0_, accessrole0_.VALIDFROM as VALIDFROM0_, accessrole0_.VALIDUNTIL as VALIDUNTIL0_, accessrole0_.USERPROFILEDID as USERPROF4_0_, accessrole0_.ACCESSROLEDID as ACCESSRO5_0_ from SYTACL accessrole0_ where accessrole0_.ACCESSROLEDID=?
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select functionre0_.ACCESSROLEDID as ACCESSRO3___, functionre0_.FUNCACCESSDID as FUNCACCE1___, functionre0_.FUNCACCESSDID as FUNCACCE1_1_, functionre0_.FUNCDID as FUNCDID1_, functionre0_.ACCESSROLEDID as ACCESSRO3_1_, functiondt1_.FUNCDID as FUNCDID0_, functiondt1_.FUNCCODE as FUNCCODE0_, functiondt1_.LABELKEY as LABELKEY0_, functiondt1_.BUNDLE as BUNDLE0_ from SYTFUNCACCESS functionre0_, SYXFUNC functiondt1_ where functionre0_.ACCESSROLEDID=? and functionre0_.FUNCDID=functiondt1_.FUNCDID(+)
Hibernate: select accessrole0_.ACCESSROLEDID as ACCESSRO5___, accessrole0_.ACLDID as ACLDID__, accessrole0_.ACLDID as ACLDID0_, accessrole0_.VALIDFROM as VALIDFROM0_, accessrole0_.VALIDUNTIL as VALIDUNTIL0_, accessrole0_.USERPROFILEDID as USERPROF4_0_, accessrole0_.ACCESSROLEDID as ACCESSRO5_0_ from SYTACL accessrole0_ where accessrole0_.ACCESSROLEDID=?
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
Hibernate: select userprofil0_.USERPROFILEDID as USERPROF1_1_, userprofil0_.PARTYSHIPDID as PARTYSHI2_1_, userprofil0_.OWNERNAME as OWNERNAME1_, userprofil0_.LASTUSEDDATE as LASTUSED4_1_, userprofil0_.DISABLED as DISABLED1_, userprofil0_.REALMUSERDID as REALMUSE6_1_, realmuserd1_.REALMUSERDID as REALMUSE1_0_, realmuserd1_.USERID as USERID0_, realmuserd1_.PWD as PWD0_, realmuserd1_.PWDHINT as PWDHINT0_, realmuserd1_.PWDLASTCHANGE as PWDLASTC5_0_, realmuserd1_.LANGUAGECODE as LANGUAGE6_0_, realmuserd1_.COUNTRYCODE as COUNTRYC7_0_, realmuserd1_.VARIANT as VARIANT0_, realmuserd1_.LASTUSEDDATE as LASTUSED9_0_, realmuserd1_.DISABLED as DISABLED0_, realmuserd1_.FORCEPASSWORDCHANGE as FORCEPA11_0_ from SYTUSERPROFILE userprofil0_, SYTREALMUSER realmuserd1_ where userprofil0_.USERPROFILEDID=? and userprofil0_.REALMUSERDID=realmuserd1_.REALMUSERDID(+)
...
...

I am having the same problem as well. I set lazy=true in my mapping and it retrieves things properly until I try to get one of the lazy loaded items. I have had a loop of queries running for the last 5 mins - I finally terminated the app.


Any Ideas?? Please help