I've deployed an MDB in JBoss 3.2.0. The MDB accesses an MS SQL 2000 DB through the JDBC APIs. I have a manual commit transaction block that involves multiple Inserts and Updates. One of the steps is to get back a generated key (IDENTITY) which I presume can be done using @@IDENTITY. My Question is: 1) What happens to the connection if the bean is swapped out when the transaction has not yet been completed? Will a connection that is associated with un-commited data be given to another bean? Will the swapped out bean instance get back the same connection?
If any of have encountered a similar situation, please help!