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

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
solotaroff
 Post subject: Connection handle, no Managed Connection, and Threading
PostPosted: Fri Sep 23, 2005 9:54 pm 
Newbie

Joined: Fri Sep 23, 2005 9:27 pm
Posts: 3
Hi,

Any help on this one would be greatly appreciated...

We can reproduce this problem every time by stopping two threads right before making the EJB call and restarting them both at basically the same time. My best guess is there's some sort of threading problem in SessionFactoryUtils...but I'm more than open to the possibility of an error on our part.

We're using CMT.

Hibernate version: 3.0.5
Jboss version : 4.0.2
Spring version: 1.2.1


In
beforeMethodCall(), we have
if (mySessionFactory != null) {
// configure shared session by synchronizing txn on hibernate session
// and bind connection
SessionFactoryUtils.getSession(mySessionFactory, true).connection();
}

In the EJB, there's nothing too complicated going on:
List historyList = getSession().getNamedQuery("xxx").setParameterList("id", updateRequestMap.keySet()).list();

for(Iterator it=historyList.iterator(); it.hasNext(); ) {
History history = (History)it.next();

HistoryUpdateRequest request = (HistoryUpdateRequest)updateRequestMap.get(history.getEntityIdentifier().getId());
history.setCleansedUnits(request.getCleansedUnits());
}

getHibernateTemplate().saveOrUpdateAll(historyList);


The stack trace is the same as the others I've seen around, especially the "caused by" at the bottom. Thanks again...

18:50:43,911 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null
18:50:43,911 ERROR [org.hibernate.util.JDBCExceptionReporter] Connection handle is not currently associated with a ManagedConnection
18:50:43,911 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [com.evant.suite.esl.base.model.impl.WeeklyHistoryImpl#1008024]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2000)
at org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1909)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.springframework.orm.hibernate3.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:869)
at org.springframework.orm.hibernate3.SessionFactoryUtils$JtaSessionSynchronization.beforeCompletion(SessionFactoryUtils.java:990)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:741)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:721)
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:202)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:76)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1957)
Top
 Profile  
 
solotaroff
 Post subject:
PostPosted: Mon Sep 26, 2005 8:01 pm 
Newbie

Joined: Fri Sep 23, 2005 9:27 pm
Posts: 3
I increased the logging and it looks like all of the handling of the sessions is proper across the threads. The numbers in the parenthesis (61 or 27) is the thread number. Here are the highlights:
1. Thread 61 opens its hibernate session
2. Thread 27 opens its hibernate session
3. They both do a couple of selects
4. Thread 27 starts its series of updates
5 Thread 61 starts in with its updates, they are intermingled for a while
6. Thread 27 starts finishing up, closes its session
7. Thread 61 continues updating
8. Thread 27 logs "Useless invocation of remove() for stateless session bean"
9. Thread 61 blows up IMMEDIATELY after this statement. This is where it blows up every time.

Is there something shared across threads in these "stateless" session beans? This sounds like an oxymoron, but I'm really running out of ideas here.

One other thing: I've run this on both DB2 and Oracle, so it's not a driver issue.

Thanks in advance for any help!

