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.