1 Reply Latest reply on Jan 22, 2004 7:54 AM by Daniel Murygin

    MSSQL connection with auto commit false problem

    tsangcn Newbie

       

      "tsangcn" wrote:
      Hello,

      I am using JBoss 3.2.1 with MSSQL jdbc driver (using local tx).
      If I get a connection from JBoss connection pool with auto commit = true, it is OK.
      But If I set auto commit to false, I get the following exception at Statement.executeUpdate()

      [Microsoft][SQLServer 2000 Driver for JDBC]Can't start manual transaction mode because there are cloned connections.

      If I do not use connection pool, i.e. I get the connection using Class.forName(), and set auto commit to false, it is OK.

      Why I get the exception when I use JBoss connection pool with auto commit false?
      Can anyone help me?

      Thanks
      CN