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

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
 Post subject: cascade="all-delete-orphan"
PostPosted: Mon Jan 23, 2006 8:37 am 
Newbie

Joined: Mon Jan 23, 2006 6:21 am
Posts: 5
I am trying to make an aplication that persists the folowing objects:
Department; Professor; UniversityClass; Student. The relations between are given by the folowing image:

Image

The problem apears when I want to remove a UniversityClass from one Department. In this model the UniversityClass can not exist if it is not in a department. When I remove a UniversityClass from the Department colection I want it to be deleted from DB as well. To achive this I am using: cascade="all-delete-orphan" but it is not working. I am receiving the folowing exception: "You may not dereference an collection with cascade="all-delete-orphan""

NHibernate version: 1.0.

Mapping documents:
Department.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="nhRegistration.BusinessObjects.Department, BusinessObjects"
table="department">

<id name="Id" column="deptid" unsaved-value="0">
<generator class="identity" />
</id>

<property name="Name" column="Name"/>

<set name="ClassesUntyped" inverse="true" cascade="all-delete-orphan">
<key column="deptid"/>
<one-to-many class="nhRegistration.BusinessObjects.UniversityClass,BusinessObjects"/>
</set>

<set name="ProfessorsUntyped" table="departmentprofessor">
<key column="deptid"/>
<many-to-many class="nhRegistration.BusinessObjects.IPerson, BusinessObjects"
column="personid"/>
</set>
</class>
</hibernate-mapping>

UniversityClass.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">

<class name="nhRegistration.BusinessObjects.UniversityClass, BusinessObjects"
table="universityclass">
<id name="Id" column="classId" unsaved-value="0">
<generator class="identity" />
</id>

<property name="Name" column="classname" />
<property name="StartDate" column="StartDate"/>

<many-to-one name="Department" not-null="true"
class="nhRegistration.BusinessObjects.Department,BusinessObjects"
column="deptid"/>

<many-to-one name="Professor" not-null="true"
class="nhRegistration.BusinessObjects.IPerson,BusinessObjects"
column="profid"/>

<set name="StudentsUntyped" table="StudentClass">
<key column="classid"/>
<many-to-many class="nhRegistration.BusinessObjects.IPerson, BusinessObjects"
column="personid"/>
</set>


</class>
</hibernate-mapping>


IPerson.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">

<class name="nhRegistration.BusinessObjects.IPerson, BusinessObjects" table="people">
<id name="Id" column="personid" unsaved-value="0">
<generator class="identity" />
</id>

<discriminator column="persontype" />

<property name="Name" column="Name"/>



<!--PROFESSOR-->
<subclass name="nhRegistration.BusinessObjects.Professor, BusinessObjects"
discriminator-value="professor">

<property name="Code" column="identifier" />

<set name="DepartmentsUntyped" table="departmentprofessor" lazy="false" inverse="true">
<key column="personid"/>
<many-to-many class="nhRegistration.BusinessObjects.Department,BusinessObjects"
column="deptid"/>
</set>

<set name="ClassesUntyped" lazy="false" inverse="true">
<key column="profid"/>
<one-to-many class="nhRegistration.BusinessObjects.UniversityClass,BusinessObjects"/>
</set>

</subclass>


<!--STUDENT-->
<subclass name="nhRegistration.BusinessObjects.Student, BusinessObjects"
discriminator-value="student">
<property name="Ssn" column="identifier"/>

<set name="ClassesUntyped" table="StudentClass" lazy="false" inverse="true">
<key column="personid"/>
<many-to-many class="nhRegistration.BusinessObjects.UniversityClass,BusinessObjects"
column="classid"/>
</set>
</subclass>



</class>
</hibernate-mapping>


Code between sessionFactory.OpenSession() and session.Close():
ITransaction tx = null;
ISession session = null;
try
{
session = NHdbManager.Factory.OpenSession();
tx = session.BeginTransaction();

Department dep = session.Load(typeof(Department),7) as Department;
UniversityClass uc = dep.Classes[0];

dep.Classes.Remove(uc);
uc.Department = null;

session.Delete(uc);
tx.Commit();
}
catch (Exception ex)
{
if (tx != null)
tx.Rollback();
throw new Exception("Object not saved. Error message: " + ex.Message);
}
finally
{
session.Close();
}

