Best viewed in 1024 X 800 resolution... Leave a comment if u like an article...
Google
 
Web tezcols.blogspot.com

Saturday, June 30, 2007

Can't start a cloned connection while in manual transaction mode

While using the Microsoft SQL Server 2000 Driver for JDBC, you may experience the following exception when you try to create multiple Statement objects with same Connection object:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

Add
SelectMethod=Cursor; in the connection string. Thats it..... Let me know if this helped u...

2 Comments:

Anonymous Anonymous said...

Good Stuff... Keep it updated..

11:42 AM  
Blogger billyptx said...

Exactly what I needed.

1:46 AM  

Post a Comment

<< Home