QuickTip: Weblogic: JDBC: java.sql.SQLException: Transaction timed out after 33 seconds
Posted by vikashazrati on Saturday, August 11, 2007
java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 33 seconds
I was working on an application using Weblogic 8.1 sp5, and Oracle 10g. A batch process involving 10K records, which were being picked up from a JMS Queue and post processing being populated into the database, was failing with the above error.
Since I was using the Weblogic transactions hence I increased the JTA default timeout from 30s to 120s and I stopped getting that error.
Do you have any other solutions for the above scenario?
Friday, January 4, 2008 at 5:29 pm
Dear Vikashazrati,
Can you please tell me where to configure the JTA default timeout value. I am also facing the same problem
Friday, January 4, 2008 at 11:35 pm
Hi Jayakumar,
You can goto the weblogic console (http://localhost:7001/console) and once you login goto ->services->JTA. Hope this helps.
Regards | Vikas