tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pid <...@pidster.com>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Mon, 05 Mar 2012 22:55:12 GMT
On 05/03/2012 22:12, Christopher Schultz wrote:
> Chema,
> 
> On 3/5/12 4:06 PM, Chema wrote:
>>> No if the connection has been reset by the instance. The query
>>> will result in a SQLException. You have to close the connection
>>> and open a new one. The query works on an open connection only.
>>> That's the point. See the second paragraph of this [1].
>>>
> 
>> But the problem was when you restart the remote database , not the 
>> local database. In this case, SELECT 1 FROM DUAL works ( doesn't
>> return a SQL exception ). But , when you execute after the query
>> "SELEC * FROM TABLE@remotedb", then fails , was this the problem,
>> right ?
> 
> Correct.
> 
> Note that Michael was having a problem that was solved by using a
> validationQuery.  Brooke is the one with an elaborate two-tier
> database with these links that survive SELECT 1 FROM DUAL but not
> SELECT 1 FROM TABLE@remotedb.

To be fair, between that & the discussion about 'losing the close
method' it's no wonder people got confused...


p



-- 

[key:62590808]


Mime
View raw message