tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felix Schumacher <felix.schumac...@internetallee.de>
Subject RE: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Sun, 04 Mar 2012 10:42:35 GMT
Am Samstag, den 03.03.2012, 11:50 -0600 schrieb Brooke Hedrick:
> On Mar 3, 2012 11:48 AM, "Brooke Hedrick" <brooke.t.hedrick@gmail.com>
> wrote:
> >
> >
> > On Mar 3, 2012 11:35 AM, "Caldarale, Charles R" <
> Chuck.Caldarale@unisys.com> wrote:
> > >
> > > > From: Brooke Hedrick [mailto:brooke.t.hedrick@gmail.com]
> > > > Subject: Re: [Tomcat JDBC Pool] Close pooled connections via JMX
> > >
> > > > > Do you have testOnBorrow="true" and a validationQuery="SELECT 1 FROM
> > > > > DUAL" configured?
> > > > >
> > > > > This should suffice to ensure each connection is valid before use.
> > >
> > > > That approach doesn't work when the application uses symlinks to get
> to
> > > > data on other Oracle servers.
> > >
> > > That makes no sense to me; please explain how links in the file system
> affect DB connections over the network.
> > >
> >
> > Chuck, I used the wrong word.  I should have said 'database links'.  You
> will see things like: select * emp@otherdb.  Where @otherdb is typically an
> entry that you would find in a tnsnames.ora.
Have you tried to construct a validationQuery, which checks for such
database links? You could create simple tables in each of your
referenced databases and do a select on them. Possibly using a join, if
there are more than one databases referenced.

If you are using tomcat-jdbc pool, you can do a testWhileIdle instead of
testOnBorrow and have it check the connection(s) in the background at an
interval, that you can specify. So that it is not to bad, if your
validationQuery is a bit more expensive.

Regards
 Felix
> 
> Before you correct me, yes, I left out the FROM between the * and emp.
> >
> > >  - Chuck
> > >
> > >
> > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE
> PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If
> you received this in error, please contact the sender and delete the e-mail
> and its attachments from all computers.
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > > For additional commands, e-mail: users-help@tomcat.apache.org
> > >



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


Mime
View raw message