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