Hi Sayantan,
50 is the default no of cursors that Oracle Server Allows. If
you want to increase it then u have to modify init.ora file of Oracle.
Hope this Helps.
Bye,
Jiger
>From: Sayantan Sen <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: JDBC error
>Date: Tue, 1 Aug 2000 09:31:52 -0700
>
>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
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
___________________________________________________________________________
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
