Re: MySQL error - connection reset

From: Borut Bolčina (borut.bolcin..mail.com)
Date: Thu Oct 28 2010 - 13:23:10 UTC

  • Next message: Michael Gentry: "Re: MySQL error - connection reset"

    Hi,

    if you are using dbcp.properties, do you have something like

    cayenne.dbcp.validationQuery="SELECT 1 FROM one_of_your_table"

    -Borut

    2010/10/28 Bruno René Santos <brunoren..olos.pt>

    > 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:44 UTC