hi;
Taken from technet.oracle.com JDBC FAQ: (free registration required)
http://technet.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_47_
Error Message: "ORA-01000: maximum open cursors exceeded"
The number of cursors one client can open at a time on a connection is
limited (50 is the default value). You do need to explicitly close the
statement, by using the method stmt.close() in order to close and freeup
the cursors.
If you dont close these cursors explicitly, you will get this error
eventually. Simply increasing the "OPEN_CURSORS" limit can help you avoid
the problem for a while, but that just hides the problem, not solve it. It
is your responsibilty to explicitly close out cursors that you no longer need.
take care
John.
=====
At 04:29 PM 05/16/2000 , Vdaygiri, Subu wrote:
To all Oracle & J2EE gurus,
I have using Oracle as database connection for the J2EE server(with Oracle's
JDBC thin driver - classes12.zip). I am getting these two errors -
- ORA-01000: maximum open cursors exceeded
and sometimes
- exceeding the number of processes allowed i.e 50.
Yes, I could change the OPEN CURSORS or increase the number of processes for
Oracle. But I am the only person running applications of this server (hence
it can't be THAT overloaded). I was wondering if the J2EE server is
releasing the Oracle resources like cursors, etc properly or is there
something in configuration that I can do to prevent the above two errors.
Thanks a lot for the help !!
Subu
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
