db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Kucera" <mkuc...@bbm.ca>
Subject RE: How does Torque handle the database disconnectingidleconnections???
Date Fri, 30 Jan 2004 18:09:30 GMT
Glad to help.


-----Original Message-----
From: Jeff Rasmussen [mailto:jrasmussen@lnxi.com] 
Sent: Friday, January 30, 2004 12:06 PM
To: Apache Torque Users List
Subject: RE: How does Torque handle the database
disconnectingidleconnections???


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


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