Check your code:
First you'll have to close all resultsets, then all statements(, and than
your connection).
All these objects create cursors and keeps those cursors open!!! Increasing
your open_cursors in oracle won't help!
-Yves
-----Oorspronkelijk bericht-----
Van: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]Namens
Sayantan Sen
Verzonden: dinsdag 1 augustus 2000 18:32
Aan: [EMAIL PROTECTED]
Onderwerp: JDBC error
dear friends
i'v written a servlet in which in the init() method i'm creating a JDBC
connection to a oracle (8.0.3.0 personal) database using thin driver. i'm
accessing the database using the opened connection ( in init()), depending
upon user request in the doPost() method. the problem is after handling
exactly 50 request, servlet throws an error message. the message is "ORA
01000: maximum open cursors exceeded. after this it stops working. if i
restart the server, it again works. pls tell me how to get rid of this
problem.
thanks
sayantan
___________________________________________________________________________
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
___________________________________________________________________________
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
