QuickTip: Weblogic: JDBC: java.sql.SQLException: Transaction timed out after 33 seconds

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?