Skip to Content
0
Former Member
May 02, 2005 at 06:51 AM

ERROR in JDBC adapter...

130 Views

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.