>> >> > That approach doesn't work when the application uses symlinks to get to >> > data on other Oracle servers.
Right. With dblinks, it's the RDBMS who opens/closes a session against the remote server, via dblinks I guess that when you say "our Oracle database has to be restarted", you *only* restart the remote server , right ? One question : do you use any kind of ORM framework ? Some of them (myBatis , for example ) allow you to configure different schemas with different pingQuery settings. So, you could define the remote queries into a particular schema with a pingQuery like "SELECT 1 FROM DUAL@REMOTEDB" --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org