Full stack trace of any exception that occurs:
StackTrace " at NHibernate.Impl.SessionImpl.UpdateUnreachableCollection(PersistentCollection coll)\r\n at NHibernate.Impl.SessionImpl.FlushCollections()\r\n at NHibernate.Impl.SessionImpl.FlushEverything()\r\n at NHibernate.Impl.SessionImpl.Flush()\r\n at NHibernate.Transaction.AdoTransaction.Commit()\r\n at Test.Program.Test1() in D:\\Work\\2005WForm\\nhRegistration\\Test\\Program.cs:line 32" string

Name and version of the database you are using:
SQL Server 2000

Debug level Hibernate log excerpt:
2006-01-23 13:56:24,205 [2844] DEBUG NHibernate.Cfg.Environment [(null)] <(null)> - no hibernate settings in app.config/web.config were found
2006-01-23 13:56:24,237 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - searching for mapped documents in assembly: DataLayer
2006-01-23 13:56:24,237 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - Found mapping documents in assembly: DataLayer.Mapings.UniversityClass.hbm.xml
2006-01-23 13:56:24,299 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,330 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping class: nhRegistration.BusinessObjects.UniversityClass -> universityclass
2006-01-23 13:56:24,377 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Id -> classId, type: Int32
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Name -> classname, type: String
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: StartDate -> StartDate, type: DateTime
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Department -> deptid, type: Department
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Professor -> profid, type: IPerson
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped -> StudentClass
2006-01-23 13:56:24,408 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: StudentsUntyped, type: ISet
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - Found mapping documents in assembly: DataLayer.Mapings.IPerson.hbm.xml
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping class: nhRegistration.BusinessObjects.IPerson -> people
2006-01-23 13:56:24,408 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Id -> personid, type: Int32
2006-01-23 13:56:24,408 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Name -> Name, type: String
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping subclass: nhRegistration.BusinessObjects.Professor -> people
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Code -> identifier, type: String
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.Professor.DepartmentsUntyped -> departmentprofessor
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: DepartmentsUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ClassesUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping subclass: nhRegistration.BusinessObjects.Student -> people
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Ssn -> identifier, type: String
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.Student.ClassesUntyped -> StudentClass
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ClassesUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - Found mapping documents in assembly: DataLayer.Mapings.Department.hbm.xml
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping class: nhRegistration.BusinessObjects.Department -> department
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Id -> deptid, type: Int32
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Name -> Name, type: String
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ClassesUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.Department.ProfessorsUntyped -> departmentprofessor
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ProfessorsUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing one-to-many association mappings
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: classid, element: personid, type: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Professor.DepartmentsUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: personid, element: deptid, type: Department
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Professor.ClassesUntyped
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - mapping collection: nhRegistration.BusinessObjects.Professor.ClassesUntyped -> universityclass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: profid, one-to-many: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Student.ClassesUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: personid, element: classid, type: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Department.ClassesUntyped
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - mapping collection: nhRegistration.BusinessObjects.Department.ClassesUntyped -> universityclass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: deptid, one-to-many: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Department.ProfessorsUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: deptid, element: personid, type: IPerson
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing one-to-one association property references
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing foreign key constraints
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: Department
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: Department
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - use outer join fetching: True
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Connection.ConnectionProviderFactory [(null)] <(null)> - Intitializing connection provider: NHibernate.Connection.DriverConnectionProvider
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Connection.ConnectionProvider [(null)] <(null)> - Configuring ConnectionProvider
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Optimize cache for minimal puts: False
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Query language substitutions: {}
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - cache provider: NHibernate.Cache.HashtableCacheProvider
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - instantiating and configuring caches
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - building session factory
2006-01-23 13:56:24,471 [2844] DEBUG NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - instantiating session factory with properties: {hibernate.connection.driver_class=NHibernate.Driver.SqlClientDriver, hibernate.dialect=NHibernate.Dialect.MsSql2000Dialect, hibernate.connection.provider=NHibernate.Connection.DriverConnectionProvider, hibernate.connection.connection_string=Server=SRVNET;Database=nhRegistrationFlorin;User ID=sa;Password=as;Trusted_Connection=False}
2006-01-23 13:56:24,658 [2844] DEBUG NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - initializing class SessionFactoryObjectFactory
2006-01-23 13:56:24,658 [2844] DEBUG NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - registered: 1d3fd207fdb34835a3ca70b0beb7aa6e(unnamed)
2006-01-23 13:56:24,658 [2844] INFO NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - no name configured
2006-01-23 13:56:24,658 [2844] DEBUG NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - Instantiated session factory
2006-01-23 13:56:24,674 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - opened session
2006-01-23 13:56:24,674 [2844] DEBUG NHibernate.Transaction.AdoTransaction [(null)] <(null)> - begin
2006-01-23 13:56:24,674 [2844] DEBUG NHibernate.Connection.DriverConnectionProvider [(null)] <(null)> - Obtaining IDbConnection from Driver
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - object not resolved in any cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Persister.EntityPersister [(null)] <(null)> - Materializing entity: nhRegistration.BusinessObjects.Department#7
2006-01-23 13:56:24,737 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT department0_.deptid as deptid0_, department0_.Name as Name0_ FROM department department0_ WHERE department0_.deptid=:deptid
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '7' to parameter: 0
2006-01-23 13:56:24,752 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT department0_.deptid as deptid0_, department0_.Name as Name0_ FROM department department0_ WHERE department0_.deptid=@p0
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT department0_.deptid as deptid0_, department0_.Name as Name0_ FROM department department0_ WHERE department0_.deptid=@p0
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 7
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.Department#7
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Department 13' as column: Name0_
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (1 rows)
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 1
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT classesunt0_.deptid as deptid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM universityclass classesunt0_ left outer join people iperson1_ on classesunt0_.profid=iperson1_.personid WHERE classesunt0_.deptid=:deptid
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '7' to parameter: 0
2006-01-23 13:56:24,799 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT classesunt0_.deptid as deptid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM universityclass classesunt0_ left outer join people iperson1_ on classesunt0_.profid=iperson1_.personid WHERE classesunt0_.deptid=@p0
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT classesunt0_.deptid as deptid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM universityclass classesunt0_ left outer join people iperson1_ on classesunt0_.profid=iperson1_.personid WHERE classesunt0_.deptid=@p0
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 4, 11
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'professor' as column: persontype0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 4
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.Professor#4
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'pCharles' as column: identifier0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Charles' as column: Name0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 11
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.UniversityClass#11
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Class 1' as column: classname1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.DateTimeType [(null)] <(null)> - returning '1/1/2006' as column: StartDate1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#11]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#11]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid0_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 4, 12
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 12
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.UniversityClass#12
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Class 2' as column: classname1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.DateTimeType [(null)] <(null)> - returning '1/1/2006' as column: StartDate1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#12]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#12]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (2 rows)
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 3
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.Professor#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=:personid
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '4' to parameter: 0
2006-01-23 13:56:24,815 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (1 rows)
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=:profid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '4' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId1_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7, 11
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId1_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7, 12
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (2 rows)
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - done materializing entity [nhRegistration.BusinessObjects.Professor#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=:classid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '11' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (0 rows)
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - done materializing entity [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=:classid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '12' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (0 rows)
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - done materializing entity [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT professors0_.deptid as deptid__, professors0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM departmentprofessor professors0_ inner join people iperson1_ on professors0_.personid=iperson1_.personid WHERE professors0_.deptid=:deptid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '7' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT professors0_.deptid as deptid__, professors0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM departmentprofessor professors0_ inner join people iperson1_ on professors0_.personid=iperson1_.personid WHERE professors0_.deptid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT professors0_.deptid as deptid__, professors0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM departmentprofessor professors0_ inner join people iperson1_ on professors0_.personid=iperson1_.personid WHERE professors0_.deptid=@p0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '1' as column: personid0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'professor' as column: persontype0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.Professor#1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'pRichard' as column: identifier0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Richard' as column: Name0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '1' as column: personid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 4
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#4]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#4]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#4]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (2 rows)
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.Professor#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.ClassesUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=:personid
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '1' to parameter: 0
2006-01-23 13:56:24,846 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '1' as column: personid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (1 rows)
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.ClassesUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=:profid
2006-01-23 13:56:24,846 [2844] DEBUG NHibe


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 23, 2006 10:37 am 
Newbie

Joined: Fri Jan 20, 2006 12:47 pm
Posts: 16
Location: Ottawa, On
I think your problem is because you have the ClassesUntyped set mapped as inverse="true". I'm definitely not an expert on exactly how the inverse flag works, but If you want cascades to work correctly for a collection, you need to set inverse="false".

I think where you would want the inverse flag is if you had a bi-directional collection of director's in your UniversityClasses object, because I think the inverse flag indicates that you are not updating the collection from this end of the relationship.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 23, 2006 4:11 pm 
Expert
Expert

Joined: Fri May 13, 2005 11:13 am
Posts: 292
Location: Rochester, NY
stuow,

No, in fact using inverse="true" + cascade="all" or "all-delete-orphan" is the recommended implmentation of a parent-child relationship, which is what is what komiscaros is attempting to do. The inverse flag indicates that the relationship is managed via the UniversityClass.Department many-to-one. The cascade implies that actions taken on the parent will, well, cascade to the children.

Now, I'm not sure what is causing the error, since I can't see where a (or which) collection has been dereferenced. However, it does seem that this code:

Code:
uc.Department = null;

session.Delete(uc);


is redundant, since this should be taken care of by the cascade in question. Does removing these lines have any effect?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 24, 2006 5:27 am 
Newbie

Joined: Mon Jan 23, 2006 6:21 am
Posts: 5
Thank you for your posts,

marcal wrote:
is redundant, since this should be taken care of by the cascade in question. Does removing these lines have any effect?


I also expected that cascade will take care of removing the child record from DB for me but it does not.

If I coment out both:
Code:
//uc.Department = null;
//session.Delete(uc);

then I receive the same exception.

If I coment out only the last line
Code:
uc.Department = null;
//session.Delete(uc);

then I receive the folowing exception: "not-null property references a null or transient value: nhRegistration.BusinessObjects.UniversityClass.Departmen"
I think this comes because I have a not-null constraint in DB for UniversityClass.deptid column.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 27, 2006 5:45 am 
Newbie

Joined: Mon Jan 23, 2006 6:21 am
Posts: 5
I have read more carefull the log file. It appears that the problem comes from the fact that I use BindingList<> colection wrapped over NHibernate colections so the session's cached colections are unreferenced which it appears that can not be done for cascade="all-delete-orphan" colections.

I will try to use the NHibernate colections but in this case I will loose the easy binding to GUI.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 27, 2006 11:46 am 
Contributor
Contributor

Joined: Thu May 12, 2005 8:45 am
Posts: 226
komisacros wrote:
I will try to use the NHibernate colections but in this case I will loose the easy binding to GUI.


You don't need to lose anything. Keep your wrapper collection for binding, just don't try to update back to NHibernate using the wrapped collection. I recommend exposing the underlying NHibernate collection from your wrapped collection and update using that collection.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 30, 2006 7:41 am 
Newbie

Joined: Mon Jan 23, 2006 6:21 am
Posts: 5
k-dub wrote:
You don't need to lose anything. Keep your wrapper collection for binding, just don't try to update back to NHibernate using the wrapped collection. I recommend exposing the underlying NHibernate collection from your wrapped collection and update using that collection.


The problem is that in my current implementation I do not keep any reference to NHibernate's colection.
For example:
Code:
       /// <summary>
        /// used only by NHibernate
        /// </summary>
        private ISet ClassesUntyped
        {
            get { return new HybridSet(classes); }
            set
            {
                classes.RaiseListChangedEvents = false;
                classes.Clear();
                foreach (object e in value)
                {
                    UniversityClass uc = e as UniversityClass;
                    if (uc != null)
                    {
                        uc.State = EntityState.Unchanged;
                        classes.Add(uc);
                    }
                }
                classes.RaiseListChangedEvents = true;
            }
        }

I have chosen this approach because NHibernate "gives" me an untyped collection. I realize that it takes more time at loading, but it helps me in implementing the business rules and GUI.
May be I did not understand well your suggestion, but having this I do not see haw to apply it.


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

All times are UTC - 5 hours [ DST ]


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

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