Sorry Brad I wasn't clear about the problem ! I don't actually close
the connections (I was typing the message too fast I guess). Besides
it doesn't happen with every use of the database but rather it builds up
over time.
Andy
----- Original Message -----
From: "Brad Cox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 1:30 PM
Subject: Re: Connection Pooling ....
> At 11:15 AM +0100 7/15/01, Andy C wrote:
> >As far as I can see the bean releases and closes a connection almost as
soon
> >as the result set is returned so I'm not sure why connections are
remaining
> >open.
>
> There's your problem. You should release it to the pool without
> closing it, which destroys it, requiring the pool to create another
> one.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
