Re: MySql connection timeout

From: Dave Merrin (dmerri..pasystems.co.uk)
Date: Tue Mar 31 2009 - 08:52:06 EDT

  • Next message: Andrus Adamchik: "Re: MySql connection timeout"

    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 <dmerri..pasystems.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
    >>>
    >>>
    >>>
    >>
    >>
    >
    >

    This archive was generated by hypermail 2.0.0 : Tue Mar 31 2009 - 08:56:24 EDT