Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 80120 invoked from network); 23 Jun 2005 05:55:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 23 Jun 2005 05:55:00 -0000 Received: (qmail 67661 invoked by uid 500); 23 Jun 2005 05:54:54 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 67613 invoked by uid 500); 23 Jun 2005 05:54:53 -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 67600 invoked by uid 99); 23 Jun 2005 05:54:53 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2005 22:54:53 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [195.130.132.57] (HELO apate.telenet-ops.be) (195.130.132.57) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2005 22:54:54 -0700 Received: from localhost (localhost.localdomain [127.0.0.1]) by apate.telenet-ops.be (Postfix) with SMTP id A8FEF380D5 for ; Thu, 23 Jun 2005 07:54:51 +0200 (CEST) Received: from [127.0.0.1] (d51A55340.access.telenet.be [81.165.83.64]) by apate.telenet-ops.be (Postfix) with ESMTP id 983E73807E for ; Thu, 23 Jun 2005 07:54:51 +0200 (CEST) Message-ID: <42BA4EA5.8080704@pandora.be> Date: Thu, 23 Jun 2005 07:54:45 +0200 From: Dirk Verbeeck User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jakarta Commons Users List Subject: Re: [dbcp] meanings of active, idle References: <20050622151635.30898.qmail@web53101.mail.yahoo.com> In-Reply-To: <20050622151635.30898.qmail@web53101.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N A connection is active when it is being used by the program. It was borrowed from the pool by db.getConnection() and hasn't been returned to the pool yet by con.close(). When a connection has been returned to the pool by con.close() then a connection is considered idle. A connection that is reallyClosed (the plysical connection to the database), isn't in the statistics anymore. A connection will really be closed by the pool if the maxIdle limit is reached and in other similar cases. Normally the program using the pool just borrows/returns connection frm/to the pool. -- Dirk mark archur wrote: > Hi, > I am using commons-dbcp and its going well so far. But, I am not 100% clear of what exactly an active, idle connection mean (and not sure if its meaning changes in the context of pool). Let me tell what I understand: > Active: A connection is said to be active if a connection is open and is not closed yet. In the context of pool, does the meaning change? > Idle: I am guessing a connection to be idle should be closed. But, not sure when can it be idle. Again, does the meaning change in the context of pool? > > Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org