Error in getting connection !!

[db2sachin]

Could u help me in the follwing problem ?
We are mentioning the database URL as followes. Here the problem is if we don't specify the SelectMethod=cursor clause in the URL it gives some error (pasted below). Can we avoide that error without using the SelectMethod clause ?

- <database>
<user>appngph</user>
<password>vorfa</password>
<url>jdbc:microsoft:sqlserver://169.102.33.204:1433;SelectMethod=cursor;databasename=NGPH</url>
<dbdriver>com.microsoft.jdbc.sqlserver.SQLServerDriver</dbdriver>
<minpool>3</minpool>
<maxpool>6</maxpool>
<maxconn>6</maxconn>
</database>

but we are getting following error

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start manual transaction mode because there are cloned connections.

 

[NoCoolHandle]

I think you need to send this to a JDBC newsgroup.. this is not a SQL issue that I am aware of.

Always a good suggestion, have you downloaded the latest drivers....
It could be that the JDBC Folks have found and solved it..

My (Cynical/smart a%^@) suggestion. change to .Net it is faster (more pages per second and better access to SQL server also -- not to mention great support to BLOBS etc...)