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
