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
