On Mar 4, 2012 2:50 PM, "Bob Hall" <rfha...@yahoo.com> wrote: > > > > > > ________________________________ > From: Brooke Hedrick <brooke.t.hedr...@gmail.com> > To: Tomcat Users List <users@tomcat.apache.org> > Sent: Sunday, March 4, 2012 12:21 PM > > > On Mar 4, 2012, at 1:35 PM, Chema <demablo...@gmail.com> wrote: > > > >>> We use Spring w/ Hibernate as I recall. Yes, we have talked about that - a > >>> ping query. What we don't like about that is now we have a tc ping and app > >>> ping. We have also discussed just changing the tc borrow/ping to do the > >>> dual@remotedb query as this would test both primary and remote. We have > >>> tested this and it works. What stinks about this is we only access the > >>> remotedb 10% of the time. > >> > >> Well, I don't know how works Hibernate , but I know that you can have > >> many SessionFactory > >> Can you define different SessionFactory with different settings , for > >> example, with different pingQuery value? > >> Does Hibernate have a pingQuery setting ? > >> > > > > Even if it does, are we actually losing the close() method for the connection pool mbean? If so, why? > > > > This change would mean requiring many development teams to change many apps. I don't see the value of requiring that change - if it is actually the case we are losing the close() method. > > > Have you tried defining views in the primary database based on the @otherdb queries? > > - Bob >
Bob, How will that help with the borrow query and not wanting to run extra queries to the remote db when not necessary? Everyone - the feedback is great, but it still is just working around the elimination of a jmx call, if that is the case. Why is the jmc close() method being eliminated? > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org >