Hi,

We are currently upgrading from WLS 10.3.4 -> WLS 12.1. We are using Hibernate on app server and updating a table with a clob.

While transaction's execution we have observed the session.flush() is taking around 600 seconds to execute and leading to transaction time outs.

We tried checking the AWR reports but no query seems to be taking high time.

Also we tried to set the XA Datasource transaction timeout set to 0, but it does not helps anyways.

Below is the code snippet:

@Transactional(propagation = Propagation.REQUIRES_NEW)
public void update(MessageContext ctxObject) {

Session session = null;
try {

session = getSession();

session.update(ctxObject);

session.flush();

} finally {
releaseSession(session);
}
}

Below is the stack trace:

2015-01-07 12:04:08,071 ERROR [133544926591943211] BatchingBatch - HHH000315: Exception executing batch [could not perform addBatch]
2015-01-07 12:04:08,080 WARN [133544926591943211] com::idisServer1 - Wwallowing throwable ... may be due to timeout at the time of isEligibleForRetry
org.hibernate.QueryTimeoutException: could not perform addBatch
at org.hibernate.dialect.Oracle8iDialect$2.convert(Oracle8iDialect.java:462)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:114)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101)
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:149)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:372)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:287)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1234)
at com.att.idis.framework.messaging.dao.hibernate.MessageCtxDaoImpl.update(MessageCtxDaoImpl.java:99)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy252.update(Unknown Source)
at com.att.idis.framework.messaging.sfa.SfaResponseHandler.saveResponseMessage(SfaResponseHandler.java:188)
at com.att.idis.framework.messaging.sfa.SfaResponseHandler.sendResponseMessage(SfaResponseHandler.java:166)
at com.att.idis.framework.messaging.sfa.SfaResponseHandler.handleMessage(SfaResponseHandler.java:110)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy273.handleMessage(Unknown Source)
at com.att.idis.framework.messaging.sfa.SfaEventHandler.invokeDelegate(SfaEventHandler.java:60)
at com.att.idis.framework.messaging.sfa.SfaEventHandler.onComplete(SfaEventHandler.java:41)
at com.cramer.mrsadapter.controller.ejb.OrderStateProcessor.handleOrderCompletion(OrderStateProcessor.java:466)
at com.cramer.mrsadapter.controller.ejb.OrderStateProcessor.processOperations(OrderStateProcessor.java:728)
at com.cramer.mrsadapter.controller.ejb.NewStateProcessor.processOrderStateOperations(NewStateProcessor.java:24)
at com.cramer.mrsadapter.controller.ejb.OrderStateProcessor.process(OrderStateProcessor.java:117)
at com.cramer.mrsadapter.controller.ejb.OrderStateProcessor.processRequest(OrderStateProcessor.java:95)
at com.cramer.mrsadapter.controller.ejb.ControllerBean.process(ControllerBean.java:176)
at com.cramer.mrsadapter.controller.ejb.Controller_gcdgjm_ELOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
at com.cramer.mrsadapter.controller.ejb.Controller_gcdgjm_ELOImpl.process(Unknown Source)
at com.cramer.mrsadapter.ejb.RequestOrderProcessor.processOrder(RequestOrderProcessor.java:147)
at com.cramer.mrsadapter.ejb.ProvideRequestOrderProcessor.processOrder(ProvideRequestOrderProcessor.java:142)
at com.cramer.mrsadapter.ejb.ProvideRequestOrderProcessor.handleAsyncRequest(ProvideRequestOrderProcessor.java:81)
at com.cramer.mrsadapter.ejb.RequestOrderProcessor.handleRequest(RequestOrderProcessor.java:95)
at com.cramer.mrsadapter.ejb.ProvideRequestOrderProcessor.processRequestOrder(ProvideRequestOrderProcessor.java:65)
at com.cramer.mrsadapter.ejb.RequestOrderProcessor.processRequest(RequestOrderProcessor.java:65)
at com.cramer.mrsadapter.ejb.RequestProcessorPojo.processRequest(RequestProcessorPojo.java:59)
at com.cramer.mrsadapter.ejb.RequestProcessorPojo.processRequest(RequestProcessorPojo.java:31)
at com.cramer.mrsadapter.ejb.RequestProcessorBean.processRequest(RequestProcessorBean.java:46)
at com.cramer.mrsadapter.ejb.RequestProcessor_7e9tlc_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:32)
at com.cramer.mrsadapter.ejb.RequestProcessor_7e9tlc_EOImpl.processRequest(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)