-->
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 » Hibernate 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
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
koes
 Post subject: rollback does not roll back collection (one-to-many)
PostPosted: Tue Nov 02, 2004 3:57 pm 
Beginner
Beginner

Joined: Fri Oct 15, 2004 10:29 am
Posts: 21
I want to rollback a "Session" object (not to be confused with a hibernate session) after I've added some "Registration" objects to the roster collection. Calling session.connection().rollback() does NOT rollback my "Session" object to the previous state (before adding "Registration" objects). Commit works fine when that is what I want to do.

Is there something wrong/missing with the mapping configuration?


Hibernate version:
2.1.3

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping package="com.skillsoft.ilt.beans">
<class name="Registration" table="iltRegistration">
<id name="ID" column="ID" unsaved-value="0">
<generator class="native"/>
</id>
<property name="passed" column="passed"/>
<property name="attended" column="attended"/>
<property name="registered" column="date"/>
<property name="mastery" column="mastery"/>
<property name="status" column="status"/>
<property name="notes" column="notes"/>
<many-to-one name="session" column="session" class="Session"/>
<many-to-one name="student" column="uzer" class="User"/>
</class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping package="com.skillsoft.ilt.beans">
<class name="Session" table="iltSession">
<id name="ID" column="ID" unsaved-value="0">
<generator class="native"/>
</id>
<property name="number" column="number"/>
<property name="notes" column="notes"/>
<property name="timeZoneID" column="tzid"/>
<property name="statusCode" column="status"/>
<property name="capacity" column="capacity"/>
<many-to-one name="instructor" class="User" column="instructor"/>
<many-to-one name="course" class="Course" column="course"/>
<many-to-one name="facility" class="Facility" column="facility"/>
<many-to-one name="classroom" class="Classroom" column="classroom"/>
<many-to-one name="owner" column="owner" class="Contact"/>

<!-- bag => Collection, unordered, allows duplicates -->
<bag
name="roster"
table="iltRegistration"
inverse="true"
cascade="all-delete-orphan"
lazy="false"
outer-join="false"
batch-size="100">
<key column="session"/>
<one-to-many class="Registration"/>
</bag>

<!-- bag => Collection, unordered, allows duplicates -->
<bag
name="schedule"
table="iltScheduleinfo"
inverse="true"
order-by="startTime"
cascade="all-delete-orphan"
lazy="false"
outer-join="false"
batch-size="100">
<key column="session"/>
<one-to-many class="Schedule"/>
</bag>
</class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():

snip...
Registration bean = new Registration();
bean.setSession(session);
// Set the Specific User for the registration
bean.setStudent(user);
// Add the new Registration
session.getRoster().add(bean);
snip...
session.connection().rollback();
snip...

Full stack trace of any exception that occurs:

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

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Sorry for the duplicate lines.

