cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Merrin <dmer...@ipasystems.co.uk>
Subject Re: MySql connection timeout
Date Tue, 31 Mar 2009 12:52:06 GMT
I'm using the Cayenne PoolManager. I've just turned on the logging for 
this class and discovered my connection is timing out. Cayenne is then 
attempting a reconnection. Can the reconnection be disabled or do I need 
to stop using the PoolManager to get this functionality.

Cheers,

Dave

Dave Merrin wrote:
> Hi Andrey,
>
> I understand how to try and avoid connection timeouts. I'm trying to 
> do the opposite....I want to make it timeout. I want to see how the 
> rest of my application deals with a timeout. Unfortunately I can't get 
> it to timeout in the time I'm specifying in the MySql configuration. 
> That's why I wanted to know if Cayenne is doing anything. If Cayenne 
> is changing or trying to stop the timeout is there any way I can 
> disable this functionality?
>
> Cheers,
>
> Dave
>
> Andrey Razumovsky wrote:
>> This is a known problem, have a look at
>> http://cwiki.apache.org/CAY/reconnect.html
>>
>> 2009/3/31 Dave Merrin <dmerrin@ipasystems.co.uk>
>>
>>  
>>> Hi,
>>>
>>> I've read about and understand that my application is having its 
>>> connection
>>> timed out after 8 hours of inactivity using MySql. I've set the 
>>> timeout to
>>> be 120 seconds so I can try and reproduce the error without waiting 
>>> for 8
>>> hours. Unfortunately I'm never seeing the problem. I connect, make some
>>> queries, sleep for 3 minutes, then make some more queries. I never 
>>> get the
>>> timeout exception.
>>>
>>> Is Cayenne doing something behind the scenes?
>>>
>>> Cheers,
>>>
>>> Dave
>>>
>>>
>>>     
>>
>>   
>
>


Mime
View raw message