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
