This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC/JNDI Database Restore

 
Jason Talarczyk
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic