thank you so much Kishore...
[]s
Kishore Raghavan wrote:
> 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
===========================================================================
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
