Is there a good and full tutorial on connection pooling on line ?
I need to find the correct and most bullet proof way of creating a pool
of connections for a jsp page. I have created my own pooling bean
(Based on the example in Jason Hunters second edition book). However
the number of connections to the database slowly increases over time with
it hitting the 100 limit (current ) of the database server in around 48
hours.
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.
Should I implement some sort of garbage collection so that open connections
are closed after 12 hours ? Or is it more likely that my use of the
connections is
in some way incorrect and that is what is causing the "zombie" connections ?
Andy C
Editor R2 Project
http://www.r2-dvd.org
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
