Several things come to mind.
If you're not reusing the connection, and failing to close old ones, then
you'll run into problems.
If you're not closing the Statements that you are using, these will hold
open cursor handles (and max out). If you are running vastly complex SQL
and PL/SQL routines, you'll max out (CASE for instances requires a coupld of
hundred cursors).
Lastly, upgrade your database. That version is not supported for y2k along
with other issues. And get the 8.1.6 JDBC drivers, as they have many bug
fixes (some of which are the driver itself not closing statements, timing
out too early, max data throughput, etc.)
Thor HW
----- Original Message -----
From: "Sayantan Sen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 01, 2000 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
