I have a
thread running in one transaction. this transaction creates many child transactions(running on requiresNew.. about(8)).Once the child transactions are committed, and when the main transaction is reached, we get a java.rmi.RemoteException: BEA1-6ABE41DE2592116A15E2; nested exception is:
javax.transaction.SystemException: Timeout during commit processing
at weblogic.ejb.container.internal.EJBRuntimeUtils.throwRemoteException(EJBRuntimeUtils.java:95)
at weblogic.ejb.container.internal.BaseEJBObject.postInvoke1(BaseEJBObject.java:587)
at weblogic.ejb.container.internal.StatelessEJBObject.postInvoke1(StatelessEJBObject.java:72)
at weblogic.ejb.container.internal.BaseEJBObject.postInvokeTxRetry(BaseEJBObject.java:381) ..
The main transaction only gets a next val of a sequence. We are running on an XA driver with weblogic server 9. There are only select queries in the main transactions.
The process takes about 10 minutes. JTA transaction time out is at 4 hrs
The following are my weblogic configuration for
JDBC transaction is as follow:
Set XA Transaction Timeout :true
XA Transaction Timeout:0
XA Retry Duration::300
XA Retry Interval:60
Keep XA Connection Until Transaction Complete:true
Need Transaction Context On Close:true
XA End Only Once:true
Keep Connection Open On Release::true
Please do help... Thanks in advance..