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?
you have to add one more parameter to your connection url:SelectMethod=cursor
the url with the new parameter:jdbc:microsoft:sqlserver://server:1433;databaseName=name;SelectMethod=cursor