1 Reply Latest reply on Oct 4, 2006 11:06 PM by Weston Price

    connection.setAutoCommit(true) doesn't seems to bubble up th

    Dennis Angelo Newbie

      I have a no-tx-datasource in JBOSS 4.0.4 and I do the following:

      DataSource datasource = (DataSource) context.lookup("noTxDatasource")
      Connection connection = null;
      try{
      datasource.getConnection();
      connection.setAutoCommit(false)
      //do some stuff with connection

      connection.commit();
      }
      finally{
      if(connection != null){
      try{
      connection.setAutoCommit(true);
      connection.close()
      }
      catch(SqlException e){
      //log warning
      }

      }
      }



      The reason I'm calling the setAutoCommit(true) in the connection just before closing (or returning it to the pool) is that the Inet driver that I'm using seems to be opening a transaction after closing the connection (if autocommit is set to false). I inferred this because I debugged through the code and obtained a connection from DriverManager and inspected the autocommit flag and the open transactions in the database and after commit there is indeed a new transaction, but as soon as I have set AutoCommit back to true is closes the transaction.

      But my problem is doing this through JBOSS doesn't seem to work. I tried to set the AutoCommit back to true but looking at the database is still seems to appear the calling setAutoCommit(true) doesn't do anything because I still have an open transaction in the database.

      Can anyone help?