Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 62662 invoked from network); 12 Jun 2005 00:36:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 12 Jun 2005 00:36:05 -0000 Received: (qmail 53590 invoked by uid 500); 12 Jun 2005 00:35:54 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 53574 invoked by uid 500); 12 Jun 2005 00:35:54 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 53553 invoked by uid 99); 12 Jun 2005 00:35:54 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FORGED_RCVD_HELO,SPF_HELO_PASS X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from mail5.tpgi.com.au (HELO mail.tpg.com.au) (203.12.160.101) by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 11 Jun 2005 17:35:52 -0700 Received: from vikram (60-240-152-159.tpgi.com.au [60.240.152.159]) by mail.tpg.com.au (8.12.10/8.12.10) with SMTP id j5C0ZaeS026160 for ; Sun, 12 Jun 2005 10:35:47 +1000 Message-ID: <002701c56ee5$e9ed0d00$0202a8c0@vikram> From: "Vikram Goyal" To: "Jakarta Commons Users List" References: Subject: Re: DBCP for connection pooling Date: Sun, 12 Jun 2005 10:30:11 +1000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-TPG-Antivirus: Passed X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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" To: 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