Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Difference between jakarta dbutils and dbcp

 
S├ębastien Roux
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!

Rgds,

SRoux
 
Campbell Ritchie
Sheriff
Posts: 48652
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't know, but I think that question would sit better on our JDBC/databases forum. Moving.
 
Mark Vedder
Ranch Hand
Posts: 624
IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic