Hi,
Gotta close all your JDBC resources!
ResultSet.close();
(Prepared)Statement.close();
Connection.close();
The error you see eminates from not closing ResultSets, I believe... but in
general, put all 3 closures in a finally block and you have less worries!
Gene
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java
Servlet API Technology.
To: [EMAIL PROTECTED]
Sent: 8/1/00 9:31 AM
Subject: 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
