Hi there,
I used the below link to implement my own connection and
prepared-statement pooling. It really help to solve my problem.
http://www.javaworld.com/jw-06-1998/jw-06-object-pool.html
Hope I could help.
Detlef
On Sun, 15 Jul 2001 11:15:31 +0100, Andy C <[EMAIL PROTECTED]> wrote:
>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
___________________________________________________________________________
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
