cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR in JDBC adapter...

Former Member
0 Kudos

HI

My call to a stored proc in SQLServer fails with SQL exception

Error processing request in sax parser: Error when executing statement for table/stored proc. 'EmployeeFetch': java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

I understand this error is because call to DB uses SETAUTOCOMMIT false and SelectMethod=should be set to cursor..

But where do i set these methods' for my adapter..Is it in the connections string??

Would appreciate ur help in this..

Regards

Sriram V.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hey thx..

Resolved the pbm..we need to set the method in Connection parameter of adapter config..and it works.. )

jdbc:microsoft:sqlserver://10.201.103.82:1433;DatabaseName=ScottDB;SelectMethod=cursor