error processing JDBC (using BPM)

[Former Member]

hi

i'm working on this scenario: a stored procedure is executed in sender JDBC and the result goes to another JDBC and the output of of the second jdbc goes to the target as file.

while executing the interface, theJDBC sender is working properly.Howver the 2nd JDBC shows the following error-> Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Sp_SelectName' (structure 'STATEMENTNAME'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

i tried searchign for solution to this problem.I went through the followign link->

however the answers were not satisfactory.

Please help.

[former_member200962 · Accepted solution]

Hi,

Below two links have solution to your problem:

http://www.mail-archive.com/struts-user<<at-rate>>jakarta.apache.org/msg21641.html

In the above link use @ instead of <<at-rate>>

http://support.microsoft.com/kb/313181

Regards,

Abhishek.

[Former Member · Accepted solution]

Hi abhishek , Joel

well thanks to both of u..i was able to implement it successfully.SelectMethod= cursor did the job:)

Tarang, thanks for your input too.What you told was interesting and may help me in future.

[former_member206760]

Hi,

are u using any stored procedure in the receiver communication channel of the sencond table..

if you are using only the target data type and then selecting the data from 2nd table...chk taht target data type is ok,..

also if you are not using SP on the receiver channel ...uselogSQLStatement

into advanced jdbc parameters in your channel

and then inside the log you will find the whole SQL statement

that is being executed in the DB....use taht and manually query the database

[JoelTrinidade]

Hi Itisha,

Yours is a complicated problem. please note that you have to use Before connection.setAutoCommit(true),

have you done connection.commit() or connection.rollback() ?. See what happens ...

Also you need to use the property 'SelectMethod' for the driver in the URL and set it to 'cursor'

So your driver url should be like :

"jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor"

Regards

joel

Edited by: joel trinidade on Mar 10, 2009 10:16 AM