-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
