|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
Problem: Could not load object: [Microsoft][SQLServer 2000 Driver for JDBC]Can\\\'t start a cloned connection while in manual transaction mode. =============================================== Solve: If you pass "SelectMethod=cursor" attribute in connectio url, will allow more than one active statement per connection." jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;","user","pwd"The reason for this is;When SelectMethod is set to direct, SQL Server does not support multiple active statements on a single connection within a transaction; however, when auto-commit mode is enabled (the default), the Microsoft SQL Server JDBC driver provides the ability to have multiple JDBC statements open on a single JDBC connection. This is done by cloning physical SQL Server connections as needed. To avoid cloning physical SQL Server connections in this circumstance, you should create only one Statement, PreparedStatement, CallableStatement, or DatabaseMetaData object per JDBC Connection object. Be sure to invoke the "close" methods on these objects when you are finished with them, that is, before creating another object of the types described. 返回类别: 教程 上一教程: JAIN API Specifications 下一教程: JAVA程序员面试32问 您可以阅读与"A problem when connect MSSQL with transaction."相关的教程: · 使用validwhen设计复杂的Struts表单验证 · TOMCAT5+MSSQL SERVER 2000数据库连接池配置之旅 · dbUnit对mssqlserver自增长主键的处理 · 如何用JDBC实现通过APPLET连MSSQL · jsp+tomcat+mssql系统的配置 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |