Manual commit in MS SQL 2000 JDBC

Java Forums - Cloned connection: "You need to use the property 'SelectMethod' for the driver in the URL and set it to 'cursor'

So your driver url should be like :

'jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor'"