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
Any light or link highly appreciated!
Joined: Oct 13, 2005
Don't know, but I think that question would sit better on our JDBC/databases forum. Moving.
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.