I want to use a JDBC connection pool. The most important factor is that it’s easy-to-use and bug-free. What is suitable for me?
Another fine alternative is the Apache Database Connection Pool.
Instead of getting a connection using DriverManager, you’ll use a JNDI naming service to get your connection out of the pool.
Be sure to close your resources – Connection, Statement, and ResultSet. If you don’t, your pool will be quickly exhausted.