-->
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.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 9 posts ] 
  Previous topic | Next topic 
Author Message
harrychou
 Post subject: Self-referencing table/class mapping
PostPosted: Tue Aug 09, 2005 10:07 pm 
Newbie

Joined: Tue Aug 09, 2005 9:55 pm
Posts: 4
:lol:

I am new to NHibernate. I am trying to do a class with self-referencing table structure. It's similar to the Department-subDepartments structure.

The problem is that my ChildDomain list never get populated.

Here is my class:

Code:
using System;
using System.Collections;

namespace MyTest
{
   public class SecurityDomain
   {
      private long m_ID;
      private string m_Name;

      private SecurityDomain m_ParentDomain;
      private IList m_ChildDomains;

      public SecurityDomain()
      {
      }

      public long Id
      {
         get { return m_ID; }
         set { m_ID = value; }
      }

      public string Name
      {
         get { return m_Name; }
         set { m_Name = value; }
      }

      public SecurityDomain ParentDomain
      {
         get { return m_ParentDomain; }
         set { m_ParentDomain = value; }
      }

      public IList ChildDomains
      {
         get
         {
            if (m_ChildDomains == null)
            {
               m_ChildDomains = new ArrayList();
            }
            return m_ChildDomains;
         }
         set {m_ChildDomains = value;}
      }

   }
}

Here is my mapping:

Code:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
   <class name="MyTest.SecurityDomain, MyTest" table="Security_Domain">
      <id name="Id" column="Security_Domain_Key" type="Int64" unsaved-value="-1">
         <generator class="identity"/>
      </id>
      <property name="Name" column= "Domain_Name" type="String" length="100"/>
      <bag
         name="ChildDomains"
         order-by="Legacy_Region_Num"
         lazy="false"
         cascade="all">
         <key column="Parent_Domain_Key" />
         <one-to-many class="MyTest.SecurityDomain, MyTest" />
      </bag>
      
      <many-to-one name="ParentDomain" column="Parent_Domain_Key" not-null="false" />
   </class>

</hibernate-mapping>


Here is my UnitTest, the test failed and the output shows the count is 0:

Code:
      [Test]
      public void TestLoading()
      {
         Configuration cfg = new Configuration();
         cfg.AddAssembly("MyTest");

         System.Data.IDbConnection conn = new System.Data.SqlClient.SqlConnection("data source=localhost;initial catalog=TestDB;User ID=userID;Password=pwd");

         ISessionFactory factory = cfg.BuildSessionFactory();
         ISession session = factory.OpenSession(conn);

         conn.Open();

         SecurityDomain aDomain = (SecurityDomain)session.Load(typeof(SecurityDomain), 1);

         Assert.AreEqual("Name", aDomain .Name);

         Console.WriteLine(aDomain .ChildDomains.Count);

         Assert.IsTrue(aDomain .ChildDomains.Count > 0);

         conn.Close();

         session.Close();
      }


I would be much appreciated if anyone can give me some advices.


Last edited by harrychou on Wed Aug 10, 2005 10:39 am, edited 1 time in total.

Top
 Profile  
 
KPixel
 Post subject:
PostPosted: Wed Aug 10, 2005 10:30 am 
Contributor
Contributor

Joined: Thu May 12, 2005 9:45 am
Posts: 593
Location: nhibernate.org
Replace
Code:
<one-to-many class="MyTest, MyTest" />

by
Code:
<one-to-many class="MyTest.SecurityDomain, MyTest" />

_________________
Pierre Henri Kuaté.
Get NHibernate in Action Now!

Top
 Profile  
 
harrychou
 Post subject:
PostPosted: Wed Aug 10, 2005 10:48 am 
Newbie

Joined: Tue Aug 09, 2005 9:55 pm
Posts: 4
Thank you. I modified my origional posting. Unfortunately, it is not the cause of my problem. I have the log (posted here), but I cannot understand it. It seems like NHibernate keeps trying to initialize my collection... I traced my database call, and it did call the database and get 5 child rows back.

