thanx to everyone who suggested the solution.i was able to
solve the problem.FYI, it was because of some place i haven't
close the statement after the sql operation.
thanx again ....
with regards,
rathna.
Tai wrote:
> Try:
>
> 1. after executing SQL statement and use the result set. Remember that drop
> the statement and result set to close the cursor :
>
> stmt.close();
> resultset.close();
>
> 2. Increase max_cursors parameter in config.ora
>
> On Wed, 4 Oct 2000 18:38:25 +0530, A mailing list about Java Server Pages
> specification and
> reference wrote:
>
> > 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
>
> _______________________________________________________
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
===========================================================================
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
