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?

QuickTip: Setting CLASSPATH on linux

For bash shell:
vhazrati@vhazrati-laptop:~$ export CLASSPATH=$CLASSPATH:/home/vhazrati/bea815/weblogic81/server/lib/weblogic.jar:/home/vhazrati/xebiaprojects/jmsconsole/trunk/target/javax.jms-1.1.jar

For tcsh or csh:
set CLASSPATH = ($CLASSPATH /home/vhazrati/bea815/weblogic81/server/lib/weblogic.jar)

To test

vhazrati@vhazrati-laptop:~$ echo $CLASSPATH

Alternatively you can add the following to your .bashrc

export CLASSPATH=.:/home/vhazrati/bea815/weblogic81/server/lib/weblogic.jar: