Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 84331 invoked from network); 10 Jan 2007 17:10:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 10 Jan 2007 17:10:43 -0000 Received: (qmail 5199 invoked by uid 500); 10 Jan 2007 17:10:49 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 5183 invoked by uid 500); 10 Jan 2007 17:10:49 -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 5172 invoked by uid 99); 10 Jan 2007 17:10:49 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jan 2007 09:10:49 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [209.226.175.177] (HELO tomts52-srv.bellnexxia.net) (209.226.175.177) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jan 2007 09:10:38 -0800 Received: from [192.168.1.63] ([67.69.13.58]) by tomts52-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20070110171016.YFCC16990.tomts52-srv.bellnexxia.net@[192.168.1.63]> for ; Wed, 10 Jan 2007 12:10:16 -0500 Message-ID: <45A51DF7.6050208@idilia.com> Date: Wed, 10 Jan 2007 12:10:15 -0500 From: Eustache User-Agent: Mozilla Thunderbird 1.0.7-1.4.1.centos4 (X11/20051007) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: exception thrown because DB connection not correctly reinited after db server restart References: <45A514BD.7060308@idilia.com> In-Reply-To: <45A514BD.7060308@idilia.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org adding this lines to the torque.properties make it work (checks that connection is ok before using it): torque.dsfactory.web_test_suite.pool.defaultMaxActive=30 torque.dsfactory.web_test_suite.pool.testOnBorrow=true torque.dsfactory.web_test_suite.pool.validationQuery=SELECT 1 Eustache wrote: > Hi, I wonder if you can help with the following problem: > I use Tomcat 5.5, postgresql 8.3.1 and Torque. > I first use the webapp using torque everything is ok. I close the app, > a db connection is still there. > Now I reboot db. Try to relaunch the webapp and has this exception in > catalina.out: > > DEBUG org.apache.torque.util.SQLBuilder - SELECT > app_category.CATEGORY_ID, app_category.NAME FROM app_category WHERE > app_category.CATEGORY_ID=1028 > org.apache.torque.TorqueException: org.postgresql.util.PSQLException: > An I/O error occured while sending to the backend. > > [torque.properties] > torque.database.default=web_test_suite > torque.database.web_test_suite.adapter = postgresql > torque.dsfactory.web_test_suite.factory = > org.apache.torque.dsfactory.SharedPoolDataSourceFactory > torque.dsfactory.web_test_suite.connection.driver = org.postgresql.Driver > torque.dsfactory.web_test_suite.connection.url = > jdbc:postgresql://myserver/mydb > torque.dsfactory.web_test_suite.connection.user = myuser > torque.dsfactory.web_test_suite.connection.password = > > It seems that torque is not able to get a proper db connection after > the db server is restarted > Any clue ? > > --------------------------------------------------------------------- > 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