Problem with this exception, java.sql.SQLException: Cursor state not valid

[Former Member]

Hello All,

I am getting this problem, java.sql.SQLException: Cursor state not valid.

My scenario is like i am selecting some data from AS400 DB2 with some SQL query. And updating the same data using that. Recently i have shifted to pi7.0 SP 11 to PI 7.0 SP12. Till SP11 we had no issues.

When we have upgraded to SP12 then we got a problem.

We have configured JDBC Sender Adapter which fetches around 3K records with poll interval 1hr from DB2 System.

We donot know why it is happening like this all of a sudden.

Can anyone help me solving this issue as soon as possible.

Thanks,

Soorya

[GabrielSagaya · Accepted solution]

Attempting to update, insert, or delete a row in a JDBC resultset object may result in this type of exception.

Goto Advanced mode ->Transaction Isolation Level-->Select serializable

Number of Retries of Database Transaction On SQL Error: 2

Database Transaction Level: serializable

Activate the checkbox [Database Auto-Commit...]

Activate the checkbox [Disconnect from Database ...]

SYNCHRONOUS SOAP TO JDBC - END TO END WALKTHROUGH

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

Configuring the Sender JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

[former_member859847]

Hi,

Please check the following links, thes will help to solve your problem.

http://www.dbforums.com/archive/index.php/t-926992.html

regards

mahesh.

[Former Member]

Hi Mahesh,

I am not using any Stored Procedures but some simple select statements ans update statements.

Can you please help me in solving this issue.

Thanks,

Soorya