From torque-user-return-6743-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue Jan 31 20:09:15 2006 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 11619 invoked from network); 31 Jan 2006 20:09:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 Jan 2006 20:09:15 -0000 Received: (qmail 4245 invoked by uid 500); 31 Jan 2006 20:09:12 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 4113 invoked by uid 500); 31 Jan 2006 20:09:12 -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 3935 invoked by uid 99); 31 Jan 2006 20:09:11 -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 12:09:11 -0800 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of Greg.Monroe@dukece.com designates 65.112.55.73 as permitted sender) Received: from [65.112.55.73] (HELO mail.dukece.com) (65.112.55.73) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2006 12:09:10 -0800 Received: from dukece-mail3.dukece.com ([192.168.1.222]) by mail.dukece.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 31 Jan 2006 15:08:57 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Content-Class: urn:content-classes:message Subject: RE: Pooled Connections Question - V 3.2 RC-2 -= Java/DB2 MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Date: Tue, 31 Jan 2006 15:08:47 -0500 Message-ID: <8F5843B903F59D4C8C6806BB49A39119062976@dukece-mail3.dukece.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Pooled Connections Question - V 3.2 RC-2 -= Java/DB2 Thread-Index: AcYmacEnyjXYimgoRfGzEi4JKVKhMQAN77qA From: "Greg Monroe" To: "Apache Torque Users List" X-OriginalArrivalTime: 31 Jan 2006 20:08:57.0281 (UTC) FILETIME=[2AE47310:01C626A2] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I seem to remember getting this error when load testing an application. I think the solution was to bump up the JVM initial memory pool and=20 maximum memory pool (good thing to do by default). But then again, my neural net sometimes makes the=20 wrong connections as I get older. > -----Original Message----- > From: Jim Caserta [mailto:smoothie_jc@yahoo.com]=20 > Sent: Tuesday, January 31, 2006 8:25 AM > To: Apache Torque Users List > Subject: Pooled Connections Question - V 3.2 RC-2 -=3D Java/DB2 >=20 >=20 > Hi all, >=20 > 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 > =20 > Occasionally we also find that a connection does not > close after a commit. Our code is basic.. >=20 > con =3D Torque.getConnection(db2.torque.environment));=20 > //do stuff > con.commit(); > }finally { =20 > if (con !=3D null) { //this is prob never null > if (!con.isClosed()) { > // send a message the con is NOT closed > Torque.closeConnection(con); } >=20 > Here is a portion of the prop file:=20 > torque.dsfactory.eMarine.factory=3Dorg.apache.torque.dsfactory.S > haredPoolDataSourceFactory > torque.dsfactory.eMarine.connection.driver =3D=20 > COM.ibm.db2.jdbc.app.DB2Driver >=20 > torque.defaults.pool.initialSize =3D 1=20 > torque.defaults.pool.maxIdle =3D 40 torque.defaults.pool.maxActive =3D = 60 >=20 > torque.defaults.pool.maxWait =3D 50000=20 > torque.defaults.pool.timeBetweenEvictionRunsMillis=3D > 200000 > torque.defaults.pool.minEvictableIdleTimeMillis =3D > 2000000 > torque.defaults.connection.driver =3D=20 > COM.ibm.db2.jdbc.app.DB2Driver torque.idbroker.clever.quantity=3Dtrue > torque.manager.useCache =3D true = torque.database.eMarine.adapter=3Ddb2app > torque.defaults.connection.driver =3D=20 > COM.ibm.db2.jdbc.app.DB2Driver torque.defaults.connection.url=20 > =3D jdbc:db2:DB2B >=20 >=20 > Does anything jump out that might be set wrong? >=20 > Thank you for any help! > Jim >=20 >=20 >=20 > =20 >=20 > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around=20 > http://mail.yahoo.com=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org >=20 >=20 Duke CE Privacy Statement Please be advised that this e-mail and any files transmitted with it are = confidential communication or may otherwise be privileged or = confidential and are intended solely for the individual or entity to = whom they are addressed. If you are not the intended recipient you may = not rely on the contents of this email or any attachments, and we ask = that you please not read, copy or retransmit this communication, but = reply to the sender and destroy the email, its contents, and all copies = thereof immediately. Any unauthorized dissemination, distribution or = copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org