Skip to Content
0
Former Member
May 09, 2008 at 12:34 PM

JDBC Sender Adapter : java.sql.SQLException: Cursor state not valid.

843 Views

Hello all,

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

It was working fine,suddenly it started throwing an exception in Adapter Monitoring :

Error during conversion of query result to XML: java.sql.SQLException: Cursor state not valid.

It is not fetching any records.

Without changing any configurations when we tried to fetch to around 1000 records it's working fine.

For 10K records same exception persists

What could be the reason ?How to resolve this issue?

regards

GangaPrasad