2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - opened session
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - opened session
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - flushing session
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - flushing session
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Flushing entities and processing referenced collections
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Flushing entities and processing referenced collections
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Processing unreferenced collections
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Processing unreferenced collections
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Scheduling collection removes/(re)creates/updates
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Scheduling collection removes/(re)creates/updates
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Dont need to execute flush
2004-11-02 14:22:12,320 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - Dont need to execute flush
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select this.ID as ID0_, this.login as login0_, this.email as email0_, this.firstName as firstName0_, this.lastName as lastName0_, this.role as role0_, this.groupName as groupName0_, this.groupCode as groupCode0_, this.spCustomProp1 as spCustom9_0_, this.spCustomProp2 as spCusto10_0_, this.spCustomProp3 as spCusto11_0_, this.spCustomProp1Label as spCusto12_0_, this.spCustomProp2Label as spCusto13_0_, this.spCustomProp3Label as spCusto14_0_ from iltSkillPortUsers this where this.login=? order by this.login asc
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select this.ID as ID0_, this.login as login0_, this.email as email0_, this.firstName as firstName0_, this.lastName as lastName0_, this.role as role0_, this.groupName as groupName0_, this.groupCode as groupCode0_, this.spCustomProp1 as spCustom9_0_, this.spCustomProp2 as spCusto10_0_, this.spCustomProp3 as spCusto11_0_, this.spCustomProp1Label as spCusto12_0_, this.spCustomProp2Label as spCusto13_0_, this.spCustomProp3Label as spCusto14_0_ from iltSkillPortUsers this where this.login=? order by this.login asc
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (1 rows)
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (1 rows)
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 1
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing non-lazy collections
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing non-lazy collections
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select applicatio0_.appID as appID__, applicatio0_.roleID as roleID__, applicatio1_.ID as ID0_, applicatio1_.name as name0_, applicatio1_.idx as idx0_, applicatio1_.description as descript4_0_, applicatio1_.path as path0_, applicatio1_.menuID as menuID0_, menu2_.ID as ID1_, menu2_.name as name1_, menu2_.idx as idx1_, menu2_.description as descript4_1_ from iltRoleApp applicatio0_ inner join iltApp applicatio1_ on applicatio0_.appID=applicatio1_.ID left outer join iltMenu menu2_ on applicatio1_.menuID=menu2_.ID where applicatio0_.roleID=? order by applicatio0_.appID
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select applicatio0_.appID as appID__, applicatio0_.roleID as roleID__, applicatio1_.ID as ID0_, applicatio1_.name as name0_, applicatio1_.idx as idx0_, applicatio1_.description as descript4_0_, applicatio1_.path as path0_, applicatio1_.menuID as menuID0_, menu2_.ID as ID1_, menu2_.name as name1_, menu2_.idx as idx1_, menu2_.description as descript4_1_ from iltRoleApp applicatio0_ inner join iltApp applicatio1_ on applicatio0_.appID=applicatio1_.ID left outer join iltMenu menu2_ on applicatio1_.menuID=menu2_.ID where applicatio0_.roleID=? order by applicatio0_.appID
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result set contains (possibly empty) collection: [com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result set contains (possibly empty) collection: [com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - uninitialized collection: initializing
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - uninitialized collection: initializing
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (0 rows)
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (0 rows)
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 0
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 0
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections were found in result set
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections were found in result set
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection fully initialized: [com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection fully initialized: [com.skillsoft.ilt.beans.User.applications#1]
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections initialized
2004-11-02 14:22:12,330 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections initialized
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection initialized
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection initialized
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - object not resolved in any cache [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - object not resolved in any cache [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG EntityPersister 10.20.3.42 => /ilt {djk:admin} - Materializing entity: [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG EntityPersister 10.20.3.42 => /ilt {djk:admin} - Materializing entity: [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select session0_.ID as ID7_, session0_.number as number7_, session0_.notes as notes7_, session0_.tzid as tzid7_, session0_.status as status7_, session0_.capacity as capacity7_, session0_.instructor as instructor7_, session0_.course as course7_, session0_.facility as facility7_, session0_.classroom as classroom7_, session0_.owner as owner7_, user1_.ID as ID0_, user1_.login as login0_, user1_.email as email0_, user1_.firstName as firstName0_, user1_.lastName as lastName0_, user1_.role as role0_, user1_.groupName as groupName0_, user1_.groupCode as groupCode0_, user1_.spCustomProp1 as spCustom9_0_, user1_.spCustomProp2 as spCusto10_0_, user1_.spCustomProp3 as spCusto11_0_, user1_.spCustomProp1Label as spCusto12_0_, user1_.spCustomProp2Label as spCusto13_0_, user1_.spCustomProp3Label as spCusto14_0_, course2_.ID as ID1_, course2_.lastModified as lastModi2_1_, course2_.name as name1_, course2_.number as number1_, course2_.description as descript5_1_, course2_.duration as duration1_, course2_.cost as cost1_, course2_.currency as currency1_, course2_.mastery as mastery1_, course2_.published as published1_, course2_.approvalRequired as approva11_1_, course2_.active as active1_, course2_.language as language1_, course2_.facility as facility1_, course2_.classroom as classroom1_, course2_.owner as owner1_, facility3_.ID as ID2_, facility3_.name as name2_, facility3_.number as number2_, facility3_.description as descript4_2_, facility3_.virtual as virtual2_, facility3_.owner as owner2_, contact4_.ID as ID3_, contact4_.address1 as address13_, contact4_.address2 as address23_, contact4_.city as city3_, contact4_.code as code3_, contact4_.companyName as companyN6_3_, contact4_.contactName as contactN7_3_, contact4_.country as country3_, contact4_.email1 as email13_, contact4_.email2 as email23_, contact4_.fax as fax3_, contact4_.name as name3_, contact4_.notes as notes3_, contact4_.phone1 as phone13_, contact4_.phone2 as phone23_, contact4_.state as state3_, contact4_.status as status3_, contact4_.url1 as url13_, contact4_.url2 as url23_, contact4_.zipCode as zipCode3_, contact4_.owner as owner3_, contact5_.ID as ID4_, contact5_.address1 as address14_, contact5_.address2 as address24_, contact5_.city as city4_, contact5_.code as code4_, contact5_.companyName as companyN6_4_, contact5_.contactName as contactN7_4_, contact5_.country as country4_, contact5_.email1 as email14_, contact5_.email2 as email24_, contact5_.fax as fax4_, contact5_.name as name4_, contact5_.notes as notes4_, contact5_.phone1 as phone14_, contact5_.phone2 as phone24_, contact5_.state as state4_, contact5_.status as status4_, contact5_.url1 as url14_, contact5_.url2 as url24_, contact5_.zipCode as zipCode4_, contact5_.owner as owner4_, classroom6_.ID as ID5_, classroom6_.name as name5_, classroom6_.number as number5_, classroom6_.capacity as capacity5_, classroom6_.virtual as virtual5_, classroom6_.description as descript6_5_, classroom6_.active as active5_, classroom6_.facility as facility5_, classroom6_.owner as owner5_, classroom7_.ID as ID6_, classroom7_.name as name6_, classroom7_.number as number6_, classroom7_.capacity as capacity6_, classroom7_.virtual as virtual6_, classroom7_.description as descript6_6_, classroom7_.active as active6_, classroom7_.facility as facility6_, classroom7_.owner as owner6_ from iltSession session0_ left outer join iltSkillPortUsers user1_ on session0_.instructor=user1_.ID left outer join iltCourse course2_ on session0_.course=course2_.ID left outer join iltFacility facility3_ on course2_.facility=facility3_.ID left outer join iltContact contact4_ on facility3_.owner=contact4_.ID left outer join iltContact contact5_ on contact4_.owner=contact5_.ID left outer join iltClassroom classroom6_ on course2_.classroom=classroom6_.ID left outer join iltClassroom classroom7_ on session0_.classroom=classroom7_.ID where session0_.ID=?
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select session0_.ID as ID7_, session0_.number as number7_, session0_.notes as notes7_, session0_.tzid as tzid7_, session0_.status as status7_, session0_.capacity as capacity7_, session0_.instructor as instructor7_, session0_.course as course7_, session0_.facility as facility7_, session0_.classroom as classroom7_, session0_.owner as owner7_, user1_.ID as ID0_, user1_.login as login0_, user1_.email as email0_, user1_.firstName as firstName0_, user1_.lastName as lastName0_, user1_.role as role0_, user1_.groupName as groupName0_, user1_.groupCode as groupCode0_, user1_.spCustomProp1 as spCustom9_0_, user1_.spCustomProp2 as spCusto10_0_, user1_.spCustomProp3 as spCusto11_0_, user1_.spCustomProp1Label as spCusto12_0_, user1_.spCustomProp2Label as spCusto13_0_, user1_.spCustomProp3Label as spCusto14_0_, course2_.ID as ID1_, course2_.lastModified as lastModi2_1_, course2_.name as name1_, course2_.number as number1_, course2_.description as descript5_1_, course2_.duration as duration1_, course2_.cost as cost1_, course2_.currency as currency1_, course2_.mastery as mastery1_, course2_.published as published1_, course2_.approvalRequired as approva11_1_, course2_.active as active1_, course2_.language as language1_, course2_.facility as facility1_, course2_.classroom as classroom1_, course2_.owner as owner1_, facility3_.ID as ID2_, facility3_.name as name2_, facility3_.number as number2_, facility3_.description as descript4_2_, facility3_.virtual as virtual2_, facility3_.owner as owner2_, contact4_.ID as ID3_, contact4_.address1 as address13_, contact4_.address2 as address23_, contact4_.city as city3_, contact4_.code as code3_, contact4_.companyName as companyN6_3_, contact4_.contactName as contactN7_3_, contact4_.country as country3_, contact4_.email1 as email13_, contact4_.email2 as email23_, contact4_.fax as fax3_, contact4_.name as name3_, contact4_.notes as notes3_, contact4_.phone1 as phone13_, contact4_.phone2 as phone23_, contact4_.state as state3_, contact4_.status as status3_, contact4_.url1 as url13_, contact4_.url2 as url23_, contact4_.zipCode as zipCode3_, contact4_.owner as owner3_, contact5_.ID as ID4_, contact5_.address1 as address14_, contact5_.address2 as address24_, contact5_.city as city4_, contact5_.code as code4_, contact5_.companyName as companyN6_4_, contact5_.contactName as contactN7_4_, contact5_.country as country4_, contact5_.email1 as email14_, contact5_.email2 as email24_, contact5_.fax as fax4_, contact5_.name as name4_, contact5_.notes as notes4_, contact5_.phone1 as phone14_, contact5_.phone2 as phone24_, contact5_.state as state4_, contact5_.status as status4_, contact5_.url1 as url14_, contact5_.url2 as url24_, contact5_.zipCode as zipCode4_, contact5_.owner as owner4_, classroom6_.ID as ID5_, classroom6_.name as name5_, classroom6_.number as number5_, classroom6_.capacity as capacity5_, classroom6_.virtual as virtual5_, classroom6_.description as descript6_5_, classroom6_.active as active5_, classroom6_.facility as facility5_, classroom6_.owner as owner5_, classroom7_.ID as ID6_, classroom7_.name as name6_, classroom7_.number as number6_, classroom7_.capacity as capacity6_, classroom7_.virtual as virtual6_, classroom7_.description as descript6_6_, classroom7_.active as active6_, classroom7_.facility as facility6_, classroom7_.owner as owner6_ from iltSession session0_ left outer join iltSkillPortUsers user1_ on session0_.instructor=user1_.ID left outer join iltCourse course2_ on session0_.course=course2_.ID left outer join iltFacility facility3_ on course2_.facility=facility3_.ID left outer join iltContact contact4_ on facility3_.owner=contact4_.ID left outer join iltContact contact5_ on contact4_.owner=contact5_.ID left outer join iltClassroom classroom6_ on course2_.classroom=classroom6_.ID left outer join iltClassroom classroom7_ on session0_.classroom=classroom7_.ID where session0_.ID=?
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,340 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 14, 2, null, null, null, null, null, 6
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 14, 2, null, null, null, null, null, 6
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 14
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 14
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#14
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#14
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 2
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 2
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Course#2
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Course#2
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 6
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 6
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Session#6
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Session#6
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (1 rows)
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (1 rows)
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 3
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 3
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Course.sessions#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Course.sessions#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Course.interestList#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Course.interestList#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.User#14]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Course#2]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Session.schedule#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.Session.schedule#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select roster0_.ID as ID__, roster0_.session as session__, roster0_.ID as ID1_, roster0_.passed as passed1_, roster0_.attended as attended1_, roster0_.date as date1_, roster0_.mastery as mastery1_, roster0_.status as status1_, roster0_.notes as notes1_, roster0_.session as session1_, roster0_.uzer as uzer1_, user1_.ID as ID0_, user1_.login as login0_, user1_.email as email0_, user1_.firstName as firstName0_, user1_.lastName as lastName0_, user1_.role as role0_, user1_.groupName as groupName0_, user1_.groupCode as groupCode0_, user1_.spCustomProp1 as spCustom9_0_, user1_.spCustomProp2 as spCusto10_0_, user1_.spCustomProp3 as spCusto11_0_, user1_.spCustomProp1Label as spCusto12_0_, user1_.spCustomProp2Label as spCusto13_0_, user1_.spCustomProp3Label as spCusto14_0_ from iltRegistration roster0_ left outer join iltSkillPortUsers user1_ on roster0_.uzer=user1_.ID where roster0_.session=?
2004-11-02 14:22:12,350 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select roster0_.ID as ID__, roster0_.session as session__, roster0_.ID as ID1_, roster0_.passed as passed1_, roster0_.attended as attended1_, roster0_.date as date1_, roster0_.mastery as mastery1_, roster0_.status as status1_, roster0_.notes as notes1_, roster0_.session as session1_, roster0_.uzer as uzer1_, user1_.ID as ID0_, user1_.login as login0_, user1_.email as email0_, user1_.firstName as firstName0_, user1_.lastName as lastName0_, user1_.role as role0_, user1_.groupName as groupName0_, user1_.groupCode as groupCode0_, user1_.spCustomProp1 as spCustom9_0_, user1_.spCustomProp2 as spCusto10_0_, user1_.spCustomProp3 as spCusto11_0_, user1_.spCustomProp1Label as spCusto12_0_, user1_.spCustomProp2Label as spCusto13_0_, user1_.spCustomProp3Label as spCusto14_0_ from iltRegistration roster0_ left outer join iltSkillPortUsers user1_ on roster0_.uzer=user1_.ID where roster0_.session=?
2004-11-02 14:22:12,360 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,360 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result set contains (possibly empty) collection: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result set contains (possibly empty) collection: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - uninitialized collection: initializing
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - uninitialized collection: initializing
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 31, 21
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 31, 21
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 31
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 31
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#31
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#31
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 21
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 21
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Registration#21
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Registration#21
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - found row of collection: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - found row of collection: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - reading row
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - reading row
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 32, 22
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result row: 32, 22
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 32
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 32
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#32
2004-11-02 14:22:12,370 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.User#32
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 22
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Initializing object from ResultSet: 22
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Registration#22
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - Hydrating entity: com.skillsoft.ilt.beans.Registration#22
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - found row of collection: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - found row of collection: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - reading row
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - reading row
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (2 rows)
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (2 rows)
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 4
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 4
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.User#31]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Registration#21]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - creating collection wrapper:[com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolving associations for [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - loading [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - attempting to resolve [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - resolved object in session cache [com.skillsoft.ilt.beans.User#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Registration#22]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections were found in result set
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections were found in result set
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection fully initialized: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection fully initialized: [com.skillsoft.ilt.beans.Session.roster#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections initialized
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections initialized
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection initialized
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection initialized
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - done materializing entity [com.skillsoft.ilt.beans.Session#6]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing non-lazy collections
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing non-lazy collections
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select applicatio0_.appID as appID__, applicatio0_.roleID as roleID__, applicatio1_.ID as ID0_, applicatio1_.name as name0_, applicatio1_.idx as idx0_, applicatio1_.description as descript4_0_, applicatio1_.path as path0_, applicatio1_.menuID as menuID0_, menu2_.ID as ID1_, menu2_.name as name1_, menu2_.idx as idx1_, menu2_.description as descript4_1_ from iltRoleApp applicatio0_ inner join iltApp applicatio1_ on applicatio0_.appID=applicatio1_.ID left outer join iltMenu menu2_ on applicatio1_.menuID=menu2_.ID where applicatio0_.roleID=? order by applicatio0_.appID
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select applicatio0_.appID as appID__, applicatio0_.roleID as roleID__, applicatio1_.ID as ID0_, applicatio1_.name as name0_, applicatio1_.idx as idx0_, applicatio1_.description as descript4_0_, applicatio1_.path as path0_, applicatio1_.menuID as menuID0_, menu2_.ID as ID1_, menu2_.name as name1_, menu2_.idx as idx1_, menu2_.description as descript4_1_ from iltRoleApp applicatio0_ inner join iltApp applicatio1_ on applicatio0_.appID=applicatio1_.ID left outer join iltMenu menu2_ on applicatio1_.menuID=menu2_.ID where applicatio0_.roleID=? order by applicatio0_.appID
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result set contains (possibly empty) collection: [com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - result set contains (possibly empty) collection: [com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - uninitialized collection: initializing
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - uninitialized collection: initializing
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - processing result set
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (0 rows)
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - done processing result set (0 rows)
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - done closing: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - closing statement
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 0
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG Loader 10.20.3.42 => /ilt {djk:admin} - total objects hydrated: 0
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections were found in result set
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections were found in result set
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection fully initialized: [com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,380 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection fully initialized: [com.skillsoft.ilt.beans.User.applications#32]
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections initialized
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - 1 collections initialized
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection initialized
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection initialized
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.User.applications#31]
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - initializing collection [com.skillsoft.ilt.beans.User.applications#31]
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - checking second-level cache
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SessionImpl 10.20.3.42 => /ilt {djk:admin} - collection not cached
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - about to open: 0 open PreparedStatements, 0 open ResultSets
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select applicatio0_.appID as appID__, applicatio0_.roleID as roleID__, applicatio1_.ID as ID0_, applicatio1_.name as name0_, applicatio1_.idx as idx0_, applicatio1_.description as descript4_0_, applicatio1_.path as path0_, applicatio1_.menuID as menuID0_, menu2_.ID as ID1_, menu2_.name as name1_, menu2_.idx as idx1_, menu2_.description as descript4_1_ from iltRoleApp applicatio0_ inner join iltApp applicatio1_ on applicatio0_.appID=applicatio1_.ID left outer join iltMenu menu2_ on applicatio1_.menuID=menu2_.ID where applicatio0_.roleID=? order by applicatio0_.appID
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG SQL 10.20.3.42 => /ilt {djk:admin} - select applicatio0_.appID as appID__, applicatio0_.roleID as roleID__, applicatio1_.ID as ID0_, applicatio1_.name as name0_, applicatio1_.idx as idx0_, applicatio1_.description as descript4_0_, applicatio1_.path as path0_, applicatio1_.menuID as menuID0_, menu2_.ID as ID1_, menu2_.name as name1_, menu2_.idx as idx1_, menu2_.description as descript4_1_ from iltRoleApp applicatio0_ inner join iltApp applicatio1_ on applicatio0_.appID=applicatio1_.ID left outer join iltMenu menu2_ on applicatio1_.menuID=menu2_.ID where applicatio0_.roleID=? order by applicatio0_.appID
2004-11-02 14:22:12,390 [TP-Processor2] DEBUG BatcherImpl 10.20.3.42 => /ilt {djk:admin} - preparing statement
Top
 Profile  
 
koes
 Post subject: Registration # 32
PostPosted: Tue Nov 02, 2004 4:05 pm 
Beginner
Beginner

Joined: Fri Oct 15, 2004 10:29 am
Posts: 21
Registration # 32 is the one in question.
Top
 Profile  
 
koes
 Post subject: autoCommit defaults to true!!!
PostPosted: Wed Nov 03, 2004 5:47 pm 
Beginner
Beginner

Joined: Fri Oct 15, 2004 10:29 am
Posts: 21
Connection property autoCommit defaults to true. You must set the session.connection().setAutoCommit(false) to avoid unexpected commits.
Top
 Profile  
 
max
 Post subject:
PostPosted: Wed Nov 03, 2004 6:14 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
hibernate does not "rollback" the in-memory object graph - that is your job (the easiest way is to drop the graph or try to do the update again - with the possible necessary changes to be done ;)

_________________
Max
Don't forget to rate

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
  [ 4 posts ] 

Board index » Hibernate & Java Persistence » Hibernate 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.