Code:
[2005-08-10 10:45:37,357] INFO NHibernate.Cfg.Configuration - searching for mapped documents in assembly: MyTest
[2005-08-10 10:45:37,367] INFO NHibernate.Cfg.Configuration - Found mapping documents in assembly: MyTest.User.hbm.xml
[2005-08-10 10:45:37,617] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2000Dialect
[2005-08-10 10:45:37,647] INFO NHibernate.Cfg.Binder - Mapping class: MyTest.User -> users
[2005-08-10 10:45:37,667] INFO NHibernate.Cfg.Configuration - Found mapping documents in assembly: MyTest.SecurityDomain.hbm.xml
[2005-08-10 10:45:37,667] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2000Dialect
[2005-08-10 10:45:37,667] INFO NHibernate.Cfg.Binder - Mapping class: MyTest.SecurityDomain -> Security_Domain
[2005-08-10 10:45:37,697] INFO NHibernate.Cfg.Configuration - processing one-to-many association mappings
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.Binder - mapping collection: MyTest.SecurityDomain.ChildDomains -> Security_Domain
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.Configuration - processing one-to-one association property references
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.Configuration - processing foreign key constraints
[2005-08-10 10:45:37,707] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2000Dialect
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.SettingsFactory - use outer join fetching: True
[2005-08-10 10:45:37,707] INFO NHibernate.Connection.ConnectionProviderFactory - Intitializing connection provider: NHibernate.Connection.DriverConnectionProvider
[2005-08-10 10:45:37,707] INFO NHibernate.Connection.ConnectionProvider - Configuring ConnectionProvider
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.SettingsFactory - Query language substitutions:
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.SettingsFactory - cache provider: NHibernate.Cache.HashtableCacheProvider
[2005-08-10 10:45:37,707] INFO NHibernate.Cfg.Configuration - instantiating and configuring caches
[2005-08-10 10:45:37,717] INFO NHibernate.Impl.SessionFactoryImpl - building session factory
[2005-08-10 10:45:37,787] INFO NHibernate.Impl.SessionFactoryObjectFactory - no name configured
[2005-08-10 10:45:38,038] INFO NHibernate.Loader.Loader - SELECT security0_.Security_Domain_Key as Security1_1_, security0_.Last_Updated_By_User_Key as Last_Upd4_1_, security0_.Parent_Domain_Key as Parent_D6_1_, security0_.Last_Updated_Dte as Last_Upd5_1_, security0_.Domain_Name as Domain_N2_1_, security0_.Legacy_Region_Num as Legacy_R3_1_, security1_.Security_Domain_Key as Security1_0_, security1_.Last_Updated_By_User_Key as Last_Upd4_0_, security1_.Parent_Domain_Key as Parent_D6_0_, security1_.Last_Updated_Dte as Last_Upd5_0_, security1_.Domain_Name as Domain_N2_0_, security1_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain security0_ left outer join Security_Domain security1_ on security0_.Parent_Domain_Key=security1_.Security_Domain_Key WHERE security0_.Security_Domain_Key = @p0
[2005-08-10 10:45:38,038] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT security0_.Security_Domain_Key as Security1_1_, security0_.Last_Updated_By_User_Key as Last_Upd4_1_, security0_.Parent_Domain_Key as Parent_D6_1_, security0_.Last_Updated_Dte as Last_Upd5_1_, security0_.Domain_Name as Domain_N2_1_, security0_.Legacy_Region_Num as Legacy_R3_1_, security1_.Security_Domain_Key as Security1_0_, security1_.Last_Updated_By_User_Key as Last_Upd4_0_, security1_.Parent_Domain_Key as Parent_D6_0_, security1_.Last_Updated_Dte as Last_Upd5_0_, security1_.Domain_Name as Domain_N2_0_, security1_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain security0_ left outer join Security_Domain security1_ on security0_.Parent_Domain_Key=security1_.Security_Domain_Key WHERE security0_.Security_Domain_Key = @p0
[2005-08-10 10:45:38,158] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,158] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,248] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,258] INFO NHibernate.Impl.SessionImpl - new collection: instantiating
[2005-08-10 10:45:38,258] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,258] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,258] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,258] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,258] INFO NHibernate.Loader.Loader - SELECT security0_.Security_Domain_Key as Security1_1_, security0_.Last_Updated_By_User_Key as Last_Upd4_1_, security0_.Parent_Domain_Key as Parent_D6_1_, security0_.Last_Updated_Dte as Last_Upd5_1_, security0_.Domain_Name as Domain_N2_1_, security0_.Legacy_Region_Num as Legacy_R3_1_, security1_.Security_Domain_Key as Security1_0_, security1_.Last_Updated_By_User_Key as Last_Upd4_0_, security1_.Parent_Domain_Key as Parent_D6_0_, security1_.Last_Updated_Dte as Last_Upd5_0_, security1_.Domain_Name as Domain_N2_0_, security1_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain security0_ left outer join Security_Domain security1_ on security0_.Parent_Domain_Key=security1_.Security_Domain_Key WHERE security0_.Security_Domain_Key = @p0
[2005-08-10 10:45:38,258] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT security0_.Security_Domain_Key as Security1_1_, security0_.Last_Updated_By_User_Key as Last_Upd4_1_, security0_.Parent_Domain_Key as Parent_D6_1_, security0_.Last_Updated_Dte as Last_Upd5_1_, security0_.Domain_Name as Domain_N2_1_, security0_.Legacy_Region_Num as Legacy_R3_1_, security1_.Security_Domain_Key as Security1_0_, security1_.Last_Updated_By_User_Key as Last_Upd4_0_, security1_.Parent_Domain_Key as Parent_D6_0_, security1_.Last_Updated_Dte as Last_Upd5_0_, security1_.Domain_Name as Domain_N2_0_, security1_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain security0_ left outer join Security_Domain security1_ on security0_.Parent_Domain_Key=security1_.Security_Domain_Key WHERE security0_.Security_Domain_Key = @p0
[2005-08-10 10:45:38,298] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,298] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,338] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,338] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,338] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,378] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,378] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,378] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,418] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,418] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,418] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,458] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,458] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,458] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,458] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,458] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,458] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,498] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,498] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,498] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,539] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,539] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,539] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,579] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,579] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,579] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,619] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,619] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,619] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,619] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,619] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,659] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,659] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,659] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,659] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,659] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:38,659] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,659] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,699] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,699] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,699] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,739] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,749] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,749] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,789] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,789] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,789] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,929] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:38,929] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:38,929] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.SessionImpl - reading row
[2005-08-10 10:45:39,079] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,079] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,180] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,180] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,180] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,270] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,270] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,270] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,370] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,370] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,370] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,470] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,470] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,470] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,570] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,570] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,570] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,670] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,670] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,670] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,730] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,730] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,730] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,770] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,770] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,770] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,800] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,800] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,800] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,841] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,841] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,841] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,881] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
[2005-08-10 10:45:39,881] INFO NHibernate.Loader.Loader - SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,881] INFO NHibernate.Impl.BatcherImpl - Preparing SELECT childdom0_.Parent_Domain_Key as Parent_D6___, childdom0_.Security_Domain_Key as Security1___, childdom0_.Security_Domain_Key as Security1_0_, childdom0_.Last_Updated_By_User_Key as Last_Upd4_0_, childdom0_.Parent_Domain_Key as Parent_D6_0_, childdom0_.Last_Updated_Dte as Last_Upd5_0_, childdom0_.Domain_Name as Domain_N2_0_, childdom0_.Legacy_Region_Num as Legacy_R3_0_ FROM Security_Domain childdom0_ WHERE childdom0_.Parent_Domain_Key = @p0 ORDER BY childdom0_.Legacy_Region_Num
[2005-08-10 10:45:39,931] INFO NHibernate.Impl.SessionImpl - uninitialized collection: initializing
Top
 Profile  
 
