General J2EE: Connection Pooling, Writing Your Own
Could someone be so kind as to point me in the direction of a resource describing the necessary obligations of a DB connection pool? Like for instance, is there some sort of keep-alive technique that must be performed?
- Posted by: Jim Hall
- Posted on: June 20 2002 15:43 EDT
I wrote a fairly simple connection pool (to PostgreSQL DB) for my app and it seems to work okay, however there has been some strange behavior (over time the CURRENT_DATE value on these connections gets out of whack, for example).
Any help would be appreciated.
Here's the URL for the Core Servlets and JSP by Marty Hall,
Look at Chapter 18 for a sample Connection Pool implementation.
Jakarta Commons provides a framework for implementing your own (Database Connection) pool. It looks pretty nice.
Thanks for the Link it is a good start, I am also looking into writing my own connection Pool for Databases