db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: How does Torque handle the database disconnecting idle connections???
Date Fri, 30 Jan 2004 14:48:04 GMT

You can try to use the Jdbc2Pool (the second pool type in 
Here you can enter a validation query, ex:
torque.dsfactory.yourdb.pool.validationQuery=SELECT 1

Best wishes,

Jeff Rasmussen wrote:

>I have been using torque for some time and have run into issues when the
>system sits idle for a given amount of time (the timeout settings on the
>database) torque throws IO errors.
>Does torque not check the connections before trying to use them????
>MySQL has a timeout setting for idle connections. It seems like torque
>will pool the connections, let them run idle, MySQL will disconnect the
>connections, but torque will still think that the connections are valid.
>When torque uses the connection we get SQLExceptions : Communication
>link failure.
>If you try to access it a second time everything works.
>Thanks for the input
>Jeff Rasmussen
>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

View raw message