sergey
 Post subject:
PostPosted: Wed Aug 10, 2005 3:25 pm 
Contributor
Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic
Looks like a bug, created NH-350 for it in JIRA
Top
 Profile  
 
harrychou
 Post subject:
PostPosted: Wed Aug 10, 2005 4:23 pm 
Newbie

Joined: Tue Aug 09, 2005 9:55 pm
Posts: 4
sergey wrote:
Looks like a bug, created NH-350 for it in JIRA


Can you sugget any workaround? I don't think I am the only one who has the need to do self-referencing class/table.
Top
 Profile  
 
Guest
 Post subject:
PostPosted: Thu Aug 11, 2005 11:19 am 
harrychou wrote:
sergey wrote:
Looks like a bug, created NH-350 for it in JIRA


Can you sugget any workaround? I don't think I am the only one who has the need to do self-referencing class/table.


I found out that once I use int (Int32) it worked. Once I change it to long (Int64) it doesn't load the ChildDomains.
Top
  
 
harrychou
 Post subject:
PostPosted: Thu Aug 11, 2005 11:31 am 
Newbie

Joined: Tue Aug 09, 2005 9:55 pm
Posts: 4
Is it because I cannot use bigint or Int64? :?
Top
 Profile  
 
sergey
 Post subject:
PostPosted: Mon Aug 15, 2005 5:34 am 
Contributor
Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic
It probably happened because you used session.Load (typeof (SecurityDomain), 1). That 1 in there is an int, and your id is a long, and so the loading fails. But NHibernate should check whether id is of the expected type, so I'm going to fix this.
Top
 Profile  
 
desfen
 Post subject:
PostPosted: Mon Aug 15, 2005 3:25 pm 
Beginner
Beginner

Joined: Wed Aug 10, 2005 6:21 pm
Posts: 24
Location: Antwerp, Belgium
:shock: Strange, I got bitten by this exact same mistake myself last Friday. The strange thing is that the loading didn't fail (Int32 with a value of 1 was apparently comparable to Int64 with a value of 1 in the SQL select query) but flushing the session produced an exception in the function that checks whether the user "botched" the ID before saving. The exception complained about the Id being changed from 1(Int64) to 1(Int32).
:?

Anyway, I'm glad to hear someone's planning on fixing this by having NHibernate complain when a user makes this mistake. Although I can imagine that this isn't much of an issue in "real" code, which doesn't contain a lot of hard-coded ID values, if any.

Sven
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  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

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