A question about use of userTransaction and Connections

[raminaa niilian]

Hi
Thank you for reading my post
can some one please help me understand a scenario like this:

con1.setAutoCommit(false)
con2.setAutoCommit(false)

{
utx.begin()
.....
....
con1.commit();
con2.commit();


utx.rollback();

I need to rollback even commited connections if my utx rolled back, is it doable?

thanks

[Nitesh Kant]

When you are using a user transaction, then you should not call commit/rollback on individual resources.
You should only call commit/rollback on the user transaction object.