As far as I can tell, the JSTL <sql:> actions are supposed to close the connections that they use. I can't say for sure, because *my* way of dealing with this is to never access the database directly in a JSP. :-) -- Len
On 1/20/06, Alex Turner <[EMAIL PROTECTED]> wrote: > How do you deal with this when using pure JSTL sql calls using a > connection? How does JSTL sql library release the connection at the > end of a page to ensure that connections don't get leaked? For the > case when I'm using a servlet, I have put in an explicit close() call > on the connection, but some pages are pure JSP. > > Alex. > > On 1/20/06, Caldarale, Charles R <[EMAIL PROTECTED]> wrote: > > > > > > > -----Original Message----- > > > From: Alex Turner [mailto:[EMAIL PROTECTED] > > > Subject: Re: Connection Pool Woes > > > > > > It looks like the connection object was not being garbage collected > > > promptly (imagine that), and because it wasn't explicitly closed, it > > > was just hanging open until garbage collection happened (I'm more used > > > to python's garbage collector that is a bit more prompt). > > > > Garbage collection should have nothing to do with it; don't confuse > > finalizers with finally clauses. If your application operation is > > dependent on a finalizer, you're in a world of hurt. There is no > > guarantee that a finalizer will _ever_ be run. > > > > - Chuck > > > > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > > MATERIAL and is thus for use only by the intended recipient. If you > > received this in error, please contact the sender and delete the e-mail > > and its attachments from all computers. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
