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?

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.

http://archive.coreservlets.com/Chapter18.html

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