Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 52825 invoked from network); 7 Mar 2006 21:38:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Mar 2006 21:38:43 -0000 Received: (qmail 70616 invoked by uid 500); 7 Mar 2006 21:38:40 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 70562 invoked by uid 500); 7 Mar 2006 21:38:40 -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 70549 invoked by uid 99); 7 Mar 2006 21:38:39 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Mar 2006 13:38:39 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of vijay.anjur@gmail.com designates 64.233.162.206 as permitted sender) Received: from [64.233.162.206] (HELO zproxy.gmail.com) (64.233.162.206) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Mar 2006 13:38:39 -0800 Received: by zproxy.gmail.com with SMTP id 13so29678nzn for ; Tue, 07 Mar 2006 13:38:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=XgxKv0wWFSMe/wh1IRxnQaCbJKwm833queXXt2g6gYSzZ1jZq75H0K4nRLG0q2bERBfSAe8je4MiMQac9+5hZ7KozOk1ekPqwSexe1AiZZ8Ceejb7nMXoBYKxKOF7CIauFE2bTAb3JcO8N58aptPpsI2D6VQRNyssUQafRdpP+E= Received: by 10.36.25.9 with SMTP id 9mr1176451nzy; Tue, 07 Mar 2006 13:38:18 -0800 (PST) Received: by 10.36.22.8 with HTTP; Tue, 7 Mar 2006 13:38:18 -0800 (PST) Message-ID: <83247d4c0603071338h6ec2533bn1151b60b158e0544@mail.gmail.com> Date: Tue, 7 Mar 2006 16:38:18 -0500 From: "Vijay Anjur" To: commons-user@jakarta.apache.org Subject: commons.dbcp MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8703_9169770.1141767498434" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_8703_9169770.1141767498434 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I am getting following exception, org.apache.commons.dbcp.SQLNestedExceptio= n: Cannot get a connection, pool exhausted - Any ideas? The sequence to produce the exception is as follows. Make connection(into connection pool) from an application,Exit the client. Kill all the connections the client made to the RDBMS (the Pool has). The pool now has invalid connections.Logging thru the client again to get connection from pool. Pool validates the dead connection and then trying to make a new connection throws the following error from factory.makeobject(). org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.apache.commons.dbcp.PoolingDataSource.getConnection( PoolingDataSource.java:103) at org.apache.commons.dbcp.BasicDataSource.getConnection( BasicDataSource.java:540) at org.apache.commons.dbcp.DataSourceConnectionFactory.createConnection( DataSourceConnectionFactory.java:42) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject( PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject( GenericObjectPool.java:771) at org.apache.commons.dbcp.PoolingDataSource.getConnection( PoolingDataSource.java:95) I have set maxActive to 7. and testOnBorrow to true. Thanks, Vijay ------=_Part_8703_9169770.1141767498434--