0 Replies Latest reply on Oct 14, 2003 3:50 AM by deepak.j

    Beans and DB Connection

    deepak.j Newbie

      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!