Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Subject: RE: How does Torque handle the database disconnecting
	idleconnections???
From: Jeff Rasmussen <jrasmussen@lnxi.com>
Reply-To: jrasmussen@lnxi.com
To: Apache Torque Users List <torque-user@db.apache.org>
In-Reply-To: <1075474137.1520.125.camel@Jeffras.dubtech.com>
References: <4CC412117D772B4C8F5F55C13E0F3C090452FC@bbmex1.ad.bbm.ca>
	 <1075474137.1520.125.camel@Jeffras.dubtech.com>
Content-Type: text/plain
Organization: Linux Networx
Message-Id: <1075482350.1520.133.camel@Jeffras.dubtech.com>
Mime-Version: 1.0
Date: Fri, 30 Jan 2004 10:05:50 -0700
Content-Transfer-Encoding: 7bit

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