Joined: Sun Feb 19, 2006 2:46 pm Posts: 6
|
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version:The one shipping with JBoss 4.0.4GA - I think 3.1.x
Mapping documents:
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs: 11:32:19,078 DEBUG [UserDao] attaching dirty User instance 11:32:23,140 DEBUG [SessionFactoryObjectFactory] JNDI lookup: hibernate/NetSalesSessionFactory 11:32:23,140 DEBUG [SessionFactoryObjectFactory] lookup: uid=4028e40f0e7970c8010e7970d9000000 11:32:23,140 DEBUG [JDBCContext] successfully registered Synchronization 11:32:23,140 DEBUG [SessionImpl] opened session at timestamp: 4758236131901440 11:32:23,171 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 11:32:23,171 DEBUG [ConnectionManager] opening JDBC connection 11:32:23,171 DEBUG [SQL] /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,171 INFO [STDOUT] Hibernate: /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,187 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 11:32:23,187 DEBUG [ConnectionManager] aggressively releasing JDBC connection 11:32:23,187 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 11:32:23,187 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 11:32:23,187 DEBUG [ConnectionManager] opening JDBC connection 11:32:23,187 DEBUG [SQL] /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,203 INFO [STDOUT] Hibernate: /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,218 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 11:32:23,218 DEBUG [ConnectionManager] aggressively releasing JDBC connection 11:32:23,218 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 11:32:23,234 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 11:32:23,234 DEBUG [ConnectionManager] opening JDBC connection 11:32:23,234 DEBUG [SQL] /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,234 INFO [STDOUT] Hibernate: /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,250 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 11:32:23,250 DEBUG [ConnectionManager] aggressively releasing JDBC connection 11:32:23,250 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 11:32:23,250 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 11:32:23,250 DEBUG [ConnectionManager] opening JDBC connection 11:32:23,250 DEBUG [SQL] /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,265 INFO [STDOUT] Hibernate: /* get current state cy.comp.sales.model.adm.UserGroup */ select usergroup_.ADM_USER_ID, usergroup_.ADM_GROUP_ID, usergroup_.INSERT_USER as INSERT3_23_, usergroup_.INSERT_DATE as INSERT4_23_ from NETSALES.ADM_USER_GROUP usergroup_ where usergroup_.ADM_USER_ID=? and usergroup_.ADM_GROUP_ID=? 11:32:23,265 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 11:32:23,265 DEBUG [ConnectionManager] aggressively releasing JDBC connection 11:32:23,265 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 11:32:23,265 DEBUG [UserDao] attach successful 11:33:00,562 DEBUG [AbstractFlushingEventListener] processing flush-time cascades 11:33:00,562 DEBUG [AbstractFlushingEventListener] dirty checking collections 11:33:00,562 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 11:33:00,562 DEBUG [ConnectionManager] opening JDBC connection 11:33:00,562 DEBUG [SQL] select systimestamp from dual 11:33:00,578 INFO [STDOUT] Hibernate: select systimestamp from dual 11:33:00,578 DEBUG [AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0) 11:33:00,593 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 11:33:00,593 DEBUG [ConnectionManager] skipping aggresive-release due to open resources on batcher 11:33:00,609 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.accountHoldersForModifyUser#temp1], was: [cy.comp.sales.model.adm.User.accountHoldersForModifyUser#temp1] (uninitialized) 11:33:00,609 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.usersForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.usersForInsertUser#temp1] (uninitialized) 11:33:00,609 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.usersForModifyUser#temp1], was: [cy.comp.sales.model.adm.User.usersForModifyUser#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.accountHoldersForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.accountHoldersForInsertUser#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.accountsForModifyUser#temp1], was: [cy.comp.sales.model.adm.User.accountsForModifyUser#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.transactions#temp1], was: [cy.comp.sales.model.adm.User.transactions#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.groupFunctions#temp1], was: [cy.comp.sales.model.adm.User.groupFunctions#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.userGroupsForUser#temp1], was: [<unreferenced>] (initialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.tanListsForModifyUser#temp1], was: [cy.comp.sales.model.adm.User.tanListsForModifyUser#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.userGroupsForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.userGroupsForInsertUser#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.customersForModifyUser#temp1], was: [cy.comp.sales.model.adm.User.customersForModifyUser#temp1] (uninitialized) 11:33:00,625 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.tanListsForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.tanListsForInsertUser#temp1] (uninitialized) 11:33:00,640 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.accountOwners#temp1], was: [cy.comp.sales.model.adm.User.accountOwners#temp1] (uninitialized) 11:33:00,640 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.functionMenus#temp1], was: [cy.comp.sales.model.adm.User.functionMenus#temp1] (uninitialized) 11:33:00,640 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.pinsForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.pinsForInsertUser#temp1] (uninitialized) 11:33:00,640 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.pinsForModifyUser#temp1], was: [cy.comp.sales.model.adm.User.pinsForModifyUser#temp1] (uninitialized) 11:33:00,640 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.accountsForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.accountsForInsertUser#temp1] (uninitialized) 11:33:00,640 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.User.customersForInsertUser#temp1], was: [cy.comp.sales.model.adm.User.customersForInsertUser#temp1] (uninitialized) 11:33:00,656 DEBUG [AbstractFlushingEventListener] Flushed: 0 insertions, 1 updates, 0 deletions to 5 objects 11:33:00,656 DEBUG [AbstractFlushingEventListener] Flushed: 1 (re)creations, 0 updates, 1 removals to 18 collections 11:33:00,656 DEBUG [Printer] listing entities: 11:33:00,671 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#TEST, user=cy.comp.sales.model.adm.User#temp1, insertDate=23 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=TEST, userId=temp1}} 11:33:00,671 DEBUG [Printer] cy.comp.sales.model.adm.User{accountsForInsertUser=<uninitialized>, deleteDate=null, userGroupsForUser=[cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TELL, userId=temp1}, cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TEST, userId=temp1}, cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=SUPER, userId=temp1}, cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=ADMIN, userId=temp1}], groupFunctions=<uninitialized>, userLogin=temp1, deleteUser=null, accountHoldersForModifyUser=<uninitialized>, id=temp1, usersForInsertUser=<uninitialized>, pinsForModifyUser=<uninitialized>, modifyUser=cy.comp.sales.model.adm.User#EVA, accountsForModifyUser=<uninitialized>, customersForInsertUser=<uninitialized>, location=null, insertUser=cy.comp.sales.model.adm.User#EVA, functionMenus=<uninitialized>, application=cy.comp.sales.model.adm.Application#400, deleted=false, active=false, pinsForInsertUser=<uninitialized>, userName=temp1, transactions=<uninitialized>, usersForModifyUser=<uninitialized>, userPassword=temp, tanListsForModifyUser=<uninitialized>, tryCount=null, accountHoldersForInsertUser=<uninitialized>, tanListsForInsertUser=<uninitialized>, accountOwners=<uninitialized>, userGroupsForInsertUser=<uninitialized>, insertDate=06 October 2006, customersForModifyUser=<uninitialized>, email=temp@temp.com1, modifyDate=2006-10-24 11:36:36} 11:33:00,687 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#TELL, user=cy.comp.sales.model.adm.User#temp1, insertDate=20 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=TELL, userId=temp1}} 11:33:00,687 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#ADMIN, user=cy.comp.sales.model.adm.User#temp1, insertDate=24 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=ADMIN, userId=temp1}} 11:33:00,687 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#SUPER, user=cy.comp.sales.model.adm.User#temp1, insertDate=24 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=SUPER, userId=temp1}} 11:33:00,703 DEBUG [UpdateTimestampsCache] Pre-invalidating space [NETSALES.ADM_USER] 11:33:00,718 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 11:33:00,718 DEBUG [SQL] /* update cy.comp.sales.model.adm.User */ update NETSALES.ADM_USER set ADM_APPLICATION_ID=?, MODIFY_USER=?, INSERT_USER=?, ADM_LOCATION_ID=?, USER_NAME=?, USER_LOGIN=?, USER_PASSWORD=?, TRY_COUNT=?, ACTIVE=?, EMAIL=?, DELETED=?, DELETE_USER=?, DELETE_DATE=?, INSERT_DATE=? where ID=? and MODIFY_DATE=? 11:33:00,718 INFO [STDOUT] Hibernate: /* update cy.comp.sales.model.adm.User */ update NETSALES.ADM_USER set ADM_APPLICATION_ID=?, MODIFY_USER=?, INSERT_USER=?, ADM_LOCATION_ID=?, USER_NAME=?, USER_LOGIN=?, USER_PASSWORD=?, TRY_COUNT=?, ACTIVE=?, EMAIL=?, DELETED=?, DELETE_USER=?, DELETE_DATE=?, INSERT_DATE=? where ID=? and MODIFY_DATE=? 11:33:00,734 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 11:33:00,734 DEBUG [ConnectionManager] skipping aggressive-release due to flush cycle 11:33:00,734 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [cy.comp.sales.model.adm.User#temp1] at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1680) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2272) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2180) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2450) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:91) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:340) at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1491) at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1110) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:324) at org.jboss.tm.TxManager.commit(TxManager.java:240) at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:181) at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:79) at $Proxy86.saveUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.commons.beanutils.MethodUtils.invokeExactMethod(MethodUtils.java:334) at org.apache.commons.beanutils.MethodUtils.invokeExactMethod(MethodUtils.java:286) at cy.comp.NETSALES.ejb.NETSALESProxyBean.invoke(NETSALESProxyBean.java:28) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66) at org.jboss.aspects.tx.TxInterceptor$Never.invoke(TxInterceptor.java:65) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225) at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106) at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239) 11:33:00,812 DEBUG [ConnectionManager] skipping aggresive-release due to open resources on batcher 11:33:00,812 INFO [ConnectionManager] forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator? 11:33:00,812 DEBUG [AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1) 11:33:00,828 WARN [AbstractBatcher] Could not close a JDBC result set java.sql.SQLException: Already closed at org.jboss.resource.adapter.jdbc.WrappedResultSet.close(WrappedResultSet.java:178) at org.hibernate.jdbc.AbstractBatcher.closeStatements(AbstractBatcher.java:310) at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:291) at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:214) at org.hibernate.transaction.CacheSynchronization.afterCompletion(CacheSynchronization.java:85) at org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1526) at org.jboss.tm.TransactionImpl.completeTransaction(TransactionImpl.java:1198) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:369) at org.jboss.tm.TxManager.commit(TxManager.java:240) at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:181) at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:79) at $Proxy86.saveUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.commons.beanutils.MethodUtils.invokeExactMethod(MethodUtils.java:334) at org.apache.commons.beanutils.MethodUtils.invokeExactMethod(MethodUtils.java:286) at cy.comp.NETSALES.ejb.NETSALESProxyBean.invoke(NETSALESProxyBean.java:28) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112) at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166) at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66) at org.jboss.aspects.tx.TxInterceptor$Never.invoke(TxInterceptor.java:65) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225) at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106) at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239) 11:33:00,859 DEBUG [ConnectionManager] aggressively releasing JDBC connection 11:33:00,859 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 11:33:00,859 DEBUG [UpdateTimestampsCache] Invalidating space [NETSALES.ADM_USER], timestamp: 4758236286398464 12:04:01,328 DEBUG [UserGroupDao] finding groups for user with id: temp1 12:04:01,328 DEBUG [SessionFactoryObjectFactory] JNDI lookup: hibernate/NetsalesSessionFactory 12:04:01,328 DEBUG [SessionFactoryObjectFactory] lookup: uid=4028e40f0e7970c8010e7970d9000000 12:04:01,328 DEBUG [JDBCContext] successfully registered Synchronization 12:04:01,328 DEBUG [SessionImpl] opened session at timestamp: 4758243906879488 12:04:01,328 DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 12:04:01,328 DEBUG [ConnectionManager] opening JDBC connection 12:04:01,453 DEBUG [SQL] /* named HQL query cy.comp.sales.query.adm.UserGroup.findByUserId() */ select distinct usergroup0_.ADM_USER_ID as ADM1_23_0_, usergroup0_.ADM_GROUP_ID as ADM2_23_0_, group1_.ID as ID13_1_, grouplangs2_.ADM_GROUP_ID as ADM1_15_2_, grouplangs2_.ADM_LANGUAGE_ID as ADM2_15_2_, usergroup0_.INSERT_USER as INSERT3_23_0_, usergroup0_.INSERT_DATE as INSERT4_23_0_, group1_.ADM_APPLICATION_ID as ADM2_13_1_, grouplangs2_.DESCRIPTION as DESCRIPT3_15_2_, grouplangs2_.ADM_GROUP_ID as ADM1_0__, grouplangs2_.ADM_LANGUAGE_ID as ADM2_0__ from NETSALES.ADM_USER_GROUP usergroup0_ left outer join NETSALES.ADM_GROUP group1_ on usergroup0_.ADM_GROUP_ID=group1_.ID left outer join NETSALES.ADM_GROUP_LANG grouplangs2_ on group1_.ID=grouplangs2_.ADM_GROUP_ID where usergroup0_.ADM_USER_ID=? 12:04:01,453 INFO [STDOUT] Hibernate: /* named HQL query cy.comp.sales.query.adm.UserGroup.findByUserId() */ select distinct usergroup0_.ADM_USER_ID as ADM1_23_0_, usergroup0_.ADM_GROUP_ID as ADM2_23_0_, group1_.ID as ID13_1_, grouplangs2_.ADM_GROUP_ID as ADM1_15_2_, grouplangs2_.ADM_LANGUAGE_ID as ADM2_15_2_, usergroup0_.INSERT_USER as INSERT3_23_0_, usergroup0_.INSERT_DATE as INSERT4_23_0_, group1_.ADM_APPLICATION_ID as ADM2_13_1_, grouplangs2_.DESCRIPTION as DESCRIPT3_15_2_, grouplangs2_.ADM_GROUP_ID as ADM1_0__, grouplangs2_.ADM_LANGUAGE_ID as ADM2_0__ from NETSALES.ADM_USER_GROUP usergroup0_ left outer join NETSALES.ADM_GROUP group1_ on usergroup0_.ADM_GROUP_ID=group1_.ID left outer join NETSALES.ADM_GROUP_LANG grouplangs2_ on group1_.ID=grouplangs2_.ADM_GROUP_ID where usergroup0_.ADM_USER_ID=? 12:04:01,453 DEBUG [QueryLoader] bindNamedParameters() temp1 -> userId [1] 12:04:01,468 DEBUG [AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0) 12:04:01,468 DEBUG [Loader] result row: EntityKey[cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=ADMIN, userId=temp1}], EntityKey[cy.comp.sales.model.adm.Group#ADMIN], EntityKey[cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=en}] 12:04:01,468 DEBUG [Loader] found row of collection: [cy.comp.sales.model.adm.Group.groupLangs#ADMIN] 12:04:01,468 DEBUG [Loader] result row: EntityKey[cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TELL, userId=temp1}], EntityKey[cy.comp.sales.model.adm.Group#TELL], null 12:04:01,468 DEBUG [Loader] result set contains (possibly empty) collection: [cy.comp.sales.model.adm.Group.groupLangs#TELL] 12:04:01,468 DEBUG [Loader] result row: EntityKey[cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=ADMIN, userId=temp1}], EntityKey[cy.comp.sales.model.adm.Group#ADMIN], EntityKey[cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=el}] 12:04:01,468 DEBUG [Loader] found row of collection: [cy.comp.sales.model.adm.Group.groupLangs#ADMIN] 12:04:01,468 DEBUG [Loader] result row: EntityKey[cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=SUPER, userId=temp1}], EntityKey[cy.comp.sales.model.adm.Group#SUPER], EntityKey[cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=SUPER, languageId=en}] 12:04:01,468 DEBUG [Loader] found row of collection: [cy.comp.sales.model.adm.Group.groupLangs#SUPER] 12:04:01,468 DEBUG [Loader] result row: EntityKey[cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TEST, userId=temp1}], EntityKey[cy.comp.sales.model.adm.Group#TEST], null 12:04:01,468 DEBUG [Loader] result set contains (possibly empty) collection: [cy.comp.sales.model.adm.Group.groupLangs#TEST] 12:04:01,468 DEBUG [AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1) 12:04:01,468 DEBUG [AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 12:04:01,468 DEBUG [ConnectionManager] aggressively releasing JDBC connection 12:04:01,468 DEBUG [ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=ADMIN, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=ADMIN, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.Group#ADMIN] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.Group#ADMIN] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=en}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=en}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TELL, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TELL, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.Group#TELL] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.Group#TELL] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=el}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=el}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=SUPER, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=SUPER, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.Group#SUPER] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.Group#SUPER] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=SUPER, languageId=en}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=SUPER, languageId=en}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TEST, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.UserGroup#component[userId,groupId]{groupId=TEST, userId=temp1}] 12:04:01,468 DEBUG [TwoPhaseLoad] resolving associations for [cy.comp.sales.model.adm.Group#TEST] 12:04:01,468 DEBUG [TwoPhaseLoad] done materializing entity [cy.comp.sales.model.adm.Group#TEST] 12:04:01,468 DEBUG [CollectionLoadContext] 4 collections were found in result set for role: cy.comp.sales.model.adm.Group.groupLangs 12:04:01,468 DEBUG [CollectionLoadContext] collection fully initialized: [cy.comp.sales.model.adm.Group.groupLangs#TEST] 12:04:01,468 DEBUG [CollectionLoadContext] collection fully initialized: [cy.comp.sales.model.adm.Group.groupLangs#SUPER] 12:04:01,468 DEBUG [CollectionLoadContext] collection fully initialized: [cy.comp.sales.model.adm.Group.groupLangs#TELL] 12:04:01,468 DEBUG [CollectionLoadContext] collection fully initialized: [cy.comp.sales.model.adm.Group.groupLangs#ADMIN] 12:04:01,468 DEBUG [CollectionLoadContext] 4 collections initialized for role: cy.comp.sales.model.adm.Group.groupLangs 12:04:01,484 DEBUG [StatefulPersistenceContext] initializing non-lazy collections 12:04:01,484 DEBUG [UserGroupDao] finding groups for user with id: temp1 successful 12:04:01,484 DEBUG [AbstractFlushingEventListener] processing flush-time cascades 12:04:01,484 DEBUG [AbstractFlushingEventListener] dirty checking collections 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupFunctions#ADMIN], was: [cy.comp.sales.model.adm.Group.groupFunctions#ADMIN] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupLangs#ADMIN], was: [cy.comp.sales.model.adm.Group.groupLangs#ADMIN] (initialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.userGroups#ADMIN], was: [cy.comp.sales.model.adm.Group.userGroups#ADMIN] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupFunctions#TELL], was: [cy.comp.sales.model.adm.Group.groupFunctions#TELL] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupLangs#TELL], was: [cy.comp.sales.model.adm.Group.groupLangs#TELL] (initialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.userGroups#TELL], was: [cy.comp.sales.model.adm.Group.userGroups#TELL] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupFunctions#SUPER], was: [cy.comp.sales.model.adm.Group.groupFunctions#SUPER] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupLangs#SUPER], was: [cy.comp.sales.model.adm.Group.groupLangs#SUPER] (initialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.userGroups#SUPER], was: [cy.comp.sales.model.adm.Group.userGroups#SUPER] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupFunctions#TEST], was: [cy.comp.sales.model.adm.Group.groupFunctions#TEST] (uninitialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.groupLangs#TEST], was: [cy.comp.sales.model.adm.Group.groupLangs#TEST] (initialized) 12:04:01,484 DEBUG [Collections] Collection found: [cy.comp.sales.model.adm.Group.userGroups#TEST], was: [cy.comp.sales.model.adm.Group.userGroups#TEST] (uninitialized) 12:04:01,484 DEBUG [AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 11 objects 12:04:01,484 DEBUG [AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 12 collections 12:04:01,484 DEBUG [Printer] listing entities: 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.Group{groupFunctions=<uninitialized>, userGroups=<uninitialized>, groupLangs=[], id=TEST, application=cy.comp.sales.model.adm.Application#400} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.Group{groupFunctions=<uninitialized>, userGroups=<uninitialized>, groupLangs=[cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=SUPER, languageId=en}], id=SUPER, application=cy.comp.sales.model.adm.Application#400} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.GroupLang{group=cy.comp.sales.model.adm.Group#ADMIN, description=??????s?, language=cy.comp.sales.model.adm.Language#el, id=component[groupId,languageId]{groupId=ADMIN, languageId=el}} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.Group{groupFunctions=<uninitialized>, userGroups=<uninitialized>, groupLangs=[], id=TELL, application=cy.comp.sales.model.adm.Application#400} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#TELL, user=cy.comp.sales.model.adm.User#temp1, insertDate=20 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=TELL, userId=temp1}} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#ADMIN, user=cy.comp.sales.model.adm.User#temp1, insertDate=24 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=ADMIN, userId=temp1}} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.GroupLang{group=cy.comp.sales.model.adm.Group#SUPER, description=SUPERVISOR, language=cy.comp.sales.model.adm.Language#en, id=component[groupId,languageId]{groupId=SUPER, languageId=en}} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#TEST, user=cy.comp.sales.model.adm.User#temp1, insertDate=23 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=TEST, userId=temp1}} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.GroupLang{group=cy.comp.sales.model.adm.Group#ADMIN, description=Administrators, language=cy.comp.sales.model.adm.Language#en, id=component[groupId,languageId]{groupId=ADMIN, languageId=en}} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.Group{groupFunctions=<uninitialized>, userGroups=<uninitialized>, groupLangs=[cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=el}, cy.comp.sales.model.adm.GroupLang#component[groupId,languageId]{groupId=ADMIN, languageId=en}], id=ADMIN, application=cy.comp.sales.model.adm.Application#400} 12:04:01,484 DEBUG [Printer] cy.comp.sales.model.adm.UserGroup{group=cy.comp.sales.model.adm.Group#SUPER, user=cy.comp.sales.model.adm.User#temp1, insertDate=24 October 2006, insertUser=cy.comp.sales.model.adm.User#EVA, id=component[userId,groupId]{groupId=SUPER, userId=temp1}} 12:04:01,500 DEBUG [ConnectionManager] aggressively releasing JDBC connection
Name and version of the database you are using:Oracle 10g
The generated SQL (show_sql=true):
update cy.com.comp.model.adm.User */ update NETTINS.ADM_USER set ADM_APPLICATION_ID=?, MODIFY_USER=?, INSERT_USER=?, ADM_LOCATION_ID=?, USER_NAME=?, USER_LOGIN=?, USER_PASSWORD=?, TRY_COUNT=?, ACTIVE=?, EMAIL=?, DELETED=?, DELETE_USER=?, DELETE_DATE=?, INSERT_DATE=? where ID=? and MODIFY_DATE=?
Debug level Hibernate log Dont remember
Hello everybody
I am fighting with Oracle 10g since yesterday to manage a save or update but I keep getting the org.hibernate.StaleObjectStateException. The thing is that I have a timestamp property which is generated from the database using a trigger. As you see in the stacktrace above I get the org.hibernate.StaleObjectStateException and also java.sql.SQLException. The latter one is almost always there. It passed my mind that maybe Oracle does not handle timestamps very well. and after I found this at http://www.hibernate.org/80.html
Oracle
License: Commercial
URL: http://technet.oracle.com/
URL: http://www.oracle.com/technology/softwa ... index.html
Issues: Do not use JDBC drivers before version 9.2.0.3 for Oracle 9. These drivers have a round-off bug which strips off any number with decimals (e.g. from 666.67 to 666.0). Oracle JDBC drivers have extremely bad support for large text or binary columns. At least some versions of the Oracle 9i driver handle JDBC timestamps extremely badly - do not use timestamps for optimistic locking, use version numbers.
The database designer used the Date type for the column in the database that supposingly acts like a timestamp. Is this the reason I get this? Or is it the reason mentioned above and Oracle might have problems also with Date types when used as timestamps?
Also why do I get that SQLEception when my transaction is over?
Thank you guys.
I hope someone replies soon...
I dont get this ...whenever I used Hiberate with MySQL it all ran like a charm
Problems with Session and transaction handling?
Read this: http://hibernate.org/42.html
|
|