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

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: Oracle 10g and the org.hibernate.StaleObjectStateException
PostPosted: Tue Oct 24, 2006 5:27 am 
Newbie

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


Top
 Profile  
 
 Post subject: Forgot to mention that the IDs of all objects are natural
PostPosted: Tue Oct 24, 2006 8:26 am 
Newbie

Joined: Sun Feb 19, 2006 2:46 pm
Posts: 6
So when I get the StaleObjectException I do not know if its because of the keys


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

All times are UTC - 5 hours [ DST ]


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

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