I am using JBoss 3.0.7 and Progress DB. We use programmatic transaction mgmt. using JTA. I have a query regarding closing connection during a Transaction. We initiated a Transaction using userTran.start() and do some db operations using another framework and in the end call userTran.commit(). Suppose we need to execute 3 db operations in between start() and commit(). This framework will obtain connection for 'each' db operation using getConnection() and after the execution of the query, it says connection.close(). Does anybody know whether the closing of connection create any problem while inside the boundary of a Transaction..? The app seems to work fine, but we suspect some intermittent errors from DB side is related to this or not...
Thanx in advance
I've just been reading around in EJB-Spec 2.0 Final Release, where there are a couple of examples. I think that the text and the example on page 347 answers your question precisely.