connection.commit() in a javax.transaction.UserTransaction
Hi
Is it possible to do a connection.commit() when the connnection is participating in a transaction.
I have a scenario wherein I am using different connection objects to insert data in different tables . Before inserting I am creating a UserTransaction which i am committing after successful insertion in all the tables. If any insertion fails I am rolling back the entire transaction .
In one connection to a particular table I am inserting CLOB data for which I have to set connection.setAutoCommit(false). After the insertion I am doing connection.commit().
This approach works on SunOneWebServer but it fails on JRunApplication Server . I am getting this error
Cannot commit, Connection is participating in a transaction when i try to do a connection.commit()
Please help. Thanks in advance
