Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Cursor exception

843859Jul 5 2007 — edited Jul 5 2007

Hi Guys,

My application is throwing 'invalid cursor exception' when it does DB operations. Because of this, application is not able to fetch any data from the table. I thought this may be because of maximum cursors set in the DB will be less for the application and doubled it(to 300) then the application worked fine for some days but again started showing the same exception. Currently the workaround is to restart the DB and the web server.

Is it because the application is not releasing the cursors or something like that? If so what code fix can be done to solve this.

Or

Is it an issue with DB side?

Can anybody advice me how to resolve this issue permanently?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2007

Added on Jul 5 2007

#java-database-connectivity-jdbc

4 comments

2,784 views