On 3/3/2012 10:50 AM, Brooke Hedrick wrote:
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.
still doesn't make sense. if you need another DB validated, use another
validation query.
sounds like one is creating a problem here rather than detecting one
- 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
