Hi Hugi, I don't know the nature of your application. I've used Cayenne's native connection pooling (stand-alone applications) and JNDI (typically based on Apache Commons DBCP) in the past. If my memory is correct, Cayenne's native connection pooling does attempt to do a re-connect on failure. for JNDI, you probably have to tell the JDBC connector to auto-reconnect. If you are using Cayenne's native and it didn't re-connect, we might have an issue to explore. What version of Cayenne are you using?
Thanks, mrg On Mon, Feb 29, 2016 at 8:14 AM, Hugi Thordarson <h...@karlmenn.is> wrote: > Hi Michael, > I’m not quite sure, I’m just giving Cayenne my connection information. > Should I be using a different mechanism? > > Cheers, > - hugi > > > > > On 29. feb. 2016, at 13:10, Michael Gentry <mgen...@masslight.net> > wrote: > > > > Hi Hugi, > > > > Just out of curiosity, which connection pooling mechanism were you using? > > I've seen Cayenne automatically re-connect to PostgreSQL before. > > > > mrg > > > > > > On Mon, Feb 29, 2016 at 6:26 AM, Hugi Thordarson <h...@karlmenn.is> > wrote: > > > >> Ah, awesome. Added to my config :). > >> > >> Cheers, > >> - hugi > >> > >> > >> > >>> On 29. feb. 2016, at 11:25, Andrus Adamchik <and...@objectstyle.org> > >> wrote: > >>> > >>> > >>>> On Feb 29, 2016, at 2:20 PM, Hugi Thordarson <h...@karlmenn.is> > wrote: > >>>> > >>>> What does validationQuery do? > >>> > >>> Periodically executes for each pooled connection, and kills connections > >> that throw during validation. So it ensures that all pooled connections > are > >> in a good state. > >>> > >>> Andrus > >>> > >> > >> > >