File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Difference between jakarta dbutils and dbcp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Difference between jakarta dbutils and dbcp" Watch "Difference between jakarta dbutils and dbcp" New topic

Difference between jakarta dbutils and dbcp

S├ębastien Roux

Joined: Jan 22, 2007
Posts: 5
Dear guruz,

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!



Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46337
Don't know, but I think that question would sit better on our JDBC/databases forum. Moving.
Mark Vedder
Ranch Hand

Joined: Dec 17, 2003
Posts: 624

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.
I agree. Here's the link:
subject: Difference between jakarta dbutils and dbcp
It's not a secret anymore!