Re: MySql connection timeout

From: Dave Merrin (dmerri..pasystems.co.uk)
Date: Tue Mar 31 2009 - 07:44:29 EDT

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

    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 - 07:48:26 EDT