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 Mon, 05 Mar 2012 22:12:48 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

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

iEYEARECAAYFAk9VOmAACgkQ9CaO5/Lv0PCZCACdHN9yBw5h55WbUf5CtgG9hMId
0qcAn2Cf5mDw0dZ/NA3ap+XNNFJiyKC8
=o9Fc
-----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