....and close your resultsets/statements/preparedStatements.
There is only so much DBA can increase MAX_CURSOR_SIZE to :-)
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Murphy, Chris (OTS-EDH)
> Sent: Wednesday, October 04, 2000 2:00 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Help Needed - Max cursor exceeded Exception
>
>
> I have seen this on Oracle 7.x databases. In my case, the dba needed to
> increase the MAX_CURSOR_SIZE (or something like it, I can't remember the
> exact one) attribute on my database and I was good to go.
>
> -murph
>
> -----Original Message-----
> From: Rathna [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 04, 2000 6:08 AM
> To: [EMAIL PROTECTED]
> Subject: Help Needed - Max cursor exceeded Exception
>
>
> hi all,
>
> This is a bit off topic but i am sure someone in the list would thru
> light on this.
>
> we are developing a internet based application which works fine but when
>
> we keep accessing for some time, at some point in sql query it throws
> "max number of cursors exceeded" , then after wards it stops responding
> for all the database operation.i sure we are closing all the statements
> after
> each execution of query also we have set the maximum cursor as 250.
>
> when would the opened cursor will reach the max limit?
>
> FYI,we are using connection pooling mechanision to maintion the
> connection.
>
> env: Jrun,apache,oracle8.1.6 on NT.
>
> thanx in advance ...
>
> --
> with regards,
> rathna
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
