I have a web application running on one server that maintains
multiple connection pools to a varitey of InterBase databases on
another server. The databases need to be restored nightly to
contain the most up to date information. I am looking for a way
to restore those databases nightly without having to shut down
Tomcat. I have already attempted the following:
1. Shutdown the databases one by one and attempt to restore.
Errors out stating that the database may be in use.
2. Restart the InterBase sever and restore the databases. This
works but then it causes some inital connection errors on the
application side.
3. Create a dummy user, shutdown the database, and attempt to
restore using the sysdba account. Datbase in use errors still occur.
Essentially I am looking for a way to flush all of the connections that
Tomcat is currently holding.
Any help would be greatly appreciated.
Thanks in advance.
