Hibernate version:
2.1.6
Mapping documents:
ApplicationVO.hbm
Code:
<?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>
<class name="com.llic.usermanager.data.ApplicationVO" schema="USERMGR" table="Application">
<id
column="ApplicationId"
name="id"
type="java.lang.Long"
>
<generator class="native" />
</id>
<property
column="ApplicationName"
length="20"
name="name"
not-null="true"
type="java.lang.String"
/>
<property
column="Description"
length="254"
name="description"
type="java.lang.String"
/>
<!-- the following save all of the data via cascading. In the event the application is deleted, then
all of the corresponding users, groups, and roles are deleted -->
<set name="users" table="USER" inverse="true" lazy="false" cascade="all-delete-orphan">
<key column="ApplicationID"/>
<one-to-many class="com.llic.usermanager.data.UserVO"/>
</set>
<set name="groups" table="GROUP" inverse="true" lazy="false" cascade="all-delete-orphan">
<key column="ApplicationID"/>
<one-to-many class="com.llic.usermanager.data.GroupVO"/>
</set>
<set name="roles" table="ROLE" inverse="true" lazy="false" cascade="all-delete-orphan">
<key column="ApplicationID"/>
<one-to-many class="com.llic.usermanager.data.RoleVO"/>
</set>
</class>
</hibernate-mapping>
GroupVO.hbm
Code:
<?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>
<class name="com.llic.usermanager.data.GroupVO" schema="USERMGR" table="Group">
<id
column="GroupID"
name="id"
type="java.lang.Long"
>
<generator class="native" />
</id>
<property
column="Code"
length="30"
name="name"
not-null="true"
type="java.lang.String"
/>
<property
column="Description"
length="30"
name="description"
type="java.lang.String"
/>
<set
cascade="save-update"
inverse="true"
lazy="false"
name="users"
table="UserGroup"
>
<key column="GroupID" />
<many-to-many class="com.llic.usermanager.data.UserVO" column="UserID" />
</set>
<!-- TODO after association table is complete -->
<set
cascade="save-update"
lazy="false"
name="roles"
table="GroupRole"
>
<key column="GroupID" />
<many-to-many class="com.llic.usermanager.data.RoleVO" column="RoleID" />
</set>
<many-to-one
class="com.llic.usermanager.data.ApplicationVO"
column="ApplicationID"
name="application"
cascade="save-update"
not-null="true"
/>
</class>
</hibernate-mapping>
RoleVO.hbm
Code:
<?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>
<class name="com.llic.usermanager.data.RoleVO" schema="USERMGR" table="Role">
<id
column="RoleID"
name="id"
type="java.lang.Long"
>
<generator class="native" />
</id>
<property
column="Code"
length="20"
name="name"
not-null="true"
type="java.lang.String"
/>
<property
column="Description"
length="254"
name="description"
type="java.lang.String"
/>
<!-- user objects. this is the inverse end -->
<set
inverse="true"
lazy="false"
name="users"
table="UserRole" cascade="save-update"
>
<key column="RoleID" />
<many-to-many class="com.llic.usermanager.data.UserVO" column="UserID" />
</set>
<!--TODO After the MN has been defined, we need to do this -->
<set
inverse="true"
lazy="false"
name="groups"
table="GroupRole" cascade="save-update"
>
<key column="RoleID" />
<many-to-many class="com.llic.usermanager.data.GroupVO" column="GroupID" />
</set>
<many-to-one
class="com.llic.usermanager.data.ApplicationVO"
column="ApplicationID"
name="application"
cascade="save-update"
not-null="true"
/>
</class>
</hibernate-mapping>
UserVO.hbm
Code:
<?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>
<class name="com.llic.usermanager.data.UserVO" schema="USERMGR" table="User">
<id
column="UserID"
name="id"
type="java.lang.Long"
>
<generator class="native" />
</id>
<property
column="UserName"
length="30"
name="userName"
not-null="true"
type="java.lang.String"
/>
<property
column="Password"
length="20"
name="password"
not-null="true"
type="java.lang.String"
/>
<property
column="FirstName"
length="35"
name="firstName"
not-null="true"
type="java.lang.String"
/>
<property
column="LastName"
length="35"
name="lastName"
not-null="true"
type="java.lang.String"
/>
<property
column="Department"
length="35"
name="department"
not-null="true"
type="java.lang.String"
/>
<property
column="Email"
length="75"
name="emailAddress"
not-null="false"
type="java.lang.String"
/>
<property
column="Enabled"
length="1"
name="enabled"
not-null="true"
type="java.lang.String"
/>
<!-- The user to roles mapping -->
<set
cascade="save-update"
lazy="false"
name="roles"
table="UserRoles"
>
<key column="UserID" />
<many-to-many class="com.llic.usermanager.data.RoleVO" column="RoleID" />
</set>
<!-- The user to groups mapping -->
<set
cascade="save-update"
lazy="false"
name="groups"
table="UserGroup"
>
<key column="UserID" />
<many-to-many class="com.llic.usermanager.data.GroupVO" column="GroupID" />
</set>
<many-to-one
cascade="save-update"
class="com.llic.usermanager.data.ApplicationVO"
column="ApplicationID"
name="application"
not-null="true"
/>
</class>
</hibernate-mapping>
I'm using spring framework as my EJB wrapper for hibernate.
Code:
public Object doInHibernate(Session session) throws HibernateException {
checkWriteOperationAllowed(session);
return session.saveOrUpdateCopy(entity);
Full stack trace of any exception that occurs:Code:
org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: deleted object would be re-saved by cascade (remove deleted object from associations): 118, of class: com.llic.usermanager.data.RoleVO; nested exception is net.sf.hibernate.ObjectDeletedException: deleted object would be re-saved by cascade (remove deleted object from associations): 118, of class: com.llic.usermanager.data.RoleVO
net.sf.hibernate.ObjectDeletedException: deleted object would be re-saved by cascade (remove deleted object from associations): 118, of class: com.llic.usermanager.data.RoleVO
at net.sf.hibernate.impl.SessionImpl.forceFlush(SessionImpl.java:752)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:730)
at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:1376)
at net.sf.hibernate.engine.Cascades$4.cascade(Cascades.java:114)
at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:436)
at net.sf.hibernate.engine.Cascades.cascadeCollection(Cascades.java:526)
at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:452)
at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:503)
at net.sf.hibernate.engine.Cascades.cascade(Cascades.java:482)
at net.sf.hibernate.impl.SessionImpl.preFlushEntities(SessionImpl.java:2673)
at net.sf.hibernate.impl.SessionImpl.flushEverything(SessionImpl.java:2250)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2239)
at org.springframework.orm.hibernate.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:214)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:177)
at org.springframework.orm.hibernate.HibernateTemplate.saveOrUpdateCopy(HibernateTemplate.java:327)
at com.llic.usermanager.dao.hibernate.BaseDAOImpl.saveOrUpdate(BaseDAOImpl.java:55)
at com.llic.usermanager.dao.ApplicationDAOTest.testGeneralFunctions(ApplicationDAOTest.java:86)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
Name and version of the database you are using:
DB2 UDB 8.1.6
The generated SQL (show_sql=true):
The SQL succeeds, the error comes during the session flush
Debug level Hibernate log excerpt:
[code]
2004-10-08 14:57:19,420 DEBUG [org.springframework.orm.hibernate.SessionFactoryUtils] - <Opening Hibernate session>
2004-10-08 14:57:19,420 DEBUG [net.sf.hibernate.impl.SessionImpl] - <opened session>
2004-10-08 14:57:19,420 DEBUG [net.sf.hibernate.engine.Cascades] - <id unsaved-value strategy NULL>
2004-10-08 14:57:19,435 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,435 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,435 DEBUG [net.sf.hibernate.impl.SessionImpl] - <object not resolved in any cache [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,435 DEBUG [net.sf.hibernate.persister.EntityPersister] - <Materializing entity: [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,435 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,435 DEBUG [net.sf.hibernate.SQL] - <select applicatio0_.ApplicationId as Applicat1_0_, applicatio0_.ApplicationName as Applicat2_0_, applicatio0_.Description as Descript3_0_ from USERMGR.Application applicatio0_ where applicatio0_.ApplicationId=?>
Hibernate: select applicatio0_.ApplicationId as Applicat1_0_, applicatio0_.ApplicationName as Applicat2_0_, applicatio0_.Description as Descript3_0_ from USERMGR.Application applicatio0_ where applicatio0_.ApplicationId=?
2004-10-08 14:57:19,451 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,451 DEBUG [net.sf.hibernate.type.LongType] - <binding '45' to parameter: 1>
2004-10-08 14:57:19,451 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,451 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 45>
2004-10-08 14:57:19,451 DEBUG [net.sf.hibernate.loader.Loader] - <Initializing object from ResultSet: 45>
2004-10-08 14:57:19,451 DEBUG [net.sf.hibernate.loader.Loader] - <Hydrating entity: com.llic.usermanager.data.ApplicationVO#45>
2004-10-08 14:57:19,466 DEBUG [net.sf.hibernate.type.StringType] - <returning 'Test Application ' as column: Applicat2_0_>
2004-10-08 14:57:19,466 DEBUG [net.sf.hibernate.type.StringType] - <returning null as column: Descript3_0_>
2004-10-08 14:57:19,466 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (1 rows)>
2004-10-08 14:57:19,466 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,466 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 1>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolving associations for [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.ApplicationVO.users#45]>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.ApplicationVO.groups#45]>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <done materializing entity [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing non-lazy collections>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,482 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,498 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,498 DEBUG [net.sf.hibernate.SQL] - <select roles0_.ApplicationID as Applicat4___, roles0_.RoleID as RoleID__, roles0_.RoleID as RoleID0_, roles0_.Code as Code0_, roles0_.Description as Descript3_0_, roles0_.ApplicationID as Applicat4_0_ from USERMGR.Role roles0_ where roles0_.ApplicationID=?>
Hibernate: select roles0_.ApplicationID as Applicat4___, roles0_.RoleID as RoleID__, roles0_.RoleID as RoleID0_, roles0_.Code as Code0_, roles0_.Description as Descript3_0_, roles0_.ApplicationID as Applicat4_0_ from USERMGR.Role roles0_ where roles0_.ApplicationID=?
2004-10-08 14:57:19,498 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,498 DEBUG [net.sf.hibernate.type.LongType] - <binding '45' to parameter: 1>
2004-10-08 14:57:19,498 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,498 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.type.LongType] - <returning '133' as column: RoleID0_>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 133>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.loader.Loader] - <Initializing object from ResultSet: 133>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.loader.Loader] - <Hydrating entity: com.llic.usermanager.data.RoleVO#133>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.type.StringType] - <returning 'Test Role 1 ' as column: Code0_>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.type.StringType] - <returning null as column: Descript3_0_>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4_0_>
2004-10-08 14:57:19,513 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4___>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.type.LongType] - <returning '133' as column: RoleID__>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.type.LongType] - <returning '135' as column: RoleID0_>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 135>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.loader.Loader] - <Initializing object from ResultSet: 135>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.loader.Loader] - <Hydrating entity: com.llic.usermanager.data.RoleVO#135>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.type.StringType] - <returning 'Test Role 2 ' as column: Code0_>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.type.StringType] - <returning null as column: Descript3_0_>
2004-10-08 14:57:19,529 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4_0_>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4___>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.type.LongType] - <returning '135' as column: RoleID__>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID0_>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 134>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.loader.Loader] - <Initializing object from ResultSet: 134>
2004-10-08 14:57:19,545 DEBUG [net.sf.hibernate.loader.Loader] - <Hydrating entity: com.llic.usermanager.data.RoleVO#134>
2004-10-08 14:57:19,560 DEBUG [net.sf.hibernate.type.StringType] - <returning 'Test Role 3 ' as column: Code0_>
2004-10-08 14:57:19,560 DEBUG [net.sf.hibernate.type.StringType] - <returning null as column: Descript3_0_>
2004-10-08 14:57:19,560 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4_0_>
2004-10-08 14:57:19,560 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4___>
2004-10-08 14:57:19,560 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID__>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (3 rows)>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 3>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolving associations for [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.RoleVO.users#133]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.RoleVO.groups#133]>
2004-10-08 14:57:19,576 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <done materializing entity [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolving associations for [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.RoleVO.users#135]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.RoleVO.groups#135]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <done materializing entity [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolving associations for [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.RoleVO.users#134]>
2004-10-08 14:57:19,591 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.RoleVO.groups#134]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <done materializing entity [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.ApplicationVO.roles#45]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.RoleVO.groups#134]>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,607 DEBUG [net.sf.hibernate.SQL] - <select groups0_.RoleID as RoleID__, groups0_.GroupID as GroupID__, groupvo1_.GroupID as GroupID0_, groupvo1_.Code as Code0_, groupvo1_.Description as Descript3_0_, groupvo1_.ApplicationID as Applicat4_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from GroupRole groups0_ inner join USERMGR.Group groupvo1_ on groups0_.GroupID=groupvo1_.GroupID left outer join USERMGR.Application applicatio2_ on groupvo1_.ApplicationID=applicatio2_.ApplicationId where groups0_.RoleID=?>
Hibernate: select groups0_.RoleID as RoleID__, groups0_.GroupID as GroupID__, groupvo1_.GroupID as GroupID0_, groupvo1_.Code as Code0_, groupvo1_.Description as Descript3_0_, groupvo1_.ApplicationID as Applicat4_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from GroupRole groups0_ inner join USERMGR.Group groupvo1_ on groups0_.GroupID=groupvo1_.GroupID left outer join USERMGR.Application applicatio2_ on groupvo1_.ApplicationID=applicatio2_.ApplicationId where groups0_.RoleID=?
2004-10-08 14:57:19,623 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,623 DEBUG [net.sf.hibernate.type.LongType] - <binding '134' to parameter: 1>
2004-10-08 14:57:19,623 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.RoleVO.groups#134]>
2004-10-08 14:57:19,623 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,623 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,623 DEBUG [net.sf.hibernate.type.LongType] - <returning '89' as column: GroupID0_>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 89, 45>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.loader.Loader] - <Initializing object from ResultSet: 89>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.loader.Loader] - <Hydrating entity: com.llic.usermanager.data.GroupVO#89>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.type.StringType] - <returning 'Test Group 2 ' as column: Code0_>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.type.StringType] - <returning null as column: Descript3_0_>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4_0_>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID__>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.RoleVO.groups#134]>
2004-10-08 14:57:19,638 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.LongType] - <returning '89' as column: GroupID__>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.GroupVO#89]>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.GroupVO#89]>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.GroupVO#89]>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.LongType] - <returning '90' as column: GroupID0_>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 90, 45>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.loader.Loader] - <Initializing object from ResultSet: 90>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.loader.Loader] - <Hydrating entity: com.llic.usermanager.data.GroupVO#90>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.StringType] - <returning 'Test Group 1 ' as column: Code0_>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.StringType] - <returning null as column: Descript3_0_>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat4_0_>
2004-10-08 14:57:19,654 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID__>
2004-10-08 14:57:19,670 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.RoleVO.groups#134]>
2004-10-08 14:57:19,685 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,685 DEBUG [net.sf.hibernate.type.LongType] - <returning '90' as column: GroupID__>
2004-10-08 14:57:19,685 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.GroupVO#90]>
2004-10-08 14:57:19,685 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.GroupVO#90]>
2004-10-08 14:57:19,685 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.GroupVO#90]>
2004-10-08 14:57:19,685 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (2 rows)>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 2>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolving associations for [com.llic.usermanager.data.GroupVO#89]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.GroupVO.users#89]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.GroupVO.roles#89]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <done materializing entity [com.llic.usermanager.data.GroupVO#89]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolving associations for [com.llic.usermanager.data.GroupVO#90]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.GroupVO.users#90]>
2004-10-08 14:57:19,701 DEBUG [net.sf.hibernate.impl.SessionImpl] - <creating collection wrapper:[com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.ApplicationVO#45]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <done materializing entity [com.llic.usermanager.data.GroupVO#90]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.RoleVO.groups#134]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,716 DEBUG [net.sf.hibernate.SQL] - <select roles0_.GroupID as GroupID__, roles0_.RoleID as RoleID__, rolevo1_.RoleID as RoleID0_, rolevo1_.Code as Code0_, rolevo1_.Description as Descript3_0_, rolevo1_.ApplicationID as Applicat4_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from GroupRole roles0_ inner join USERMGR.Role rolevo1_ on roles0_.RoleID=rolevo1_.RoleID left outer join USERMGR.Application applicatio2_ on rolevo1_.ApplicationID=applicatio2_.ApplicationId where roles0_.GroupID=?>
Hibernate: select roles0_.GroupID as GroupID__, roles0_.RoleID as RoleID__, rolevo1_.RoleID as RoleID0_, rolevo1_.Code as Code0_, rolevo1_.Description as Descript3_0_, rolevo1_.ApplicationID as Applicat4_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from GroupRole roles0_ inner join USERMGR.Role rolevo1_ on roles0_.RoleID=rolevo1_.RoleID left outer join USERMGR.Application applicatio2_ on rolevo1_.ApplicationID=applicatio2_.ApplicationId where roles0_.GroupID=?
2004-10-08 14:57:19,732 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,732 DEBUG [net.sf.hibernate.type.LongType] - <binding '90' to parameter: 1>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.type.LongType] - <returning '133' as column: RoleID0_>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 133, 45>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.type.LongType] - <returning '90' as column: GroupID__>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.type.LongType] - <returning '133' as column: RoleID__>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,748 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID0_>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 134, 45>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '90' as column: GroupID__>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID__>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '135' as column: RoleID0_>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 135, 45>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '90' as column: GroupID__>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,763 DEBUG [net.sf.hibernate.type.LongType] - <returning '135' as column: RoleID__>
2004-10-08 14:57:19,779 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,779 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,779 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#135]>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (3 rows)>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 0>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.GroupVO.roles#90]>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.GroupVO.users#90]>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,795 DEBUG [net.sf.hibernate.SQL] - <select users0_.GroupID as GroupID__, users0_.UserID as UserID__, uservo1_.UserID as UserID0_, uservo1_.UserName as UserName0_, uservo1_.Password as Password0_, uservo1_.FirstName as FirstName0_, uservo1_.LastName as LastName0_, uservo1_.Department as Department0_, uservo1_.Email as Email0_, uservo1_.Enabled as Enabled0_, uservo1_.ApplicationID as Applicat9_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from UserGroup users0_ inner join USERMGR.User uservo1_ on users0_.UserID=uservo1_.UserID left outer join USERMGR.Application applicatio2_ on uservo1_.ApplicationID=applicatio2_.ApplicationId where users0_.GroupID=?>
Hibernate: select users0_.GroupID as GroupID__, users0_.UserID as UserID__, uservo1_.UserID as UserID0_, uservo1_.UserName as UserName0_, uservo1_.Password as Password0_, uservo1_.FirstName as FirstName0_, uservo1_.LastName as LastName0_, uservo1_.Department as Department0_, uservo1_.Email as Email0_, uservo1_.Enabled as Enabled0_, uservo1_.ApplicationID as Applicat9_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from UserGroup users0_ inner join USERMGR.User uservo1_ on users0_.UserID=uservo1_.UserID left outer join USERMGR.Application applicatio2_ on uservo1_.ApplicationID=applicatio2_.ApplicationId where users0_.GroupID=?
2004-10-08 14:57:19,810 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,810 DEBUG [net.sf.hibernate.type.LongType] - <binding '90' to parameter: 1>
2004-10-08 14:57:19,810 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.GroupVO.users#90]>
2004-10-08 14:57:19,810 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,810 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (0 rows)>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 0>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.GroupVO.users#90]>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.GroupVO.roles#89]>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,826 DEBUG [net.sf.hibernate.SQL] - <select roles0_.GroupID as GroupID__, roles0_.RoleID as RoleID__, rolevo1_.RoleID as RoleID0_, rolevo1_.Code as Code0_, rolevo1_.Description as Descript3_0_, rolevo1_.ApplicationID as Applicat4_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from GroupRole roles0_ inner join USERMGR.Role rolevo1_ on roles0_.RoleID=rolevo1_.RoleID left outer join USERMGR.Application applicatio2_ on rolevo1_.ApplicationID=applicatio2_.ApplicationId where roles0_.GroupID=?>
Hibernate: select roles0_.GroupID as GroupID__, roles0_.RoleID as RoleID__, rolevo1_.RoleID as RoleID0_, rolevo1_.Code as Code0_, rolevo1_.Description as Descript3_0_, rolevo1_.ApplicationID as Applicat4_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from GroupRole roles0_ inner join USERMGR.Role rolevo1_ on roles0_.RoleID=rolevo1_.RoleID left outer join USERMGR.Application applicatio2_ on rolevo1_.ApplicationID=applicatio2_.ApplicationId where roles0_.GroupID=?
2004-10-08 14:57:19,841 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,841 DEBUG [net.sf.hibernate.type.LongType] - <binding '89' to parameter: 1>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.GroupVO.roles#89]>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.type.LongType] - <returning '133' as column: RoleID0_>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 133, 45>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.type.LongType] - <returning '89' as column: GroupID__>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.GroupVO.roles#89]>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.type.LongType] - <returning '133' as column: RoleID__>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#133]>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID0_>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.type.LongType] - <returning '45' as column: Applicat1_1_>
2004-10-08 14:57:19,857 DEBUG [net.sf.hibernate.loader.Loader] - <result row: 134, 45>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.type.LongType] - <returning '89' as column: GroupID__>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.loader.Loader] - <found row of collection: [com.llic.usermanager.data.GroupVO.roles#89]>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <reading row>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.type.LongType] - <returning '134' as column: RoleID__>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <loading [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <attempting to resolve [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <resolved object in session cache [com.llic.usermanager.data.RoleVO#134]>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (2 rows)>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 0>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.GroupVO.roles#89]>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,873 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
2004-10-08 14:57:19,888 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.GroupVO.users#89]>
2004-10-08 14:57:19,888 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,888 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,888 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,888 DEBUG [net.sf.hibernate.SQL] - <select users0_.GroupID as GroupID__, users0_.UserID as UserID__, uservo1_.UserID as UserID0_, uservo1_.UserName as UserName0_, uservo1_.Password as Password0_, uservo1_.FirstName as FirstName0_, uservo1_.LastName as LastName0_, uservo1_.Department as Department0_, uservo1_.Email as Email0_, uservo1_.Enabled as Enabled0_, uservo1_.ApplicationID as Applicat9_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from UserGroup users0_ inner join USERMGR.User uservo1_ on users0_.UserID=uservo1_.UserID left outer join USERMGR.Application applicatio2_ on uservo1_.ApplicationID=applicatio2_.ApplicationId where users0_.GroupID=?>
Hibernate: select users0_.GroupID as GroupID__, users0_.UserID as UserID__, uservo1_.UserID as UserID0_, uservo1_.UserName as UserName0_, uservo1_.Password as Password0_, uservo1_.FirstName as FirstName0_, uservo1_.LastName as LastName0_, uservo1_.Department as Department0_, uservo1_.Email as Email0_, uservo1_.Enabled as Enabled0_, uservo1_.ApplicationID as Applicat9_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from UserGroup users0_ inner join USERMGR.User uservo1_ on users0_.UserID=uservo1_.UserID left outer join USERMGR.Application applicatio2_ on uservo1_.ApplicationID=applicatio2_.ApplicationId where users0_.GroupID=?
2004-10-08 14:57:19,904 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,904 DEBUG [net.sf.hibernate.type.LongType] - <binding '89' to parameter: 1>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.GroupVO.users#89]>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (0 rows)>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 0>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.GroupVO.users#89]>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
2004-10-08 14:57:19,920 DEBUG [net.sf.hibernate.impl.SessionImpl] - <initializing collection [com.llic.usermanager.data.RoleVO.users#134]>
2004-10-08 14:57:19,935 DEBUG [net.sf.hibernate.impl.SessionImpl] - <checking second-level cache>
2004-10-08 14:57:19,935 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection not cached>
2004-10-08 14:57:19,935 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <about to open: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,935 DEBUG [net.sf.hibernate.SQL] - <select users0_.RoleID as RoleID__, users0_.UserID as UserID__, uservo1_.UserID as UserID0_, uservo1_.UserName as UserName0_, uservo1_.Password as Password0_, uservo1_.FirstName as FirstName0_, uservo1_.LastName as LastName0_, uservo1_.Department as Department0_, uservo1_.Email as Email0_, uservo1_.Enabled as Enabled0_, uservo1_.ApplicationID as Applicat9_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from UserRole users0_ inner join USERMGR.User uservo1_ on users0_.UserID=uservo1_.UserID left outer join USERMGR.Application applicatio2_ on uservo1_.ApplicationID=applicatio2_.ApplicationId where users0_.RoleID=?>
Hibernate: select users0_.RoleID as RoleID__, users0_.UserID as UserID__, uservo1_.UserID as UserID0_, uservo1_.UserName as UserName0_, uservo1_.Password as Password0_, uservo1_.FirstName as FirstName0_, uservo1_.LastName as LastName0_, uservo1_.Department as Department0_, uservo1_.Email as Email0_, uservo1_.Enabled as Enabled0_, uservo1_.ApplicationID as Applicat9_0_, applicatio2_.ApplicationId as Applicat1_1_, applicatio2_.ApplicationName as Applicat2_1_, applicatio2_.Description as Descript3_1_ from UserRole users0_ inner join USERMGR.User uservo1_ on users0_.UserID=uservo1_.UserID left outer join USERMGR.Application applicatio2_ on uservo1_.ApplicationID=applicatio2_.ApplicationId where users0_.RoleID=?
2004-10-08 14:57:19,935 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <preparing statement>
2004-10-08 14:57:19,935 DEBUG [net.sf.hibernate.type.LongType] - <binding '134' to parameter: 1>
2004-10-08 14:57:19,951 DEBUG [net.sf.hibernate.loader.Loader] - <result set contains (possibly empty) collection: [com.llic.usermanager.data.RoleVO.users#134]>
2004-10-08 14:57:19,951 DEBUG [net.sf.hibernate.impl.SessionImpl] - <uninitialized collection: initializing>
2004-10-08 14:57:19,951 DEBUG [net.sf.hibernate.loader.Loader] - <processing result set>
2004-10-08 14:57:19,951 DEBUG [net.sf.hibernate.loader.Loader] - <done processing result set (0 rows)>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <done closing: 0 open PreparedStatements, 0 open ResultSets>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.impl.BatcherImpl] - <closing statement>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.loader.Loader] - <total objects hydrated: 0>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections were found in result set>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection fully initialized: [com.llic.usermanager.data.RoleVO.users#134]>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.impl.SessionImpl] - <1 collections initialized>
2004-10-08 14:57:19,966 DEBUG [net.sf.hibernate.impl.SessionImpl] - <collection initialized>
Login
FAQ
Search
