java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a clone
Joined: Dec 26, 2002
I am using Microsoft SQL Server JDBC driver, Also I am using connection pooling. 50% of the time its working fine but sometimes it gives the following error: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. or java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a manual transaction because connections are cloned. I am using multiple statements per connection, but only select statements. If anybody is aware of this problem,Please cooperate. Sonika
Joined: Dec 12, 2001
I have seen this error, and I think it had something to do with the connection having been closed.
Joined: Aug 03, 2002
Hi Sonika, This is a problem which occurs when ure using manual connection commit i mean autocommit(false) and this can be prevented when u write selectMethod='cursor' and this is there because u are using multiple statement objects with a single connection object thanx & regards, Rahul Juneja firstname.lastname@example.org