JDBC Connection Pool Theory ??

[Jon Shoberg]

        Can anyone suggest or point to readings on JDBC connection pool theory?
Something that covers how a pool is implemented, best case / worst case
scenarios, tips and traps.

        My next web application is looking to be very database (mysql) intensive.
I would like a pooling mechanism that is VERY simple to use, VERY light, low
overhead, and portable.  Having looked at packages such as poolman, I
decided I need to learn a bit more about JDBC and pooling in general.  Any
thoughts ?

Jon