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?
Jayakumar said
Dear Vikashazrati,
Can you please tell me where to configure the JTA default timeout value. I am also facing the same problem
vikashazrati said
Hi Jayakumar,
You can goto the weblogic console (http://localhost:7001/console) and once you login goto ->services->JTA. Hope this helps.
Regards | Vikas