commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vikram Goyal" <>
Subject Re: DBCP for connection pooling
Date Sun, 12 Jun 2005 00:30:11 GMT
Hi Pramodh,

Yes, DBCP is a good tool to use for both of your requirements. It does do 
PreparedStatement pooling quite well.

The database that you use has no impact on the usability of a connection 
pool (DBCP or otherwise).

Vikram Goyal
Jakarta Commons Online Bookshelf
Module 9: Pool and DBCP:
All Modules:

----- Original Message ----- 
From: "Pramodh Peddi" <>
To: <>
Sent: Sunday, June 12, 2005 8:29 AM
Subject: DBCP for connection pooling


I am just about use Apache's DBCP tool to implement connection pooling
in our product (we used to have our own implementation of connection
pooling), which uses MySQL. We will be using this tool to achieve two
benifits mainly:

1. DB Connection pooling.

2. PreparedStatement pooling.

I am sure we will get feature 1, but wondering if this tool really gives
feature2, because I have not heard much about PS pooling offered by this
tool, but I realize there are a couple of configurations options to pool
PS objects.

Are there any other things to keep in mind before using this tool
(Again, we use MySQL)?

Thanks in advance,


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message