tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Filip Hanik - Dev Lists <devli...@hanik.com>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Sat, 10 Mar 2012 19:14:16 GMT
On 3/3/2012 10:50 AM, Brooke Hedrick wrote:
> 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.
>
> 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-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