Database connection pool design

[Tivo Escobar]

Hi all,

I am designing a connection pool for a particular application: in the
startup, this application requires a lot of connections, but after a
few moments it will use just a few. I wanted a pool that closed the
connections that are not used for a long time.

Do you know any implementation like that? What would be the best
approach?

Thanks in advance,

Tivo

 

[G Winstanley]

Take a look at DBPool:
http://www.snaq.net/java/DBPool/
It can be easily configured to expire unused connections after a certain
time, which seems to fit your requirements. The source code is available to
look at if you decide you want to still write you own.

Stan