A problem when connect MSSQL with transaction.

Problem:could not load object: [Microsoft][sqlserver Driver for Jdbc]can ' t start a cloned connection while in manual Transaction mode. ===============================================

Solve:

If you pass the "Selectmethod=cursor" attribute in Connectio URL, would allow more than one active statement per connection. "J dbc:microsoft:sqlserver://localhost:1433; Selectmethod=cursor; "," User "," pwd "The reason for this is; When SelectMethod are set to direct, SQL Server does not support multiple active statements on a single connection within a Transaction However, when Auto-commit mode are 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 doing by cloning physical SQL Server connections as needed. To avoid cloning physical SQL Server connections at this circumstance, you are should create only one Statement, preparedstate ment, CallableStatement, or DatabaseMetaData object per JDBC Connection object. Being sure to invoke the ' close ' methods on this objects when you are are finished with them, which is, before creating, another O Bject of the types described.