This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'm still playing in the beginners field lately and getting interested in JDBC...
I've been looking around the web for some "make it easy" classes regarding JDBC connection management.
I've found out that it exists some connection poolers around (jakarta DBCP) and connection handlers DbUtils.
Well its not clear yet to my mind, as I'm still trying to understand how to position those two librairies? I did not made any test yet
DBCP is solely a connection pool library, whereas DbUtils provides some utility classes aimed at making working with JDBC easier. DbUtils does not contain any connection pooling. And DBCP doesn't provide any functionality beyond connection pooling. Another popular database connection pooling library (considerably more popular than DBCP I believe) is c3p0.
If you are not familiar with what a connection pool is, and its benefits, you can read a quick definition at Wikipedia or this definition at Webopedia. There are a number of article on the web about connection pools. And any decent book on JDBC would discuss it.