db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Rasmussen <jrasmus...@lnxi.com>
Subject RE: How does Torque handle the database disconnecting idleconnections???
Date Fri, 30 Jan 2004 14:48:58 GMT
Thanks for the extremely quick response Michael.

I will give it a try.

I really find the users on this list most polite and knowledgeable. 

Thanks to all. :-)



On Fri, 2004-01-30 at 07:44, Michael Kucera wrote:
> I had the same problem with MySQL. Set autoReconnect=true in the db
> connection string in torque.properties.
> 
> jdbc:mysql://localhost/mydb?autoReconnect=true
> 
> 
> 
> -----Original Message-----
> From: Jeff Rasmussen [mailto:jrasmussen@lnxi.com] 
> Sent: Friday, January 30, 2004 9:31 AM
> To: Apache Torque Users List
> Subject: How does Torque handle the database disconnecting
> idleconnections???
> 
> 
> 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????
> 
> 
> Example:
> 
> 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
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message