This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBC/JNDI Database Restore" Watch "JDBC/JNDI Database Restore" New topic

JDBC/JNDI Database Restore

Jason Talarczyk

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:
subject: JDBC/JNDI Database Restore
It's not a secret anymore!