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]
signature.asc
Description: OpenPGP digital signature
