JDBC Adapter - Stored Procedure Error

[Former Member]

Hi,

I am executing a stored procedure in SQL Server with JDBC Adapter. I get the bellow problem from Adapter engine.

2006-04-28 13:36:57 Error Unable to execute statement for table or stored procedure. 'sp_CustomerProc' (Structure 'Statement') due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

2006-04-28 13:36:57 Error Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_CustomerProc' (structure 'Statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

2006-04-28 13:36:57 Error Delivery of the message to the application using connection AFW failed, due to: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_CustomerProc' (structure 'Statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode..

2006-04-28 13:36:57 Success The message status set to WAIT.

Please advice.

Thanks,

Sri.

[Former Member]

Hi Sri,

Please can you go through this thread

Speaks about the same issue and it got resolved!!

Regards

Vijaya