Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 85478 invoked from network); 31 Jan 2006 13:25:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 Jan 2006 13:25:07 -0000 Received: (qmail 33240 invoked by uid 500); 31 Jan 2006 13:25:06 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 32914 invoked by uid 500); 31 Jan 2006 13:25:05 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 32903 invoked by uid 99); 31 Jan 2006 13:25:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2006 05:25:05 -0800 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [68.142.206.41] (HELO web32811.mail.mud.yahoo.com) (68.142.206.41) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 31 Jan 2006 05:25:04 -0800 Received: (qmail 16544 invoked by uid 60001); 31 Jan 2006 13:24:44 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=zdtpXr0dZKzpt80ZXSRp5HeeWICFIkpCkg9JZ9gFpxBvBAewrHOY+hthyDmPszFhu8MgrJm6UE0gSPJb0sJGcB8nXYZAqn2eKV3xpbZmTs2OzszQnGnqRH7HD62UdqXt4QbQc+nUOF/QnY8RC1SZuWzmR5JAziZ0KNRKIFkG4F8= ; Message-ID: <20060131132444.16542.qmail@web32811.mail.mud.yahoo.com> Received: from [12.20.43.1] by web32811.mail.mud.yahoo.com via HTTP; Tue, 31 Jan 2006 05:24:44 PST Date: Tue, 31 Jan 2006 05:24:44 -0800 (PST) From: Jim Caserta Subject: Pooled Connections Question - V 3.2 RC-2 -= Java/DB2 To: Apache Torque Users List In-Reply-To: <20060128074248.O9829@minotaur.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi all, Occasionally we receive the following connection error message: Torque Exception Message: . Error Message is: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool Occasionally we also find that a connection does not close after a commit. Our code is basic.. con = Torque.getConnection(db2.torque.environment)); //do stuff con.commit(); }finally { if (con != null) { //this is prob never null if (!con.isClosed()) { // send a message the con is NOT closed Torque.closeConnection(con); } Here is a portion of the prop file: torque.dsfactory.eMarine.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory torque.dsfactory.eMarine.connection.driver = COM.ibm.db2.jdbc.app.DB2Driver torque.defaults.pool.initialSize = 1 torque.defaults.pool.maxIdle = 40 torque.defaults.pool.maxActive = 60 torque.defaults.pool.maxWait = 50000 torque.defaults.pool.timeBetweenEvictionRunsMillis= 200000 torque.defaults.pool.minEvictableIdleTimeMillis = 2000000 torque.defaults.connection.driver = COM.ibm.db2.jdbc.app.DB2Driver torque.idbroker.clever.quantity=true torque.manager.useCache = true torque.database.eMarine.adapter=db2app torque.defaults.connection.driver = COM.ibm.db2.jdbc.app.DB2Driver torque.defaults.connection.url = jdbc:db2:DB2B Does anything jump out that might be set wrong? Thank you for any help! Jim __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org