Connection.prepareStatement() problem
You need to alter your URL to set the SelectMethod parameter to 'cursor'.
Check the driver documentation "SQL Server 2000 JDBC User's Guide and
Reference" page 24.
Regards,
David Harbige
Quote:
> Hello,
> When I make a call to Connection.prepareStatement(<string>) I get the
> following exception:
> java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
> cloned connection while in manual transaction mode.
> at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
> Source)
> at
com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown
Quote:
> Source)
> at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown
> Source)
> at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown
> Source)
> ...
> This doesn't seem to happen with other JDBC drivers so I suspect some
> limitiation, but I'm not sure what it may be. This is the 2nd prepared
> statement call made in made code (this first appears to succeed).
> Suggestions?
> Thank you,
> Bob
