[jboss-user] [JCA/JBoss] - connection.setAutoCommit(true) doesn't seems to bubble up th

[dangelo1]

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?



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3976204#3976204

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3976204