Hibernate Community • View topic - criteria.SetFetchMode is ignored

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

criteria.SetFetchMode is ignored

Page 1 of 1

[ 9 posts ]

Previous topic | Next topic

Author

Message

dircums

Post subject: criteria.SetFetchMode is ignored

Posted: Thu May 18, 2006 6:53 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

I am running a query to generate a simple list and I don't want the object graph to be loaded in this instance. To to this I am setting the FetchMode to lazy for all the relationships as follows:

Code:

ICriteria criteria = localSession.CreateCriteria(typeof (Rfi));
                criteria.Add(Expression.Not(Expression.Eq("RfiStatusID", RfiStatus.SubmittedToProject)));
                criteria.SetFetchMode("Documents", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.AllowedDocumentTypeDocumentSubTypes", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.DocumentNamingFormats", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.AttributeDefinitions", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.AllowedtransmittalTypes", FetchMode.Lazy);
                criteria.SetFetchMode("Transmitall", FetchMode.Lazy);
                //order by status then by RfiID as default sort.
                criteria.AddOrder(new Order("RfiStatusID", true));
                criteria.AddOrder(new Order("RfiID", true));
                criteria.SetResultTransformer(CriteriaUtil.DistinctRootEntity);
                results = criteria.List();

However, I can see in the debug that it is ignoring my SetFetchMode requests and is loading the whole object graph eagerly.

Am I doing something wrong here?

Top

dircums

Post subject:

Posted: Thu May 18, 2006 8:11 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

And in other situations FetchMode.Eager does not work and I have to access members in a collection to force the Lazy load....

Is the FetchMode ignored in favour of the mapping? I wouldn't expect this to be tha case... If I set something programmatically, I would expect it to override any configuration settings.

Top

sergey

Post subject:

Posted: Thu May 18, 2006 8:14 am

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

I think it's not your fault, but I would like to see mappings and logs to be sure.

Top

dircums

Post subject:

Posted: Fri May 19, 2006 8:59 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

OK: Top level mapping for this object:

Code:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" namespace="KBR.LAPD.DocumentManagement.Entities">
  <class name="KBR.LAPD.DocumentManagement.Entities.Rfi, Entities" table="RFI">
    <id name="RfiID" column="RFI_ID">
      <generator class="sequence">
        <param name="sequence">RFI_RFI_ID_SEQ</param>
      </generator>
    </id>
    <version name="Version" column="VERSION"/>
    <property name="RfiName" column="RFI_NAME" />
    <property name="Description" column="RFI_DESC" />
    <property name="RfiStatusID" column="RFI_STATUS_ID" />
    <many-to-one name="TransmittalType" class="KBR.LAPD.DocumentManagement.Entities.TransmittalType, Entities" column="XMTL_TYPE_ID" fetch="select"/>
    <many-to-one name="SubProject" class="KBR.LAPD.DocumentManagement.Entities.SubProject, Entities"  column="SUB_PROJ_ID" outer-join="false" fetch="select" />
    <bag name="Documents"  table="DOC" order-by="DOC_ID" outer-join="false" fetch="join" lazy="true">
      <key column="RFI_ID" />
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.Document, Entities" />      
    </bag>
    <bag name="Transmittals" outer-join="false" fetch="join" table="XMTL" lazy="true" order-by="TransmittalID">
      <key column="RFI_ID" />
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.Transmittal, Entities"/>      
    </bag> 

</class>
</hibernate-mapping>

snippet of log output: As you can see it is loading the Documents collections and, further down the Document.Attributes collections

