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 17:05:50 GMT
Thanks again to Michael.

This fixed my problem




On Fri, 2004-01-30 at 07:48, Jeff Rasmussen wrote:
> 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
> 
> 


---------------------------------------------------------------------
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