Increasing MAX_CURSOR-SIZE will not alone help you. If u r initially
getting the error for abt 50 hits, after increasing MAX_CURSOR_SIZE you will
get the error for every 100 hits. Make sure that every opened
ResultSet/Statement are closed properly. I am pretty sure that you will get
another error like maximum number of processes exceeded, if you leave your
code like that. Have a code walk through and make sure that everything is
fine.
Cheers,
Vinod
[EMAIL PROTECTED]
-----Original Message-----
From: Murphy, Chris (OTS-EDH) [mailto:[EMAIL PROTECTED]]
Sent: 5 October 2000 4:00
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
