1 Reply Latest reply on Aug 19, 2003 2:03 AM by Nicolas Regez

    will connection.close() create problem while in a Transactio

    renjith Newbie

      Hi,
      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
      ~renjithkurian