aspose file tools*
The moose likes Tomcat and the fly likes JDBC/JNDI Database Restore Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBC/JNDI Database Restore" Watch "JDBC/JNDI Database Restore" New topic
Author

JDBC/JNDI Database Restore

Jason Talarczyk
Greenhorn

Joined: Apr 30, 2004
Posts: 4
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC/JNDI Database Restore