Re: Exception after my program sleep for 2 hours.

Thomas Fischer wrote:
>> I have a java program that uses Torque and it is working fine with
>> one  exception. My program might need to sleep for 2 hours, using
>> Thread.sleep() but  after it wake up again, torque always throws an
>> exception when I try to call doSelect(). Is there  anyway to avoid
>> this?.  This program don't do any  connection handling at all.
>>     
>
> The exception indicates that this is a mysql problem. please search the net
> for this mysql problem.
>   
Well, as far as I can see, the problem is that torque reuse the same 
mysql connection for all its queries.
This is in itself a good thing, because it would be a waste to open a 
new connection each time it perform a query,
but when I put the application to sleep, the connection times out 
because it is not used in 2 hours.

But torque don't detect that the connection is timed out, and then it 
get this mysql error, when it tries to use the timed out connection.

As far as I can see there are 2 possible solutions: Either torque should 
detect that the connection is closed, and then
open a new connection, or I should tell torque to close the connection 
before I call Thread.sleep and then tell
torque to reopen the connection after the program wake up. But I could 
not find any api calls to do this.

Martin