Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=1JsewkGh1Hs22ZmawSPnmEUcC09gm1ZgDmwfgG0PCmM9yn9I1OGN7TsC25290D5ogS4Xy3zHnAj4WjghYV51XYGUoCCJHrMyEAycxYo/J6r1EtN1gn4u/nG1oWJnl6HHaLEKXyVjt4Sr+T+1XoecQoBHdDQmh9s0G1pGtvDxWso=;
References: <4F520F97.3050506@gmx.net> <4F5219AF.2050105@pidster.com>
 <CA+C76xSnbH_3uF+=60AS2zk_MCziLvi5rPacxO87e29rQ6sEpA@mail.gmail.com>
 <99C8B2929B39C24493377AC7A121E21FB013E32BD3@USEA-EXCH8.na.uis.unisys.com>
 <CA+C76xSy5dJZgZ+ViYmmY2_7JaD6KmpTBYbm0aNAS7o0n0LkMw@mail.gmail.com>
 <CABOBwRh0CVY4naVp2zNcME+VDgqizhJeH89go6avuXn-VznBvw@mail.gmail.com>
 <CA+C76xQBYCpjOtoo1-oFeqVGGDjXDUYi9pXH+p5VWDtUD++Ubg@mail.gmail.com>
 <CABOBwRhbHKgs9jg_5Wq80LSSuz7bL-WEhbejLrzMZB81m8u0fQ@mail.gmail.com>
 <EA6CD602-B426-484D-839A-3E6E62FE42A5@gmail.com>
Message-ID: <1330894178.34573.YahooMailNeo@web125802.mail.ne1.yahoo.com>
Date: Sun, 4 Mar 2012 12:49:38 -0800 (PST)
From: Bob Hall <rfhall3@yahoo.com>
Reply-To: Bob Hall <rfhall3@yahoo.com>
Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX
To: Tomcat Users List <users@tomcat.apache.org>
In-Reply-To: <EA6CD602-B426-484D-839A-3E6E62FE42A5@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

=0A=0A=0A=0A________________________________=0AFrom: Brooke Hedrick <brooke=
.t.hedrick@gmail.com>=0ATo: Tomcat Users List <users@tomcat.apache.org> =0A=
Sent: Sunday, March 4, 2012 12:21 PM=0A=0A> On Mar 4, 2012, at 1:35 PM, Che=
ma <demablogia@gmail.com> wrote:=0A>=A0=0A>>> We use Spring w/ Hibernate as=
 I recall.=A0 Yes, we have talked about that - a=0A>>> ping query.=A0 What =
we don't like about that is now we have a tc ping and app=0A>>> ping.=A0 We=
 have also discussed just changing the tc borrow/ping to do the=0A>>> dual@=
remotedb query as this would test both primary and remote.=A0 We have=0A>>>=
 tested this and it works.=A0 What stinks about this is we only access the=
=0A>>> remotedb 10% of the time.=0A>> =0A>> Well, I don't know how works Hi=
bernate , but I know that you can have=0A>> many SessionFactory=0A>> Can yo=
u define different SessionFactory with different settings , for=0A>> exampl=
e, with different pingQuery value?=0A>> Does Hibernate have a pingQuery set=
ting ?=0A>>=0A>=A0=0A> Even if it does, are we actually losing the close() =
method for the connection pool mbean?=A0 If so, why?=0A>=A0=0A> This change=
 would mean requiring many development teams to change many apps.=A0 I don'=
t see the value of requiring that change - if it is actually the case we ar=
e losing the close() method.=0A=0A=0AHave you tried defining views in the p=
rimary database based on the @otherdb queries?=0A=0A- Bob

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org