You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Pramodh Peddi <pp...@IMPRIVATA.com> on 2005/06/12 00:29:37 UTC

DBCP for connection pooling

Hi,

 

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,

 

Pramodh.

Re: DBCP for connection pooling

Posted by Vikram Goyal <te...@craftbits.com>.
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).

HTH,
Vikram Goyal
---------------------------------------------------------------------------------------
Jakarta Commons Online Bookshelf
Module 9: Pool and DBCP: http://www.manning.com/catalog/view.php?book=goyal9
All Modules: http://www.manning.com/goyal
---------------------------------------------------------------------------------------

----- Original Message ----- 
From: "Pramodh Peddi" <pp...@IMPRIVATA.com>
To: <co...@jakarta.apache.org>
Sent: Sunday, June 12, 2005 8:29 AM
Subject: DBCP for connection pooling


Hi,



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,



Pramodh.




---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org