MSSQL connection with auto commit false problem

tsangcn Jul 21, 2003 6:43 AM

"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

1. Re: MSSQL connection with auto commit false problem

n2 Jan 22, 2004 7:54 AM (in response to tsangcn)
"n2" wrote:
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
Actions