Sql Server2000 Can't start a cloned connection while in manual transaction mode
来源:互联网 发布:mac按什么键切换系统 编辑:程序博客网 时间:2024/05/23 19:14
Sql Server2000设置事务时
conn.setAutoCommit(false);
//执行语句sql1,sql2
conn.commit();
结果出现Can't start a cloned connection while in manual transaction mode错误,从网上找到原因及解决办法如下:
原因一般是当你在一个SQL SERVER的JDBC连接上执行多个STATEMENTS的操作,或者是手动事务状态(AutoCommit=false) 并且使用默认的模式. direct (SelectMethod=direct) 模式.
解决办法
当你使用手动事务模式时,必须把SelectMethod 属性的值设置为 Cursor, 或者是确保在你的连接只有一个STATEMENT操作。
修改JDBC URL,加入SelectMethod=cursor即可:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;SelectMethod=Cursor;User=User;Password=Password
微软提供详细原因如下:
SYMPTOMSWhile 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. 500)this.width=500" border="0"> CAUSEThis 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. 500)this.width=500" border="0"> RESOLUTIONWhen 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. STATUSThis behavior is by design. MORE INFORMATIONSteps 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.import java.sql.*;
- Sql Server2000 Can't start a cloned connection while in manual transaction mode
- sql server 出现Can't start a cloned connection while in manual transaction mode 的解决方法
- [Microsoft][SQLServer JDBC Driver]Can't start a cloned connection while in manual transaction mode
- Can't start a cloned connection while in manual transaction mode
- Can't start a cloned connection while in manual transaction mode的解决方法
- jsp Can't start a cloned connection while in manual transaction mode解决
- Can't start a cloned connection while in manual transaction mode.
- Can't start a cloned connection while in manual transaction mode.解决方法
- Can't start a cloned connection while in manual transaction mode.错误的解决方案
- Can't start a cloned connection while in manual transaction mode
- Can't start a cloned connection while in manual transaction mode
- Can't start a cloned connection while in manual transaction mode 解决
- iBatis使用SQLServer出现Can't start a cloned connection while in manual transaction mode.错误
- PRB: Cannot Start a Cloned Connection While in Manual Transaction Mode
- cloned connection do`t in manual transaction
- JDBC连SQL SERVER数据库常见问题Can't start a cloned connection while(转载)
- sqlserver2000 Can't start manual transaction mode because there are cloned connections
- SQL Server 解决Can't start manual transaction mode问题
- sql语句获取wordpress的分类
- Linux创建进程fork和vfork函数分析
- 跑出一片天
- Problem H
- Spring事务配置详解
- Sql Server2000 Can't start a cloned connection while in manual transaction mode
- 详解磁盘分区表
- openstack之简介篇
- 在smarty中调用php内置函数的方法
- 【转】select+TCP/IP 实例片段(供参考)
- 黑马程序员-JavaBean
- Spring JPA 配置
- 【个人记录】u-boot 内核和文件系统在FL2440上的烧写
- 杭电2000