Re: MySQL error - connection reset

From: Michael Gentry (mgentr..asslight.net)
Date: Thu Oct 28 2010 - 13:23:00 UTC

  • Next message: Bruno Ren Santos: "Complex query"

    Hi Bruno,

    Are you using Cayenne's connection pooling mechanism or something
    provided by the container? Either should automatically reconnect for
    you.

    mrg

    On Thu, Oct 28, 2010 at 5:59 AM, Bruno Ren Santos <brunoren..olos.pt> wrote:
    > Hello all,
    >
    > Yesterday I left an application running with cayenne on a tomcat server
    > (left the browser opened), using JNDI, and when I came today and tried to
    > use it again I got the error in attachment. It seems mysql resetted the
    > connection with cayenne during the night. One of the things that made me
    > choose Cayenne over Hibernate was under the assumption that connections were
    > made with the database server only when needed (on performQuery or
    > commitChanges) but on this situation it seemed that the connection was
    > permanently opened and cayenne tried to use it again (like hibernate).
    >
    > Perhaps I am doing something wrong and so I needed some clarification on
    > this issue.
    >
    >
    >
    > Thank you
    >
    > Bruno Santos



    This archive was generated by hypermail 2.0.0 : Thu Oct 28 2010 - 13:23:50 UTC