15:36:43,328 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Opening Hibernate Session
15:36:43,328 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Registering JTA transaction synchronization for new Hibernate Session
15:36:43,328 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Bound value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] to thread [(61)-10.92.101.26]
15:36:43,343 [(61)INFO [com.evant.suite.esl.access.ejb.EjbHistoryServiceBean] Calling EJB method updateWeeklyHistoryWithCleansedDemand using scope suite.esl.
15:36:43,343 [(61)DEBUG [org.springframework.ejb.access.SimpleRemoteStatelessSessionProxyFactoryBean] Trying to create reference to remote EJB
15:36:43,343 [(61)DEBUG [org.springframework.ejb.access.SimpleRemoteStatelessSessionProxyFactoryBean] Obtained reference to remote EJB: evant/suite/foundation/access/ejb/AuthorizationService:Stateless
15:36:43,343 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Opening Hibernate Session
15:36:43,343 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Registering JTA transaction synchronization for new Hibernate Session
15:36:43,343 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Bound value [org.springframework.orm.hibernate3.SessionHolder@e82fb1] for key [org.hibernate.impl.SessionFactoryImpl@ecf6c5] to thread [(61)-10.92.101.26]
15:36:43,343 [(61)INFO [com.evant.suite.foundation.access.ejb.EjbAuthorizationServiceBean] Calling EJB method verifyAuthorized using scope suite.foundation.
15:36:43,343 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@e82fb1] for key [org.hibernate.impl.SessionFactoryImpl@ecf6c5] bound to thread [(61)-10.92.101.26]
15:36:43,343 [(61)DEBUG [org.hibernate.SQL] select configurat0_.CONFIG_SCOPE_ID as col_0_0_ from T_CONFIG_SCOPE configurat0_ where configurat0_.CONFIG_SCOPE_CODE=?
15:36:43,343 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@e82fb1] for key [org.hibernate.impl.SessionFactoryImpl@ecf6c5] bound to thread [(61)-10.92.101.26]
15:36:43,390 [(61)DEBUG [org.hibernate.SQL] select configurat0_.CONFIG_PARM_ID as col_0_0_ from T_CONFIG_PARM configurat0_ where configurat0_.CONFIG_PARM_NAME=?
15:36:43,406 [(61)DEBUG [org.jboss.ejb.StatelessSessionContainer] Useless invocation of remove() for stateless session bean
15:36:43,406 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(61)-10.92.101.26]
15:36:43,421 [(27)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Opening Hibernate Session
15:36:43,421 [(27)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Registering JTA transaction synchronization for new Hibernate Session
15:36:43,421 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Bound value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] to thread [(27)-10.92.101.26]
15:36:43,421 [(27)INFO [com.evant.suite.esl.access.ejb.EjbHistoryServiceBean] Calling EJB method updateWeeklyHistoryWithCleansedDemand using scope suite.esl.
15:36:43,421 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(27)-10.92.101.26]
15:36:43,531 [(61)DEBUG [org.hibernate.SQL] select weeklyhist0_.HISTORY_ID as HISTORY1_, weeklyhist0_.X_LOCK_VERSION as X2_102_, weeklyhist0_.X_CREATE_DATE_TIME as X3_102_, weeklyhist0_.X_CREATE_ACTOR_NAME as X4_102_, weeklyhist0_.HISTORY_TYPE_ID as HISTORY11_102_, weeklyhist0_.HISTORY_CATEGORY_ID as HISTORY12_102_, weeklyhist0_.BUSINESS_DOCUMENT_TYPE_ID as BUSINESS13_102_, weeklyhist0_.BUSINESS_DOCUMENT_KEY as BUSINESS14_102_, weeklyhist0_.BUSINESS_EVENT_NODE_ID as BUSINESS15_102_, weeklyhist0_.MEMO_IND as MEMO16_102_, weeklyhist0_.UNITS as UNITS102_, weeklyhist0_.CLEANSED_UNITS as CLEANSED18_102_, weeklyhist0_.COST as COST102_, weeklyhist0_.RETAIL as RETAIL102_ from T_HISTORY_WEEKLY weeklyhist0_ where weeklyhist0_.HISTORY_ID in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)
15:36:43,531 [(27)DEBUG [org.hibernate.SQL] select weeklyhist0_.HISTORY_ID as HISTORY1_, weeklyhist0_.X_LOCK_VERSION as X2_102_, weeklyhist0_.BUSINESS_DOCUMENT_KEY as BUSINESS14_102_, weeklyhist0_.BUSINESS_EVENT_NODE_ID as BUSINESS15_102_, weeklyhist0_.MEMO_IND as MEMO16_102_, weeklyhist0_.UNITS as UNITS102_, weeklyhist0_.CLEANSED_UNITS as CLEANSED18_102_, weeklyhist0_.COST as COST102_, weeklyhist0_.RETAIL as RETAIL102_ from T_HISTORY_WEEKLY weeklyhist0_ where weeklyhist0_.HISTORY_ID in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)
15:36:44,015 [(27)DEBUG [org.hibernate.SQL] select historycat0_.HISTORY_CATEGORY_TYPE_ID as HISTORY1_0_, historycat0_.X_LOCK_VERSION as X2_95_0_, historycat0_.HISTORY_CATEGORY_TYPE_CODE as HISTORY3_95_0_, historycat0_.HISTORY_CATEGORY_TYPE_NAME as HISTORY4_95_0_ from T_HISTORY_CATEGORY_TYPE historycat0_ where historycat0_.HISTORY_CATEGORY_TYPE_ID=?
15:36:44,218 [(61)DEBUG [org.hibernate.SQL] select historycat0_.HISTORY_CATEGORY_TYPE_ID as HISTORY1_0_, historycat0_.X_LOCK_VERSION as X2_95_0_, historycat0_.HISTORY_CATEGORY_TYPE_CODE as HISTORY3_95_0_, historycat0_.HISTORY_CATEGORY_TYPE_NAME as HISTORY4_95_0_ from T_HISTORY_CATEGORY_TYPE historycat0_ where historycat0_.HISTORY_CATEGORY_TYPE_ID=?
15:36:44,359 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(27)-10.92.101.26]
15:36:44,437 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(27)-10.92.101.26]
15:36:44,437 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(27)-10.92.101.26]
15:36:44,437 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(27)-10.92.101.26]
15:36:44,437 [(27)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Flushing Hibernate Session on transaction synchronization
15:36:44,625 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(61)-10.92.101.26]
15:36:44,640 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,656 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(61)-10.92.101.26]
15:36:44,656 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(61)-10.92.101.26]
15:36:44,656 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] bound to thread [(61)-10.92.101.26]
15:36:44,656 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Flushing Hibernate Session on transaction synchronization
15:36:44,656 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,671 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,703 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,703 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,718 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,734 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,734 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,734 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,750 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,750 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,765 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,765 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,781 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,781 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:44,796 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:46,968 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:46,968 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:46,984 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:46,984 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:46,984 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:46,984 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,000 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,000 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,000 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,000 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,000 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,015 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,015 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,015 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,015 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,015 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,031 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,031 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,031 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,031 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,062 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,062 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,093 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,109 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,109 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,109 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,109 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,109 [(27)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,125 [(27)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Removed value [org.springframework.orm.hibernate3.SessionHolder@22ebbe] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] from thread [(27)-10.92.101.26]
15:36:47,125 [(27)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Closing Hibernate Session
15:36:47,125 [(27)DEBUG [org.hibernate.transaction.CacheSynchronization] transaction before completion callback
15:36:47,125 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,125 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,140 [(27)DEBUG [org.hibernate.transaction.CacheSynchronization] transaction after completion callback, status: 3
15:36:47,140 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,140 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,156 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,156 [(27)DEBUG [org.jboss.ejb.StatelessSessionContainer] Useless invocation of remove() for stateless session bean
15:36:47,156 [(61)DEBUG [org.hibernate.SQL] update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?
15:36:47,171 [(61)DEBUG [org.hibernate.util.JDBCExceptionReporter] could not update: [com.evant.suite.esl.base.model.impl.WeeklyHistoryImpl#1005384] [update T_HISTORY_WEEKLY set X_LOCK_VERSION=?, X_CREATE_DATE_TIME=?, X_CREATE_ACTOR_NAME=?, X_CHANGE_DATE_TIME=?, X_CHANGE_ACTOR_NAME=?, TIME_PERIOD_NODE_ID=?, PRODUCT_NODE_ID=?, LOCATION_NODE_ID=?, VENDOR_ID=?, HISTORY_TYPE_ID=?, HISTORY_CATEGORY_ID=?, BUSINESS_DOCUMENT_TYPE_ID=?, BUSINESS_DOCUMENT_KEY=?, BUSINESS_EVENT_NODE_ID=?, MEMO_IND=?, UNITS=?, CLEANSED_UNITS=?, COST=?, RETAIL=? where HISTORY_ID=? and X_LOCK_VERSION=?]
java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:741)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:721)
at org.jboss.resource.adapter.jdbc.WrappedStatement.checkTransaction(WrappedStatement.java:774)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:313)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1986)
at org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1909)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.springframework.orm.hibernate3.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:869)
at org.springframework.orm.hibernate3.SessionFactoryUtils$JtaSessionSynchronization.beforeCompletion(SessionFactoryUtils.java:990)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
15:36:47,187 [(61)WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: null
15:36:47,187 [(61)ERROR [org.hibernate.util.JDBCExceptionReporter] Connection handle is not currently associated with a ManagedConnection
15:36:47,187 [(61)ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [com.evant.suite.esl.base.model.impl.WeeklyHistoryImpl#1005384]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2000)
at org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1909)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.springframework.orm.hibernate3.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:869)
at org.springframework.orm.hibernate3.SessionFactoryUtils$JtaSessionSynchronization.beforeCompletion(SessionFactoryUtils.java:990)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:741)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:721)
at org.jboss.resource.adapter.jdbc.WrappedStatement.checkTransaction(WrappedStatement.java:774)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:313)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1986)
... 42 more
15:36:47,218 [(61)ERROR [org.springframework.orm.hibernate3.SessionFactoryUtils] beforeCommit callback threw exception
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: could not update: [com.evant.suite.esl.base.model.impl.WeeklyHistoryImpl#1005384]; nested exception is java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:741)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:721)
at org.jboss.resource.adapter.jdbc.WrappedStatement.checkTransaction(WrappedStatement.java:774)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:313)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:1986)
at org.hibernate.persister.entity.BasicEntityPersister.updateOrInsert(BasicEntityPersister.java:1909)
at org.hibernate.persister.entity.BasicEntityPersister.update(BasicEntityPersister.java:2149)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:75)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.springframework.orm.hibernate3.SessionFactoryUtils$SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.java:869)
at org.springframework.orm.hibernate3.SessionFactoryUtils$JtaSessionSynchronization.beforeCompletion(SessionFactoryUtils.java:990)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
15:36:47,218 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Removed value [org.springframework.orm.hibernate3.SessionHolder@1fad4a4] for key [org.hibernate.impl.SessionFactoryImpl@64eb3e] from thread [(61)-10.92.101.26]
15:36:47,218 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Closing Hibernate Session
15:36:47,218 [(61)DEBUG [org.hibernate.util.JDBCExceptionReporter] could not log warnings
java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:741)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:721)
at org.jboss.resource.adapter.jdbc.WrappedConnection.getWarnings(WrappedConnection.java:553)
at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings(JDBCExceptionReporter.java:22)
at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:325)
at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:262)
at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:194)
at org.hibernate.impl.SessionImpl.close(SessionImpl.java:289)
at org.springframework.orm.hibernate3.SessionFactoryUtils.doClose(SessionFactoryUtils.java:775)
at org.springframework.orm.hibernate3.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:764)
at org.springframework.orm.hibernate3.SessionFactoryUtils.access$100(SessionFactoryUtils.java:86)
at org.springframework.orm.hibernate3.SessionFactoryUtils$SpringSessionSynchronization.beforeCompletion(SessionFactoryUtils.java:907)
at org.springframework.orm.hibernate3.SessionFactoryUtils$JtaSessionSynchronization.beforeCompletion(SessionFactoryUtils.java:1005)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
15:36:47,281 [(61)DEBUG [org.hibernate.transaction.CacheSynchronization] transaction before completion callback
15:36:47,281 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Flushing Hibernate Session on transaction synchronization
15:36:47,281 [(61)DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Removed value [org.springframework.orm.hibernate3.SessionHolder@e82fb1] for key [org.hibernate.impl.SessionFactoryImpl@ecf6c5] from thread [(61)-10.92.101.26]
15:36:47,281 [(61)DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Closing Hibernate Session
15:36:47,281 [(61)DEBUG [org.hibernate.transaction.CacheSynchronization] transaction before completion callback
15:36:47,343 [(61)DEBUG [org.hibernate.transaction.CacheSynchronization] transaction after completion callback, status: 4
15:36:47,343 [(61)DEBUG [org.hibernate.transaction.CacheSynchronization] transaction after completion callback, status: 4
15:36:47,343 [(61)ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract void com.evant.suite.esl.access.ejb.EjbHistoryService.updateWeeklyHistoryWithCleansedDemand(java.util.List) throws java.rmi.RemoteException, causedBy:
15:36:47,359 [(61)DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
15:36:47,359 [(61)DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
15:36:47,359 [(61)DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=jsolotar-pc/854, BranchQual=, localId=854] status=STATUS_NO_TRANSACTION
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:486)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:346)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:139)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
at sun.reflect.GeneratedMethodAccessor257.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
15:36:47,515 [(27)DEBUG [org.jboss.ejb.StatelessSessionContainer] Useless invocation of remove() for stateless session bean
Top
 Profile  
 
solotaroff
 Post subject: More info on jboss forum
PostPosted: Mon Sep 26, 2005 8:51 pm 
Newbie

Joined: Fri Sep 23, 2005 9:27 pm
Posts: 3
This actually looks more like a jboss problem. If anyone else is seeing it, there's more info on their forum.

http://www.jboss.org/index.html?module= ... ic&t=24464
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

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

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