Connection Pooling with Tomcat is just what I have been looking for - I've been trying to work this out for hours!

Dive into connection pooling with J2EE is a good follow-up read, but it doesn't have a simple step-by-step guide to getting started.