Problem in sender JDBC adapter

hello,

I am facing one typical problem in sender JDBC adapter.

Here is the issue,

JDBC API method getString threw an exception: java.sql.SQLException: Cursor state not valid.

Can anyone please help me out in solving this problem?

Actually after a retry of 3 times the message has been successfully sent. Till then i am getting these error

On 1st attempt ,

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

On 2nd attempt,

Error during conversion of query result to XML java.sql.SQLException: Internal driver error

(class.java.lang.InterruptedException)

On 3rd attempt,

Processing finished successfully.

This is the scenario that i can see in the audit log.

Can you please help me out in solving this issue.

Thanks,

Soorya