YOU can use this query (ORACLE) to see how many cursors are open.
Query : "SELECT value FROM v$sysstat WHERE name = 'opened cursors current'";
This would help you to see which part of you code is leaving the cursors
open..
----------------
Kishore Raghavan
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Philip Doyle
Sent: Wednesday, June 28, 2000 3:14 PM
To: [EMAIL PROTECTED]
Subject: Re: off topic - maximum open cursors exceeded
Hi
this error is common for folks who use connection pooling - as Oracle
creates a session for each connection and will accumulate cursors associated
with each open connection in the pool throughout the connections life.
Therefore one should set the max uses for each connection in the pool and
recreate them to release the Oracle resources associated with them.
Also, one can have ones DBA increase the max open cursors setting for the
database which is in $ORACLE_HOME/dbs/init<dn_name>.ora as far as I
remember.
regards
Phil
----- Original Message -----
From: Mark Hills <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 28, 2000 11:41 PM
Subject: Re: off topic - maximum open cursors exceeded
> You should just be able to use the Connection's close() method when you're
> done with it (done processing the page, for instance). You will want to
look
> into connection pooling to cut down on the time it takes to open and close
> connections on a page. I think Oracle has some info up on their website
> about this, and I know WebLogic provides connection pooling as a "service"
> of the WebLogic server, so I'm assuming other servers may do this as well.
>
> -----Original Message-----
> From: anderson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 28, 2000 4:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: off topic - maximum open cursors exceeded
>
>
> Thank you so much... And the Connection, how can I close it when the
session
> ends ?
>
> []s
>
> Mark Hills wrote:
>
> > Make sure you close any database objects that you aren't using anymore,
> like
> > ResultSet, CallableStatement, and PreparedStatement objects. I've gotten
> the
> > same errors before when I've forgotten to close things and this has
taken
> > care of it.
> >
> > -----Original Message-----
> > From: anderson [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 28, 2000 1:44 PM
> > To: [EMAIL PROTECTED]
> > Subject: off topic - maximum open cursors exceeded
> >
> > Anyone knows about this error in Oracle ? This error is about the number
> > of Recordset that I use in my page ?
> >
> > Thanks
> >
> >
>
===========================================================================
> > 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
>
>
===========================================================================
> 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
