how to set SelectMethod=cursor; for SQL 2000

[giffy]

Hi Everyone,

I am trying to use the

setAutoCommit(false)

before doing the updates. So that in case of error I can use

rolloverTransaction().

But while trying to do so I am getting this error.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

I am using a datasource to connect to the database. And using connection pool way to do so.

I have appended SelectedMethod in URL as

<parameter>
          <name>url</name>
          <value>jdbc:microsoft:sqlserver://172.15.4.84:1367;DatabaseName=TEstDb;[b]SelectMethod=cursor;[/b]naming=system;prompt=false;block size=64;extended dynamic=true; date format=iso</value>      
      </parameter>

But still the things are not working fine. Hope some body here would help me out. TIA.

[Dököll]

TIA, pal-o-mine!

Please post the whole code, might be easier to help you. Sorry for your troubles though, it must be annoying.

In a bit!