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.
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 > >
