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:mgen...@masslight.net] Enviada: quinta-feira, 28 de Outubro de 2010 14:23 Para: user@cayenne.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 <brunor...@holos.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