Return-Path: Delivered-To: apmail-commons-dev-archive@www.apache.org Received: (qmail 5428 invoked from network); 8 Aug 2007 00:13:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Aug 2007 00:13:49 -0000 Received: (qmail 35723 invoked by uid 500); 8 Aug 2007 00:13:47 -0000 Delivered-To: apmail-commons-dev-archive@commons.apache.org Received: (qmail 35622 invoked by uid 500); 8 Aug 2007 00:13:46 -0000 Mailing-List: contact dev-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Jakarta Commons Developers List" Delivered-To: mailing list dev@commons.apache.org Received: (qmail 35613 invoked by uid 99); 8 Aug 2007 00:13:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Aug 2007 17:13:46 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of phil.steitz@gmail.com designates 64.233.182.191 as permitted sender) Received: from [64.233.182.191] (HELO nf-out-0910.google.com) (64.233.182.191) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Aug 2007 00:13:44 +0000 Received: by nf-out-0910.google.com with SMTP id d3so532154nfc for ; Tue, 07 Aug 2007 17:13:22 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=LwO+5ZYT2zoV6YZxE1P9Q2jrCkdaQUVIVwT9s9BxKZN5tDftluNRgctXABR6uHyNv3X1ntDLOdVCX6or6UXt7hen9Su2pv7tOQJi5oZCaDFO0k+IOk11HfAoAY0cSN+3KG1bMrsso84+t6ZW4+phlGyCRHf3bU9sTzBdpgLC5BI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=KkZ1wLYYTVCm9Tib6F4jZX+X/2kyO3DzFgLIVpg0dko63vH5FEzShV3aWRI0B+yREZgfdwW9ufREsmiQ46mrSVSthcRlxcg72VIlimksYhx9mvZthP+2rYc9ivjJkyIMr6s8UIe0KWq6VU/nIbUtTgyus+m3Gkntsssxw1RXOgQ= Received: by 10.78.56.19 with SMTP id e19mr2002965hua.1186532002436; Tue, 07 Aug 2007 17:13:22 -0700 (PDT) Received: by 10.78.203.8 with HTTP; Tue, 7 Aug 2007 17:13:22 -0700 (PDT) Message-ID: <8a81b4af0708071713l7417c2eas9c6f27af66ad7a94@mail.gmail.com> Date: Tue, 7 Aug 2007 17:13:22 -0700 From: "Phil Steitz" To: "Jakarta Commons Developers List" Subject: Re: [DBCP] Connection gets blocked on 9th connection. In-Reply-To: <5496EFD093B7344880ACD15AEF82BC44058218C3@tbird.corp.eease.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <18e049e20708071343u7c7495feq8154dd7f73ad07b5@mail.gmail.com> <5496EFD093B7344880ACD15AEF82BC44058218C3@tbird.corp.eease.com> X-Virus-Checked: Checked by ClamAV on apache.org Tushar, If you want to use BasicDataSource, you need to set the pool properties using its setters (i.e., using the setters on the BasicDataSource instance). It is designed to take care of creating and managing the underlying pool and PoolingDataSource for you. Have a look at the examples here: http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/ The BasicDataSourceExample defaults the pool parameters, but ds.setMaxIdle, etc could be added to the setupDataSource method there to set those parameters. The ManualPoolingDataSourceExample shows how to do it if you want to create the pool yourself and "manually" create the PoolingDataSource from it. Phil --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org For additional commands, e-mail: dev-help@commons.apache.org