Am Samstag, den 03.03.2012, 11:50 -0600 schrieb Brooke Hedrick: > On Mar 3, 2012 11:48 AM, "Brooke Hedrick" <brooke.t.hedr...@gmail.com> > wrote: > > > > > > On Mar 3, 2012 11:35 AM, "Caldarale, Charles R" < > chuck.caldar...@unisys.com> wrote: > > > > > > > From: Brooke Hedrick [mailto:brooke.t.hedr...@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-unsubscr...@tomcat.apache.org > > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
