javax. transaction. UserTransaction - reuse

[Babji Reddy]

Hi,

UserTransaction usrTxn = (UserTransaction)initialCtx.lookup("java:comp/UserTransaction");
 
userTxn.begin();
//obtain pooled connection from datasource
// execute JDBC
// close connection//
userTxn.commit().
 
[B]Now If want to execute another JDBC statement, can I just reuse the earlier 
userTxn.begin().... execute .... commit OR
I have to create the transaction again using
usrTxn = (UserTransaction)initialCtx.lookup("java:comp/UserTransaction");
before using userTxn.begin() ?
[/B]
 

Thanks

[Padma Lalwani]

I am thinking starting with begin() should be good enough, because that is the logical boundary for a new transaction

[Babji Reddy]

Thanks. Now extending the earlier case, if the second JDBC execution is on a different database, Now still is one

   usrTxn = (UserTransaction)initialCtx.lookup("java:comp/UserTransaction");
 

sufficient or I have to create it again for 2nd database operation.