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:[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
