From torque-user-return-6246-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Jun 29 07:47:57 2005 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 49399 invoked from network); 29 Jun 2005 07:47:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Jun 2005 07:47:57 -0000 Received: (qmail 38319 invoked by uid 500); 29 Jun 2005 07:47:55 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 38304 invoked by uid 500); 29 Jun 2005 07:47:54 -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 38285 invoked by uid 99); 29 Jun 2005 07:47:53 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2005 00:47: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 [66.218.93.175] (HELO web42007.mail.yahoo.com) (66.218.93.175) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 29 Jun 2005 00:47:52 -0700 Received: (qmail 3040 invoked by uid 60001); 29 Jun 2005 07:47:50 -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=4KoWF8+ewCqDqHUp1ymaCaBVj8rn0PnGLDusCN9mw9EIe/Dm4nFveu3RvJMO5eK5rY4uAz4/IimeX7LaWSjqBPBulvnuregRWtLRMBpk2owGEaNcANJrdYkFEQUqBySVouHL8G19bkFCanj7dv6vvM2WO1RP0YLc9VgRtnjCoWc= ; Message-ID: <20050629074750.3038.qmail@web42007.mail.yahoo.com> Received: from [217.14.40.2] by web42007.mail.yahoo.com via HTTP; Wed, 29 Jun 2005 00:47:50 PDT Date: Wed, 29 Jun 2005 00:47:50 -0700 (PDT) From: Robert Bowen Subject: RE: Tracking DataSource connections To: Apache Torque Users List In-Reply-To: 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 Hello there. Well, I've been looking into the problem, both by trying to debug Torque and DBCP / Pool code and by browsing the DBCP mailing lists. It turns out that the three parameters that most interest me -- removeAbandoned, logAbandoned and removeAbandonedTimeout -- are *only* available in BasicDataSource, *not* in SharedDataSource or PerUserDataSource. So my question is -- can I substitute my SharedDataSource config in Torque.properties for a BasicDataSource? Looking at the org.apache.torque.dsfactory package I don't see BasicDataSource anywhere, so I imagine the answer is no. Just thought I'd ask ... What do you think? Bob --- Thomas Fischer wrote: > > > > > Hi Robert, > > not so sure about this being a dbcp issue, because > at least MaxWait works > for me, and I am also using (the standard) dbcp > 1.2.1. And the dbcp people > know nothing about how the Torque configuration gets > translated into dbcp > properties, and this is the place where the error > appears > > Hm, I got no idea what might go wrong there. I am > afraid the only thing > (except from thinking about what might be different > in your setup from the > "usual": libraries in strange places, invocations > over rmi,....) is to get > the source and debug it. The configuration part is > rather easy to > understand. > > Thomas > > Robert Bowen schrieb am 22.06.2005 > 15:25:53: > > > Hi Thomas, > > > > Well, I took your advice and tried using > > commons-collections 3.0 and 2.1 as well, which is > > packaged with torque 3.1. No go. Same errors. > > > > Do you think I should post this to the dbcp > mailing > > list? I don't want to be the target of flames if I > > cross-post but it seems this is a dbcp issue, not > a > > torque issue ... > > > > What do you think? > > > > --- Thomas Fischer wrote: > > > > > Hi, > > > > > > Torque 3.1.1 comes with commons-collections 3.0. > No > > > idea what has changed > > > and if that makes a difference, but this may > well > > > be. > > > The other library versions are ok. > > > > > > In the runtimetest, the following works without > > > errors : > > > > > > .... > > > torque.defaults.pool.maxWait = 10000 > > > torque.defaults.pool.maxIdle = 8 > > > torque.defaults.pool.maxActive = 10 > > > > torque.defaults.pool.timeBetweenEvictionRunsMillis= > > > 300000 > > > torque.defaults.pool.minEvictableIdleTimeMillis > = > > > 3600000 > > > > > > > > > torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory. > > SharedPoolDataSourceFactory > > > torque.dsfactory.bookstore.pool.maxIdle=8 > > > torque.dsfactory.bookstore.pool.maxActive=10 > > > > torque.dsfactory.bookstore.pool.testOnBorrow=true > > > .... > > > > > > so I would guess at least the maxWait should > work. > > > The attribute > > > defaultMaxActive should probably be changed into > > > maxActive, but this is not > > > the point here. > > > > > > My suggestion would be to try and downgrade to > > > commons-collections 3.0 and > > > see whether the error goes away. > > > > > > Thomas > > > > > > Robert Bowen schrieb am > 21.06.2005 > > > 10:04:42: > > > > > > > Hello all. > > > > > > > > I think I may have a connection leak somewhere > in > > > my > > > > app and I have been perusing the mailing list > > > archives > > > > trying to see how I can track open and > abandoned > > > > connections. > > > > > > > > I upgraded all the pertinent jars: > > > > > > > > commons-dbcp 1.2.1 > > > > commons-pool 1.2 > > > > commons-collections 3.1 > > > > > > > > I have tried putting the following lines in my > > > Torque > > > > config file: > > > > > > > > torque.dsfactory.myApp.pool.maxWait = 5000 > > > > > torque.dsfactory.myApp.pool.defaultMaxActive=25 > > > > torque.dsfactory.myApp.pool.removeAbandoned = > true > > > > torque.dsfactory.myApp.pool.logAbandoned = > true > > > > > torque.dsfactory.myApp.pool.removeAbandonedTimeout > > > = > > > > 300 > > > > > > > > ... and *all* of them fail with the following > > > error: > > > > > > > > [ERROR] AbstractDataSourceFactory - Property: > > > > > > | defaultMaxActive | removeAbandoned | > > > logAbandoned | > > > > removeAbandonedTimeout> value: 25 is not > supported > > > by > > > > DataSource: > > > > > > > > > > org.apache.commons.dbcp.datasources.SharedPoolDataSource > > > > > > > > I found these settings on the DBCP web site > under > > > > configuration, and have seen them in various > > > messages > > > > on the mailing list. > > > > > > > > Can anyone explain to me why they are choking? > > > > > > > > Many thanks, > > > > Bob > > > > > > > > > > > > > > > > > > > > > > > > > > > > ____________________________________________________ > > > > Yahoo! Sports > > > > Rekindle the Rivalries. Sign up for Fantasy > > > Football > > > > http://football.fantasysports.yahoo.com > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > > torque-user-unsubscribe@db.apache.org > > > > For additional commands, e-mail: > > > torque-user-help@db.apache.org > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > > torque-user-unsubscribe@db.apache.org > > > For additional commands, e-mail: > > > torque-user-help@db.apache.org > > > > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - Helps protect you from nasty > viruses. > > http://promotions.yahoo.com/new_mail > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > torque-user-unsubscribe@db.apache.org > > For additional commands, e-mail: > torque-user-help@db.apache.org > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: > torque-user-help@db.apache.org > > __________________________________ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org