Glad to help.
-----Original Message----- From: Jeff Rasmussen [mailto:[EMAIL PROTECTED] 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:[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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
