Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 5123 invoked from network); 8 Sep 2003 23:36:06 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 8 Sep 2003 23:36:06 -0000 Received: (qmail 66086 invoked by uid 500); 8 Sep 2003 23:35:47 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 66039 invoked by uid 500); 8 Sep 2003 23:35:46 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 65922 invoked from network); 8 Sep 2003 23:35:44 -0000 Received: from unknown (HELO elrond.tucana.at) (213.229.1.27) by daedalus.apache.org with SMTP; 8 Sep 2003 23:35:44 -0000 Received: from localhost (localhost [127.0.0.1]) by elrond.tucana.at (Postfix) with ESMTP id B492A17059F for ; Tue, 9 Sep 2003 01:37:13 +0200 (CEST) Received: from elrond.tucana.at ([127.0.0.1]) by localhost (elrond [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16097-02 for ; Tue, 9 Sep 2003 01:37:12 +0200 (CEST) Received: from marmot.at (unknown [213.143.116.192]) by elrond.tucana.at (Postfix) with ESMTP id 68D97170597 for ; Tue, 9 Sep 2003 01:37:12 +0200 (CEST) Message-ID: <3F5D11F4.8000302@marmot.at> Date: Tue, 09 Sep 2003 01:34:12 +0200 From: Martin Poeschl User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5b) Gecko/20030827 X-Accept-Language: en-us, en, de-de MIME-Version: 1.0 To: Apache Torque Developers List Subject: Re: [repost] Re: Configuring SharedPoolDataSourceFactory References: <3F555E9B.4030507@backstagetech.com.au> <3F5D0E6A.8030706@backstagetech.com.au> In-Reply-To: <3F5D0E6A.8030706@backstagetech.com.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at tucana.at X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N this is the default config i'm using for mysql ... works for me, so there seems to be a problem in your config ... could you please send your complete properties file? martin torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory torque.dsfactory.bookstore.pool.defaultMaxActive=10 torque.dsfactory.bookstore.pool.testOnBorrow=true torque.dsfactory.bookstore.pool.validationQuery=SELECT 1 torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.bookstore.connection.url = jdbc:mysql://localhost:3306/torque torque.dsfactory.bookstore.connection.user = user torque.dsfactory.bookstore.connection.password = password Scott Eade wrote: > Anyone (martin?) have an answer to my query below? > > Scott Eade wrote: > >> In the SharedPoolDataSourceFactory section of >> http://db.apache.org/torque/configuration-howto.html the >> configuration of the pool is shown thus: >> >> torque.dsfactory.bookstore.pool.defaultMaxActive=30 >> torque.dsfactory.bookstore.pool.testOnBorrow=true >> torque.dsfactory.bookstore.pool.validationQuery=SELECT 1 >> >> For me this results in the following appearing in my log file: >> >> ...ERROR...dsfactory.AbstractDataSourceFactory - Property: >> defaultMaxActive value: 3 is not supported by DataSource: >> org.apache.commons.dbcp.datasources.SharedPoolDataSource >> ...ERROR...dsfactory.AbstractDataSourceFactory - Property: >> testOnBorrow value: true is not supported by DataSource: >> org.apache.commons.dbcp.datasources.SharedPoolDataSource >> ...ERROR...dsfactory.AbstractDataSourceFactory - Property: >> validationQuery value: SELECT 1 is not supported by DataSource: >> org.apache.commons.dbcp.datasources.SharedPoolDataSource >> >> Is this something I am doing wrong or is there a problem >> somewhere in org.apache.torque.dsfactory.SharedPoolDataSourceFactory? >> >> Thanks, >> >> Scott > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org