Yes - I had this problem when I was not closing connections and result
sets properly.
Rhys Lewis
-----Original Message-----
From: shaoming [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 22, 1999 2:44 PM
Subject: JDBC & Oracle - max. open cursors exceeded
Hi!
I'm writing a servlet which, using JDBC, connect to a Oracle 8 DB
(NT platform) to insert, update and delete records.
It works fine for a while. After long usage or multiple user access,
the error
"SQLException - ORA-01000: maximum open cursors exceeded"
is shown.
Anyone has this same problem? Please help.
Thanks,
/shaoming
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
