ORA-01000 error even if all statements and resultsets are closed in finally

Tags:
Database
IBM DB2
Java
Microsoft Windows
Oracle
Software
SQL
I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON and 'Enable Closing cursors' is OFF Please suggest how to solve is issue. It's very urget.

Answer Wiki

Thanks. We'll let you know when a new response is added.

We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON
and ‘Enable Closing cursors’ is OFF

maybe you should first try ‘Enable Closing cursors’ ON

Are you using bind variables?
that would help a lot

Also is the latest 8.1.7 patch installed, I remember having this problem a long time ago and it was fixed by both a patch and a little change of code using bind variables and avoiding opening cursor in the loop of another cursor …. garbage collection can take some time to destroy the cursors or recordsets in the inner loop

hope that helps a bit
have a good day and a happy new year

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DeveloperJava
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/ora-01000-error-even-if-all-statements-and-resul... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following