Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
PRB: Cannot Start a Cloned Connection While in Manual Transaction Mode
Article ID: 313181 - View products that this article applies to.
This article was previously published under Q313181
While using the Microsoft SQL Server 2000 Driver for JDBC, you may experience the following exception:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
This error occurs when you try to execute multiple statements against a SQL Server database with the JDBC driver while in manual transaction mode (AutoCommit=false) and while using the direct (SelectMethod=direct) mode. Direct mode is the default mode for the driver.
When you use manual transaction mode, you must set the SelectMethod property of the driver to Cursor, or make sure that you use only one active statement on each connection as specified in the "More Information" section of this article.
Steps to Reproduce the BehaviorUse the following code to reproduce the error:
NOTE: See the comments in the code for information on the code changes that are required to resolve the problem.
For more information about Cloned Connections, see the Connection String Properties section of the Microsoft SQL Server 2000 Driver for JDBC HTML Help or the Online Guide.For additional information about cloned connections with the driver, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/313220/EN-US/ )PRB: Unexpected Connections to SQL Server with JDBC
Article ID: 313181 - Last Review: June 30, 2003 - Revision: 2.0