Well, I'm not sure what you are using to run your web application, but Tomcat, Jetty, JBoss, etc all have mechanisms to provide JNDI lookups of DB connection pools. You just tell Cayenne Modeler to use JNDI lookup and give it the JNDI name, then configure the container to provide the DB connection.
Is your WO application using EOF or Cayenne? Been a while since I used WO, but I'd be stunned if EOF cannot use a JNDI lookup as well. mrg On Mon, Mar 7, 2016 at 3:07 PM, Hugi Thordarson <h...@karlmenn.is> wrote: > Hi Michael, > does using JNDI change anything about the connection itself, isn’t it just > a different method of looking up connection information? > > But I probably can’t use it anyway since one of the apps is a WebObjects > app and doesn’t provide a JNDI service (at least I’ve never used it). > > Thanks, > - hugi > > > > On 7. mar. 2016, at 19:13, Michael Gentry <mgen...@masslight.net> wrote: > > > > Hi Hugi, > > > > Since this appears to be a web-based application, can you switch to using > > JNDI? > > > > mrg > > > > > > On Mon, Mar 7, 2016 at 5:46 AM, Hugi Thordarson <h...@karlmenn.is> > wrote: > > > >> Hi all, > >> This is still happening, even after I added a validationQuery, our app > is > >> dying quite frequently :(. I’m not quite sure how to debug this, is > there > >> any way for me to catch where connections are being opened in the code > and > >> at what location they’re hanging? > >> > >> > >> > https://www.dropbox.com/s/8jkmh6513s6wwkn/Screenshot%202016-03-07%2010.21.53.png?dl=0 > >> > >> Cheer, > >> - hugi > >> > >> // Hugi Thordarson > >> // http://www.loftfar.is/ > >> // s. 895-6688 > >> > >> > >> > >>> 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 > >>> > >> > >> > >
