Try the DBConnectionManager class by Gefion Software. It was written up in a
recent trade magazine. Follow this URL for details:
http://www.WebDevelopersJournal.com/columns/connection_pool.html
It's very simple to implement, and quite flexible for multiple pools, database
vendors, etc.
Constantin
---
Mark Foster wrote:
> Yes - that's why I decided not to use it. The author claims the source is
> available "on request" yet ignored my repeated requests for the source...
> I must say, however, that it was not clear from the tests I did whether the
> connections were actually being gobbled up, or whether the count was merely
> not recalculated correctly in freeConnection(conn).
> -mdf
>
> > -----Original Message-----
> > From: Peet DENNY [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 08, 2000 4:21 AM
> > Subject: Connection pool doesn't release old connections
> >
> >
> > Hi,
> > I'm having some trouble with my JavaExchange connection pool
> > implementation.
> > I'm not sure whether it's a problem with the Javaexchange
> > class, or with my
> > code.
> >
> > The symptoms: the alotted number of DB connections is quickly
> > exhausted.
> >
> > THe background: I've got a singleton wrapper class for my
> > connection pool,
> > which hands out conns.
> > All of the methods which use the DB start with
> > connPool.getConn() and have
> > the rest of the code enclosed in a try statement. The
> > connPool.freeConn(conn) method is called from a finally{} statement.
> >
> > Quite quickly, the available conns are exhausted.
> > Has anyone else had this problem?
> >
> > Thanks
> > Peet
> >
>
> ___________________________________________________________________________
> 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
