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