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..