tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Tue, 06 Mar 2012 00:39:38 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pid,

On 3/5/12 5:55 PM, Pid wrote:
> 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...

There's nothing like chasing your tail for a few days on a mailing list.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk9VXMoACgkQ9CaO5/Lv0PBUWgCgrCozrsjfedR5NkZ6sy4pqs02
OcUAoJLuKRPTWnkssK59SgUjsMFRESts
=BcMC
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message