NHibernate.SqlCommand.SqlSelectBuilder: 2006-05-19 13:44:22,822 [5092] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 12 for the SelectSqlBuilder that needed a capacity of: 14 for the table RFI this
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,822 [5092] DEBUG NHibernate.Impl.SessionImpl - flushing session
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,838 [5092] DEBUG NHibernate.Impl.SessionImpl - Flushing entities and processing referenced collections
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,838 [5092] DEBUG NHibernate.Impl.SessionImpl - Processing unreferenced collections
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,838 [5092] DEBUG NHibernate.Impl.SessionImpl - scheduling collection removes/(re)creates/updates
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,838 [5092] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,838 [5092] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,853 [5092] DEBUG NHibernate.Impl.SessionImpl - dont need to execute flush
NHibernate.Impl.BatcherImpl: 2006-05-19 13:44:22,853 [5092] DEBUG NHibernate.Impl.BatcherImpl - Opened new IDbCommand, open IDbCommands :1
NHibernate.Impl.BatcherImpl: 2006-05-19 13:44:22,853 [5092] DEBUG NHibernate.Impl.BatcherImpl - Building an IDbCommand object for the SqlString: SELECT this.RFI_ID as RFI_ID2_, this.RFI_NAME as RFI_NAME2_, this.RFI_STATUS_ID as RFI_STAT5_2_, this.SUB_PROJ_ID as SUB_PROJ7_2_, this.VERSION as VERSION2_, this.RFI_DESC as RFI_DESC2_, this.XMTL_TYPE_ID as XMTL_TYP6_2_, documents1_.RFI_ID as RFI_ID__, documents1_.DOC_ID as DOC_ID__, documents1_.DOC_ID as DOC_ID0_, documents1_.IS_VALID as IS_VALID0_, documents1_.DOC_STORAGE_ID as DOC_STOR7_0_, documents1_.DOC_SHEET_NUMBER as DOC_SHE11_0_, documents1_.DOC_STORAGE_LOCATION as DOC_STOR6_0_, documents1_.DOC_TITLE as DOC_TITLE0_, documents1_.DOC_REVISION as DOC_REVI8_0_, documents1_.VERSION as VERSION0_, documents1_.DOC_UID as DOC_UID0_, documents1_.DOC_FILENAME as DOC_FILE4_0_, documents1_.RFI_ID as RFI_ID0_, documents1_.DOC_NAME as DOC_NAME0_, documents1_.XMTL_ID as XMTL_ID0_, transmitta2_.XMTL_ID as XMTL_ID1_, transmitta2_.VERSION as VERSION1_, transmitta2_.RFI_ID as RFI_ID1_ FROM RFI this left outer join DOC documents1_ on this.RFI_ID=documents1_.RFI_ID left outer join XMTL transmitta2_ on documents1_.XMTL_ID=transmitta2_.XMTL_ID WHERE this.RFI_STATUS_ID = :this.RFI_STATUS_ID ORDER BY this.RFI_STATUS_ID asc
NHibernate.Loader.Loader: 2006-05-19 13:44:22,853 [5092] INFO NHibernate.Loader.Loader - SELECT this.RFI_ID as RFI_ID2_, this.RFI_NAME as RFI_NAME2_, this.RFI_STATUS_ID as RFI_STAT5_2_, this.SUB_PROJ_ID as SUB_PROJ7_2_, this.VERSION as VERSION2_, this.RFI_DESC as RFI_DESC2_, this.XMTL_TYPE_ID as XMTL_TYP6_2_, documents1_.RFI_ID as RFI_ID__, documents1_.DOC_ID as DOC_ID__, documents1_.DOC_ID as DOC_ID0_, documents1_.IS_VALID as IS_VALID0_, documents1_.DOC_STORAGE_ID as DOC_STOR7_0_, documents1_.DOC_SHEET_NUMBER as DOC_SHE11_0_, documents1_.DOC_STORAGE_LOCATION as DOC_STOR6_0_, documents1_.DOC_TITLE as DOC_TITLE0_, documents1_.DOC_REVISION as DOC_REVI8_0_, documents1_.VERSION as VERSION0_, documents1_.DOC_UID as DOC_UID0_, documents1_.DOC_FILENAME as DOC_FILE4_0_, documents1_.RFI_ID as RFI_ID0_, documents1_.DOC_NAME as DOC_NAME0_, documents1_.XMTL_ID as XMTL_ID0_, transmitta2_.XMTL_ID as XMTL_ID1_, transmitta2_.VERSION as VERSION1_, transmitta2_.RFI_ID as RFI_ID1_ FROM RFI this left outer join DOC documents1_ on this.RFI_ID=documents1_.RFI_ID left outer join XMTL transmitta2_ on documents1_.XMTL_ID=transmitta2_.XMTL_ID WHERE this.RFI_STATUS_ID = :p0 ORDER BY this.RFI_STATUS_ID asc
NHibernate.SQL: 2006-05-19 13:44:22,853 [5092] DEBUG NHibernate.SQL - SELECT this.RFI_ID as RFI_ID2_, this.RFI_NAME as RFI_NAME2_, this.RFI_STATUS_ID as RFI_STAT5_2_, this.SUB_PROJ_ID as SUB_PROJ7_2_, this.VERSION as VERSION2_, this.RFI_DESC as RFI_DESC2_, this.XMTL_TYPE_ID as XMTL_TYP6_2_, documents1_.RFI_ID as RFI_ID__, documents1_.DOC_ID as DOC_ID__, documents1_.DOC_ID as DOC_ID0_, documents1_.IS_VALID as IS_VALID0_, documents1_.DOC_STORAGE_ID as DOC_STOR7_0_, documents1_.DOC_SHEET_NUMBER as DOC_SHE11_0_, documents1_.DOC_STORAGE_LOCATION as DOC_STOR6_0_, documents1_.DOC_TITLE as DOC_TITLE0_, documents1_.DOC_REVISION as DOC_REVI8_0_, documents1_.VERSION as VERSION0_, documents1_.DOC_UID as DOC_UID0_, documents1_.DOC_FILENAME as DOC_FILE4_0_, documents1_.RFI_ID as RFI_ID0_, documents1_.DOC_NAME as DOC_NAME0_, documents1_.XMTL_ID as XMTL_ID0_, transmitta2_.XMTL_ID as XMTL_ID1_, transmitta2_.VERSION as VERSION1_, transmitta2_.RFI_ID as RFI_ID1_ FROM RFI this left outer join DOC documents1_ on this.RFI_ID=documents1_.RFI_ID left outer join XMTL transmitta2_ on documents1_.XMTL_ID=transmitta2_.XMTL_ID WHERE this.RFI_STATUS_ID = :p0 ORDER BY this.RFI_STATUS_ID asc
NHibernate.SQL: 2006-05-19 13:44:22,853 [5092] DEBUG NHibernate.SQL - :p0 = '1'
NHibernate.Connection.DriverConnectionProvider: 2006-05-19 13:44:22,853 [5092] DEBUG NHibernate.Connection.DriverConnectionProvider - Obtaining IDbConnection from Driver
NHibernate.Impl.BatcherImpl: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Impl.BatcherImpl - Opened Reader, open Readers :1
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - processing result set
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - result row: , , 555
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 555
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Rfi#555
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Impl.SessionImpl - Version: 0
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - result set contains (possibly empty) collection: [KBR.LAPD.DocumentManagement.Entities.Rfi.Documents#555]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Impl.SessionImpl - new collection: instantiating
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - result row: 2151, , 782
NHibernate.Loader.Loader: 2006-05-19 13:44:22,869 [5092] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 2151
NHibernate.Loader.Loader: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Document#2151
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Impl.SessionImpl - Version: 3
NHibernate.Loader.Loader: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 782
NHibernate.Loader.Loader: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Rfi#782
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Impl.SessionImpl - Version: 26
NHibernate.Loader.Loader: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Loader.Loader - found row of collection: [KBR.LAPD.DocumentManagement.Entities.Rfi.Documents#782]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Impl.SessionImpl - new collection: instantiating
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Impl.SessionImpl - loading [Document#2151]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Impl.SessionImpl - attempting to resolve [Document#2151]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:22,885 [5092] DEBUG NHibernate.Impl.SessionImpl - resolved object in session cache [KBR.LAPD.DocumentManagement.Entities.Document#2151]

....

NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Impl.SessionImpl - checking second-level cache
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Impl.SessionImpl - collection not cached
NHibernate.Impl.BatcherImpl: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Impl.BatcherImpl - Opened new IDbCommand, open IDbCommands :1
NHibernate.Impl.BatcherImpl: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Impl.BatcherImpl - Building an IDbCommand object for the SqlString: SELECT attributes0_.DOC_ID as DOC_ID__, attributes0_.DOC_ATTR_ID as DOC_ATTR1___, attributes0_.DOC_ATTR_ID as DOC_ATTR1_4_, attributes0_.VERSION as VERSION4_, attributes0_.NAME as NAME4_, attributes0_.DOC_ID as DOC_ID4_, attributes0_.IS_VALID as IS_VALID4_, attributes0_.ATTR_DEF_ID as ATTR_DEF8_4_, attributes0_.VALUE as VALUE4_, attributes0_.VALIDATION_ERR_MSG as VALIDATI6_4_, attributed1_.ATTR_DEF_ID as ATTR_DEF1_0_, attributed1_.DOC_REG_DEF as DOC_REG_7_0_, attributed1_.VISIBLE as VISIBLE0_, attributed1_.DISPLAY_NAME as DISPLAY_4_0_, attributed1_.ALLOWED_VAL_CALC_ID as ALLOWED14_0_, attributed1_.DDD_SEARCH_COL_NAME as DDD_SEA12_0_, attributed1_.VERSION as VERSION0_, attributed1_.IS_REQUIRED as IS_REQU11_0_, attributed1_.IS_DOC_STORAGE_ATTR as IS_DOC_10_0_, attributed1_.DESCR as DESCR0_, attributed1_.DEF_VAL_CALC_ID as DEF_VAL13_0_, attributed1_.DATA_TYPE as DATA_TYPE0_, attributed1_.DOC_STORAGE_DEF as DOC_STOR8_0_, attributed1_.VAL_VALIDATOR_CALC_ID as VAL_VAL15_0_, attributed1_.IS_DOC_REG_ATTR as IS_DOC_R9_0_, attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID as ATTR_ALL1_1_, attributea2_.VERSION as VERSION1_, attributea2_.NAME as NAME1_, attributea2_.TYPE as TYPE1_, attributea2_.DESCR as DESCR1_, attributea2_.ASSEMBLY as ASSEMBLY1_, attributed3_.ATTR_DEF_VAL_CALC_DEF_ID as ATTR_DEF1_2_, attributed3_.VERSION as VERSION2_, attributed3_.NAME as NAME2_, attributed3_.TYPE as TYPE2_, attributed3_.DESCR as DESCR2_, attributed3_.ASSEMBLY as ASSEMBLY2_, attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID as ATTR_VAL1_3_, attributev4_.VERSION as VERSION3_, attributev4_.NAME as NAME3_, attributev4_.TYPE as TYPE3_, attributev4_.DESCR as DESCR3_, attributev4_.ASSEMBLY as ASSEMBLY3_ FROM DOC_ATTR attributes0_ left outer join ATTR_DEF attributed1_ on attributes0_.ATTR_DEF_ID=attributed1_.ATTR_DEF_ID left outer join ATTR_ALLOWED_VAL_CALC_DEF attributea2_ on attributed1_.ALLOWED_VAL_CALC_ID=attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID left outer join ATTR_DEF_VAL_CALC_DEF attributed3_ on attributed1_.DEF_VAL_CALC_ID=attributed3_.ATTR_DEF_VAL_CALC_DEF_ID left outer join ATTR_VAL_VALIDATOR_DEF attributev4_ on attributed1_.VAL_VALIDATOR_CALC_ID=attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID WHERE attributes0_.DOC_ID=:DOC_ID
NHibernate.Loader.Loader: 2006-05-19 13:44:24,275 [5092] INFO NHibernate.Loader.Loader - SELECT attributes0_.DOC_ID as DOC_ID__, attributes0_.DOC_ATTR_ID as DOC_ATTR1___, attributes0_.DOC_ATTR_ID as DOC_ATTR1_4_, attributes0_.VERSION as VERSION4_, attributes0_.NAME as NAME4_, attributes0_.DOC_ID as DOC_ID4_, attributes0_.IS_VALID as IS_VALID4_, attributes0_.ATTR_DEF_ID as ATTR_DEF8_4_, attributes0_.VALUE as VALUE4_, attributes0_.VALIDATION_ERR_MSG as VALIDATI6_4_, attributed1_.ATTR_DEF_ID as ATTR_DEF1_0_, attributed1_.DOC_REG_DEF as DOC_REG_7_0_, attributed1_.VISIBLE as VISIBLE0_, attributed1_.DISPLAY_NAME as DISPLAY_4_0_, attributed1_.ALLOWED_VAL_CALC_ID as ALLOWED14_0_, attributed1_.DDD_SEARCH_COL_NAME as DDD_SEA12_0_, attributed1_.VERSION as VERSION0_, attributed1_.IS_REQUIRED as IS_REQU11_0_, attributed1_.IS_DOC_STORAGE_ATTR as IS_DOC_10_0_, attributed1_.DESCR as DESCR0_, attributed1_.DEF_VAL_CALC_ID as DEF_VAL13_0_, attributed1_.DATA_TYPE as DATA_TYPE0_, attributed1_.DOC_STORAGE_DEF as DOC_STOR8_0_, attributed1_.VAL_VALIDATOR_CALC_ID as VAL_VAL15_0_, attributed1_.IS_DOC_REG_ATTR as IS_DOC_R9_0_, attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID as ATTR_ALL1_1_, attributea2_.VERSION as VERSION1_, attributea2_.NAME as NAME1_, attributea2_.TYPE as TYPE1_, attributea2_.DESCR as DESCR1_, attributea2_.ASSEMBLY as ASSEMBLY1_, attributed3_.ATTR_DEF_VAL_CALC_DEF_ID as ATTR_DEF1_2_, attributed3_.VERSION as VERSION2_, attributed3_.NAME as NAME2_, attributed3_.TYPE as TYPE2_, attributed3_.DESCR as DESCR2_, attributed3_.ASSEMBLY as ASSEMBLY2_, attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID as ATTR_VAL1_3_, attributev4_.VERSION as VERSION3_, attributev4_.NAME as NAME3_, attributev4_.TYPE as TYPE3_, attributev4_.DESCR as DESCR3_, attributev4_.ASSEMBLY as ASSEMBLY3_ FROM DOC_ATTR attributes0_ left outer join ATTR_DEF attributed1_ on attributes0_.ATTR_DEF_ID=attributed1_.ATTR_DEF_ID left outer join ATTR_ALLOWED_VAL_CALC_DEF attributea2_ on attributed1_.ALLOWED_VAL_CALC_ID=attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID left outer join ATTR_DEF_VAL_CALC_DEF attributed3_ on attributed1_.DEF_VAL_CALC_ID=attributed3_.ATTR_DEF_VAL_CALC_DEF_ID left outer join ATTR_VAL_VALIDATOR_DEF attributev4_ on attributed1_.VAL_VALIDATOR_CALC_ID=attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID WHERE attributes0_.DOC_ID=:p0
NHibernate.SQL: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.SQL - SELECT attributes0_.DOC_ID as DOC_ID__, attributes0_.DOC_ATTR_ID as DOC_ATTR1___, attributes0_.DOC_ATTR_ID as DOC_ATTR1_4_, attributes0_.VERSION as VERSION4_, attributes0_.NAME as NAME4_, attributes0_.DOC_ID as DOC_ID4_, attributes0_.IS_VALID as IS_VALID4_, attributes0_.ATTR_DEF_ID as ATTR_DEF8_4_, attributes0_.VALUE as VALUE4_, attributes0_.VALIDATION_ERR_MSG as VALIDATI6_4_, attributed1_.ATTR_DEF_ID as ATTR_DEF1_0_, attributed1_.DOC_REG_DEF as DOC_REG_7_0_, attributed1_.VISIBLE as VISIBLE0_, attributed1_.DISPLAY_NAME as DISPLAY_4_0_, attributed1_.ALLOWED_VAL_CALC_ID as ALLOWED14_0_, attributed1_.DDD_SEARCH_COL_NAME as DDD_SEA12_0_, attributed1_.VERSION as VERSION0_, attributed1_.IS_REQUIRED as IS_REQU11_0_, attributed1_.IS_DOC_STORAGE_ATTR as IS_DOC_10_0_, attributed1_.DESCR as DESCR0_, attributed1_.DEF_VAL_CALC_ID as DEF_VAL13_0_, attributed1_.DATA_TYPE as DATA_TYPE0_, attributed1_.DOC_STORAGE_DEF as DOC_STOR8_0_, attributed1_.VAL_VALIDATOR_CALC_ID as VAL_VAL15_0_, attributed1_.IS_DOC_REG_ATTR as IS_DOC_R9_0_, attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID as ATTR_ALL1_1_, attributea2_.VERSION as VERSION1_, attributea2_.NAME as NAME1_, attributea2_.TYPE as TYPE1_, attributea2_.DESCR as DESCR1_, attributea2_.ASSEMBLY as ASSEMBLY1_, attributed3_.ATTR_DEF_VAL_CALC_DEF_ID as ATTR_DEF1_2_, attributed3_.VERSION as VERSION2_, attributed3_.NAME as NAME2_, attributed3_.TYPE as TYPE2_, attributed3_.DESCR as DESCR2_, attributed3_.ASSEMBLY as ASSEMBLY2_, attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID as ATTR_VAL1_3_, attributev4_.VERSION as VERSION3_, attributev4_.NAME as NAME3_, attributev4_.TYPE as TYPE3_, attributev4_.DESCR as DESCR3_, attributev4_.ASSEMBLY as ASSEMBLY3_ FROM DOC_ATTR attributes0_ left outer join ATTR_DEF attributed1_ on attributes0_.ATTR_DEF_ID=attributed1_.ATTR_DEF_ID left outer join ATTR_ALLOWED_VAL_CALC_DEF attributea2_ on attributed1_.ALLOWED_VAL_CALC_ID=attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID left outer join ATTR_DEF_VAL_CALC_DEF attributed3_ on attributed1_.DEF_VAL_CALC_ID=attributed3_.ATTR_DEF_VAL_CALC_DEF_ID left outer join ATTR_VAL_VALIDATOR_DEF attributev4_ on attributed1_.VAL_VALIDATOR_CALC_ID=attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID WHERE attributes0_.DOC_ID=:p0
NHibernate.SQL: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.SQL - :p0 = '2161'
NHibernate.Impl.BatcherImpl: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Impl.BatcherImpl - Opened Reader, open Readers :1
NHibernate.Loader.Loader: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Loader.Loader - result set contains (possibly empty) collection: [KBR.LAPD.DocumentManagement.Entities.Document.Attributes#2161]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Impl.SessionImpl - uninitialized collection: initializing
NHibernate.Loader.Loader: 2006-05-19 13:44:24,275 [5092] DEBUG NHibernate.Loader.Loader - processing result set
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - result row: 9, , , , 2372
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 2372
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Attribute#2372
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Impl.SessionImpl - Version: 0
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - found row of collection: [KBR.LAPD.DocumentManagement.Entities.Document.Attributes#2161]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Impl.SessionImpl - reading row
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Impl.SessionImpl - loading [Attribute#2372]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Impl.SessionImpl - attempting to resolve [Attribute#2372]
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Impl.SessionImpl - resolved object in session cache [KBR.LAPD.DocumentManagement.Entities.Attribute#2372]
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - result row: 1, , , , 2373
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 2373
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Attribute#2373
NHibernate.Impl.SessionImpl: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Impl.SessionImpl - Version: 0
NHibernate.Loader.Loader: 2006-05-19 13:44:24,291 [5092] DEBUG NHibernate.Loader.Loader - found row of collection: [KBR.LAPD.DocumentManagement.Entities.Document.Attributes#2161]

Top

sergey

Post subject:

Posted: Fri May 19, 2006 10:04 am

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

This looks to me like a log for a different criteria query. It only has one order and one equality condition in the where clause, while the query you showed has an inequality condition and two orders.

Top

dircums

Post subject:

Posted: Fri May 26, 2006 1:22 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

Apologies for the delay in getting the info back ..... I haven't had time this week due to deadline pressures!

Top

dircums

Post subject:

Posted: Fri May 26, 2006 5:33 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

OK: lets start again:

Latest mapping:

Code:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" namespace="KBR.LAPD.DocumentManagement.Entities">
  <class name="KBR.LAPD.DocumentManagement.Entities.Rfi, Entities" table="RFI">
    <id name="RfiID" column="RFI_ID">
      <generator class="sequence">
        <param name="sequence">RFI_RFI_ID_SEQ</param>
      </generator>
    </id>
    <version name="Version" column="VERSION"/>
    <property name="RfiName" column="RFI_NAME" />
    <property name="Description" column="RFI_DESC" />
    <property name="RfiStatusID" column="RFI_STATUS_ID" />
    <property name="PurchaseOrderNumber" column="PO_NUMBER" />
    <property name="TransmittalMethodCode" column="XMTL_MTHD_CODE" />
    <bag name="History" table="RFI_HISTORY" outer-join="true" fetch="join" lazy="false" cascade="all-delete-orphan">
      <key column="RFI_ID"/>
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.RfiAction, Entities"/>      
    </bag>
    <many-to-one name ="Originator" class="KBR.LAPD.DocumentManagement.Entities.User, Entities" column="ORIGINATOR_USER_ID" />
    <many-to-one name ="OwnerGroup" class="KBR.LAPD.DocumentManagement.Entities.Group, Entities" column="OWNER_GROUP_ID" />
    <many-to-one name="TransmittalType" class="KBR.LAPD.DocumentManagement.Entities.TransmittalType, Entities" column="XMTL_TYPE_ID" fetch="select"/>
    <many-to-one name="SubProject" class="KBR.LAPD.DocumentManagement.Entities.SubProject, Entities"  column="SUB_PROJ_ID" outer-join="false" fetch="select" />
    <bag name="Documents"  table="DOC" order-by="DOC_ID" outer-join="true" fetch="join" lazy="false">
      <key column="RFI_ID" />
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.Document, Entities" />      
    </bag>
    <bag name="Transmittals" outer-join="false" fetch="join" table="XMTL" lazy="true" order-by="TransmittalID" cascade="delete">
      <key column="RFI_ID" />
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.Transmittal, Entities"/>      
    </bag>
    <bag name="WorkflowTasks" table="TASK" fetch="join">
      <key column="RFI_ID"/>
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.WorkflowTask, Entities"/>
    </bag>
    
</class>
  
</hibernate-mapping>

Code we are running:

Code:

ICriteria criteria = localSession.CreateCriteria(typeof(Rfi));
                criteria.Add(Expression.Not(Expression.Eq("RfiStatusID", RfiStatus.SubmittedToProject)));
                criteria.SetFetchMode("Documents", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.AllowedDocumentTypeDocumentSubTypes", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.DocumentNamingFormats", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.AttributeDefinitions", FetchMode.Lazy);
                criteria.SetFetchMode("SubProject.AllowedtransmittalTypes", FetchMode.Lazy);
                criteria.SetFetchMode("Transmital", FetchMode.Lazy);
                //order by status then by RfiID as default sort.
                criteria.AddOrder(new Order("RfiStatusID", true));
                criteria.AddOrder(new Order("RfiID", true));
                criteria.SetResultTransformer(CriteriaUtil.DistinctRootEntity);
                results = criteria.List();

Log is in next post:

Top

dircums

Post subject:

Posted: Fri May 26, 2006 5:45 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

Point 1: Note the mapping to SubProject:

Code:

<many-to-one name="SubProject" class="KBR.LAPD.DocumentManagement.Entities.SubProject, Entities"  column="SUB_PROJ_ID" outer-join="false" fetch="select" />

Logs show that we are loading the SubProject and its full object graph:

Quote:

...........SELECT attributed0_.SUB_PROJ_ID as SUB_PROJ1___, attributed0_.ATTR_DEF_ID as ATTR_DEF2___, attributed1_.ATTR_DEF_ID as ATTR_DEF1_0_, attributed1_.DOC_REG_DEF as DOC_REG_7_0_, attributed1_.VISIBLE as VISIBLE0_, attributed1_.DISPLAY_NAME as DISPLAY_4_0_, attributed1_.ALLOWED_VAL_CALC_ID as ALLOWED14_0_, attributed1_.DDD_SEARCH_COL_NAME as DDD_SEA12_0_, attributed1_.VERSION as VERSION0_, attributed1_.IS_REQUIRED as IS_REQU11_0_, attributed1_.IS_DOC_STORAGE_ATTR as IS_DOC_10_0_, attributed1_.DESCR as DESCR0_, attributed1_.DEF_VAL_CALC_ID as DEF_VAL13_0_, attributed1_.DATA_TYPE as DATA_TYPE0_, attributed1_.DOC_STORAGE_DEF as DOC_STOR8_0_, attributed1_.VAL_VALIDATOR_CALC_ID as VAL_VAL15_0_, attributed1_.IS_DOC_REG_ATTR as IS_DOC_R9_0_, attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID as ATTR_ALL1_1_, attributea2_.VERSION as VERSION1_, attributea2_.NAME as NAME1_, attributea2_.TYPE as TYPE1_, attributea2_.DESCR as DESCR1_, attributea2_.ASSEMBLY as ASSEMBLY1_, attributed3_.ATTR_DEF_VAL_CALC_DEF_ID as ATTR_DEF1_2_, attributed3_.VERSION as VERSION2_, attributed3_.NAME as NAME2_, attributed3_.TYPE as TYPE2_, attributed3_.DESCR as DESCR2_, attributed3_.ASSEMBLY as ASSEMBLY2_, attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID as ATTR_VAL1_3_, attributev4_.VERSION as VERSION3_, attributev4_.NAME as NAME3_, attributev4_.TYPE as TYPE3_, attributev4_.DESCR as DESCR3_, attributev4_.ASSEMBLY as ASSEMBLY3_ FROM SUB_PROJ_ATTR_DEF attributed0_ inner join ATTR_DEF attributed1_ on attributed0_.ATTR_DEF_ID=attributed1_.ATTR_DEF_ID left outer join ATTR_ALLOWED_VAL_CALC_DEF attributea2_ on attributed1_.ALLOWED_VAL_CALC_ID=attributea2_.ATTR_ALLOWED_VAL_CALC_DEF_ID left outer join ATTR_DEF_VAL_CALC_DEF attributed3_ on attributed1_.DEF_VAL_CALC_ID=attributed3_.ATTR_DEF_VAL_CALC_DEF_ID left outer join ATTR_VAL_VALIDATOR_DEF attributev4_ on attributed1_.VAL_VALIDATOR_CALC_ID=attributev4_.ATTR_VAL_VALIDATOR_CALC_DEF_ID WHERE attributed0_.SUB_PROJ_ID=:p0
NHibernate.SQL: 2006-05-26 10:30:03,370 [3988] DEBUG NHibernate.SQL - :p0 = '595'
NHibernate.Loader.Loader: 2006-05-26 10:30:03,370 [3988] DEBUG NHibernate.Loader.Loader - result set contains (possibly empty) collection: [KBR.LAPD.DocumentManagement.Entities.SubProject.AttributeDefinitions#595] .........

Top

dircums

Post subject:

Posted: Fri May 26, 2006 5:50 am

Beginner

Joined: Tue Jan 17, 2006 12:55 pm
Posts: 49

Point 2: I specify loading of the Documents collection to be lazy, yet the full object graph for documents is also loaded.

Now I think this may be because I am specifying outer-join = true
However, I would expect that if explicitly set FetchMode to lazy, then we would not do an outer join or attempt any other form of loading the collection....

Code:

<bag name="Documents"  table="DOC" order-by="DOC_ID" outer-join="true" fetch="join" lazy="false">
      <key column="RFI_ID" />
      <one-to-many class="KBR.LAPD.DocumentManagement.Entities.Document, Entities" />      
    </bag>

Quote:

......
NHibernate.Loader.Loader: 2006-05-26 10:29:59,729 [3988] INFO NHibernate.Loader.Loader - SELECT documents0_.RFI_ID as RFI_ID__, documents0_.DOC_ID as DOC_ID__, documents0_.DOC_ID as DOC_ID10_, documents0_.DOC_TYPE_ID as DOC_TYP12_10_, documents0_.DOC_NAME as DOC_NAME10_, documents0_.VERSION as VERSION10_, documents0_.DOC_SUB_TYPE_ID as DOC_SUB13_10_, documents0_.DOC_DISC_ID as DOC_DIS17_10_, documents0_.DOC_STORAGE_LOCATION as DOC_STOR6_10_, documents0_.DOC_TITLE as DOC_TITLE10_, documents0_.XMTL_ID as XMTL_ID10_, documents0_.DOC_STORAGE_ID as DOC_STOR7_10_, documents0_.DOC_UID as DOC_UID10_, documents0_.RFI_ID as RFI_ID10_, documents0_.DOC_ORG_ID as DOC_ORG_ID10_, documents0_.DOC_REVISION as DOC_REVI8_10_, documents0_.DOC_SHEET_NUMBER as DOC_SHE11_10_, documents0_.DOC_FILENAME as DOC_FILE4_10_, documents0_.IS_VALID as IS_VALID10_, documentty1_.DOC_TYPE_ID as DOC_TYPE1_0_, documentty1_.VERSION as VERSION0_, documentty1_.DOC_TYPE_DESC as DOC_TYPE3_0_, documentty1_.DOC_GROUP_ID as DOC_GROU6_0_, documentty1_.DOC_TYPE_SRC_SYS_CODE as DOC_TYPE4_0_, documentty1_.DOC_TYPE_IS_ACTIVE as DOC_TYPE5_0_, documentgr2_.DOC_GROUP_ID as DOC_GROU1_1_, documentgr2_.VERSION as VERSION1_, documentgr2_.DOC_GROUP_NAME as DOC_GROU3_1_, documentsu3_.DOC_SUB_TYPE_ID as DOC_SUB_1_2_, documentsu3_.VERSION as VERSION2_, documentsu3_.DOC_SUB_TYPE_CODE as DOC_SUB_3_2_, documentsu3_.DOC_SUB_TYPE_DESC as DOC_SUB_4_2_, documentsu3_.IS_ACTIVE as IS_ACTIVE2_, discipline4_.DISC_ID as DISC_ID3_, discipline4_.VERSION as VERSION3_, discipline4_.DISC_CODE as DISC_CODE3_, discipline4_.DISC_IS_ACTIVE as DISC_IS_4_3_, transmitta5_.XMTL_ID as XMTL_ID4_, transmitta5_.VERSION as VERSION4_, transmitta5_.NOTES as NOTES4_, transmitta5_.RFI_ID as RFI_ID4_, rfi6_.RFI_ID as RFI_ID5_, rfi6_.RFI_NAME as RFI_NAME5_, rfi6_.OWNER_GROUP_ID as OWNER_GR9_5_, rfi6_.ORIGINATOR_USER_ID as ORIGINAT8_5_, rfi6_.SUB_PROJ_ID as SUB_PRO11_5_, rfi6_.RFI_STATUS_ID as RFI_STAT5_5_, rfi6_.VERSION as VERSION5_, rfi6_.RFI_DESC as RFI_DESC5_, rfi6_.XMTL_TYPE_ID as XMTL_TY10_5_, group7_.APP_GROUP_ID as APP_GROU1_6_, group7_.GROUP_IS_ACTIVE as GROUP_IS5_6_, group7_.GROUP_SYS_SRC_ID as GROUP_SY4_6_, group7_.VERSION as VERSION6_, group7_.APP_GROUP_NAME as APP_GROU3_6_, user8_.USER_ID as USER_ID7_, user8_.USER_PWD_Q as USER_PWD_Q7_, user8_.USER_PWD as USER_PWD7_, user8_.USER_LAST_NAME as USER_LA16_7_, user8_.USER_LAST_LOCKOUT as USER_LA15_7_, user8_.USER_LAST_PWD_CHANGE as USER_LA14_7_, user8_.VERSION as VERSION7_, user8_.USER_DISPLAY_NAME as USER_DIS3_7_, user8_.USER_PWD_A as USER_PWD_A7_, user8_.USER_IS_APPROVED as USER_IS_8_7_, user8_.USER_LAST_LOGIN as USER_LA12_7_, user8_.USER_SYS_SRC_ID as USER_SY19_7_, user8_.USER_IS_LOCKED_OUT as USER_IS_9_7_, user8_.USER_FIRST_NAME as USER_FIR5_7_, user8_.USER_EMAIL as USER_EMAIL7_, user8_.USER_LOGIN as USER_LOGIN7_, user8_.USER_CREATION_DATE as USER_CR11_7_, user8_.USER_LAST_ACTIVITY as USER_LA13_7_, user8_.USER_COMMENT as USER_CO10_7_, user8_.USER_IS_ACTIVE as USER_IS20_7_, organisati9_.ORG_ID as ORG_ID8_, organisati9_.VERSION as VERSION8_, organisati9_.ORG_CODE as ORG_CODE8_, organisati9_.ORG_DESCRIPTION as ORG_DESC4_8_, organisati9_.ORG_IS_ACTIVE as ORG_IS_A5_8_, organisati9_.PROJECT_ID as PROJECT_ID8_, project10_.PROJECT_ID as PROJECT_ID9_, project10_.VERSION as VERSION9_, project10_.PROJECT_NAME as PROJECT_3_9_, project10_.PROJECT_SYS_SRC_ID as PROJECT_4_9_ FROM DOC documents0_ left outer join DOC_TYPE documentty1_ on documents0_.DOC_TYPE_ID=documentty1_.DOC_TYPE_ID left outer join DOC_GROUP documentgr2_ on documentty1_.DOC_GROUP_ID=documentgr2_.DOC_GROUP_ID left outer join DOC_SUB_TYPE documentsu3_ on documents0_.DOC_SUB_TYPE_ID=documentsu3_.DOC_SUB_TYPE_ID left outer join DISCIPLINE discipline4_ on documents0_.DOC_DISC_ID=discipline4_.DISC_ID left outer join XMTL transmitta5_ on documents0_.XMTL_ID=transmitta5_.XMTL_ID left outer join RFI rfi6_ on transmitta5_.RFI_ID=rfi6_.RFI_ID left outer join APP_GROUP group7_ on rfi6_.OWNER_GROUP_ID=group7_.APP_GROUP_ID left outer join APP_USER user8_ on rfi6_.ORIGINATOR_USER_ID=user8_.USER_ID left outer join ORGANISATION organisati9_ on documents0_.DOC_ORG_ID=organisati9_.ORG_ID left outer join PROJECT project10_ on organisati9_.PROJECT_ID=project10_.PROJECT_ID WHERE documents0_.RFI_ID=:p0 ORDER BY documents0_.DOC_ID
NHibernate.SQL: 2006-05-26 10:29:59,729 [3988] DEBUG NHibernate.SQL - SELECT documents0_.RFI_ID as RFI_ID__, documents0_.DOC_ID as DOC_ID__, documents0_.DOC_ID as DOC_ID10_, documents0_.DOC_TYPE_ID as DOC_TYP12_10_, documents0_.DOC_NAME as DOC_NAME10_, documents0_.VERSION as VERSION10_, documents0_.DOC_SUB_TYPE_ID as DOC_SUB13_10_, documents0_.DOC_DISC_ID as DOC_DIS17_10_, documents0_.DOC_STORAGE_LOCATION as DOC_STOR6_10_, documents0_.DOC_TITLE as DOC_TITLE10_, documents0_.XMTL_ID as XMTL_ID10_, documents0_.DOC_STORAGE_ID as DOC_STOR7_10_, documents0_.DOC_UID as DOC_UID10_, documents0_.RFI_ID as RFI_ID10_, documents0_.DOC_ORG_ID as DOC_ORG_ID10_, documents0_.DOC_REVISION as DOC_REVI8_10_, documents0_.DOC_SHEET_NUMBER as DOC_SHE11_10_, documents0_.DOC_FILENAME as DOC_FILE4_10_, documents0_.IS_VALID as IS_VALID10_, documentty1_.DOC_TYPE_ID as DOC_TYPE1_0_, documentty1_.VERSION as VERSION0_, documentty1_.DOC_TYPE_DESC as DOC_TYPE3_0_, documentty1_.DOC_GROUP_ID as DOC_GROU6_0_, documentty1_.DOC_TYPE_SRC_SYS_CODE as DOC_TYPE4_0_, documentty1_.DOC_TYPE_IS_ACTIVE as DOC_TYPE5_0_, documentgr2_.DOC_GROUP_ID as DOC_GROU1_1_, documentgr2_.VERSION as VERSION1_, documentgr2_.DOC_GROUP_NAME as DOC_GROU3_1_, documentsu3_.DOC_SUB_TYPE_ID as DOC_SUB_1_2_, documentsu3_.VERSION as VERSION2_, documentsu3_.DOC_SUB_TYPE_CODE as DOC_SUB_3_2_, documentsu3_.DOC_SUB_TYPE_DESC as DOC_SUB_4_2_, documentsu3_.IS_ACTIVE as IS_ACTIVE2_, discipline4_.DISC_ID as DISC_ID3_, discipline4_.VERSION as VERSION3_, discipline4_.DISC_CODE as DISC_CODE3_, discipline4_.DISC_IS_ACTIVE as DISC_IS_4_3_, transmitta5_.XMTL_ID as XMTL_ID4_, transmitta5_.VERSION as VERSION4_, transmitta5_.NOTES as NOTES4_, transmitta5_.RFI_ID as RFI_ID4_, rfi6_.RFI_ID as RFI_ID5_, rfi6_.RFI_NAME as RFI_NAME5_, rfi6_.OWNER_GROUP_ID as OWNER_GR9_5_, rfi6_.ORIGINATOR_USER_ID as ORIGINAT8_5_, rfi6_.SUB_PROJ_ID as SUB_PRO11_5_, rfi6_.RFI_STATUS_ID as RFI_STAT5_5_, rfi6_.VERSION as VERSION5_, rfi6_.RFI_DESC as RFI_DESC5_, rfi6_.XMTL_TYPE_ID as XMTL_TY10_5_, group7_.APP_GROUP_ID as APP_GROU1_6_, group7_.GROUP_IS_ACTIVE as GROUP_IS5_6_, group7_.GROUP_SYS_SRC_ID as GROUP_SY4_6_, group7_.VERSION as VERSION6_, group7_.APP_GROUP_NAME as APP_GROU3_6_, user8_.USER_ID as USER_ID7_, user8_.USER_PWD_Q as USER_PWD_Q7_, user8_.USER_PWD as USER_PWD7_, user8_.USER_LAST_NAME as USER_LA16_7_, user8_.USER_LAST_LOCKOUT as USER_LA15_7_, user8_.USER_LAST_PWD_CHANGE as USER_LA14_7_, user8_.VERSION as VERSION7_, user8_.USER_DISPLAY_NAME as USER_DIS3_7_, user8_.USER_PWD_A as USER_PWD_A7_, user8_.USER_IS_APPROVED as USER_IS_8_7_, user8_.USER_LAST_LOGIN as USER_LA12_7_, user8_.USER_SYS_SRC_ID as USER_SY19_7_, user8_.USER_IS_LOCKED_OUT as USER_IS_9_7_, user8_.USER_FIRST_NAME as USER_FIR5_7_, user8_.USER_EMAIL as USER_EMAIL7_, user8_.USER_LOGIN as USER_LOGIN7_, user8_.USER_CREATION_DATE as USER_CR11_7_, user8_.USER_LAST_ACTIVITY as USER_LA13_7_, user8_.USER_COMMENT as USER_CO10_7_, user8_.USER_IS_ACTIVE as USER_IS20_7_, organisati9_.ORG_ID as ORG_ID8_, organisati9_.VERSION as VERSION8_, organisati9_.ORG_CODE as ORG_CODE8_, organisati9_.ORG_DESCRIPTION as ORG_DESC4_8_, organisati9_.ORG_IS_ACTIVE as ORG_IS_A5_8_, organisati9_.PROJECT_ID as PROJECT_ID8_, project10_.PROJECT_ID as PROJECT_ID9_, project10_.VERSION as VERSION9_, project10_.PROJECT_NAME as PROJECT_3_9_, project10_.PROJECT_SYS_SRC_ID as PROJECT_4_9_ FROM DOC documents0_ left outer join DOC_TYPE documentty1_ on documents0_.DOC_TYPE_ID=documentty1_.DOC_TYPE_ID left outer join DOC_GROUP documentgr2_ on documentty1_.DOC_GROUP_ID=documentgr2_.DOC_GROUP_ID left outer join DOC_SUB_TYPE documentsu3_ on documents0_.DOC_SUB_TYPE_ID=documentsu3_.DOC_SUB_TYPE_ID left outer join DISCIPLINE discipline4_ on documents0_.DOC_DISC_ID=discipline4_.DISC_ID left outer join XMTL transmitta5_ on documents0_.XMTL_ID=transmitta5_.XMTL_ID left outer join RFI rfi6_ on transmitta5_.RFI_ID=rfi6_.RFI_ID left outer join APP_GROUP group7_ on rfi6_.OWNER_GROUP_ID=group7_.APP_GROUP_ID left outer join APP_USER user8_ on rfi6_.ORIGINATOR_USER_ID=user8_.USER_ID left outer join ORGANISATION organisati9_ on documents0_.DOC_ORG_ID=organisati9_.ORG_ID left outer join PROJECT project10_ on organisati9_.PROJECT_ID=project10_.PROJECT_ID WHERE documents0_.RFI_ID=:p0 ORDER BY documents0_.DOC_ID
NHibernate.SQL: 2006-05-26 10:29:59,729 [3988] DEBUG NHibernate.SQL - :p0 = '782'
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - result set contains (possibly empty) collection: [KBR.LAPD.DocumentManagement.Entities.Rfi.Documents#782]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - uninitialized collection: initializing
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - processing result set
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - result row: , , , , , , , , , , 1733
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 1733
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Document#1733
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - Version: 38
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - found row of collection: [KBR.LAPD.DocumentManagement.Entities.Rfi.Documents#782]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - reading row
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - loading [Document#1733]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - attempting to resolve [Document#1733]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - resolved object in session cache [KBR.LAPD.DocumentManagement.Entities.Document#1733]
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - result row: , , , , , , , , , , 1734
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - Initializing object from DataReader: 1734
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - Hydrating entity: KBR.LAPD.DocumentManagement.Entities.Document#1734
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - Version: 38
NHibernate.Loader.Loader: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Loader.Loader - found row of collection: [KBR.LAPD.DocumentManagement.Entities.Rfi.Documents#782]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - reading row
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - loading [Document#1734]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - attempting to resolve [Document#1734]
NHibernate.Impl.SessionImpl: 2006-05-26 10:29:59,745 [3988] DEBUG NHibernate.Impl.SessionImpl - resolved object in session cache [KBR.LAPD.DocumentManagement.Entities.Document#1734]
.....

Top

Page 1 of 1

[ 9 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

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