RE: MySQL error - connection reset

From: Bruno René Santos (brunoren..olos.pt)
Date: Thu Oct 28 2010 - 13:56:27 UTC

  • Next message: Andrus Adamchik: "Re: MySQL error - connection reset"

    Also I am using tomcat 6.0.26 with liferay.

    Thanx
    Bruno

    -----Mensagem original-----
    De: Bruno René Santos [mailto:brunoren..olos.pt]
    Enviada: quinta-feira, 28 de Outubro de 2010 14:47
    Para: use..ayenne.apache.org
    Assunto: RE: MySQL error - connection reset

    Hi Michael,

    I am using cayenne 3.0.1 and I create a datacontext with
    DataContext.createDataContext(), using a JNDI connection pool configured on the
    context.xml on tomcat.

    Thanx
    Bruno

    -----Mensagem original-----
    De: Michael Gentry [mailto:mgentr..asslight.net]
    Enviada: quinta-feira, 28 de Outubro de 2010 14:23
    Para: use..ayenne.apache.org
    Assunto: Re: MySQL error - connection reset

    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:56:57 UTC