Geek Answers Handbook

Restore Apache Database to Database

I backed up my database in memory using the code below:

public static void backUpDatabase(Connection conn)throws SQLException { String backupdirectory ="c:/mybackups/"+JCalendar.getToday(); CallableStatement cs = conn.prepareCall("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)"); cs.setString(1, backupdirectory); cs.execute(); cs.close(); System.out.println("backed up database to "+backupdirectory); }

Now I want to restore the database by creating an in-memory database from a previous backup. How can I do it?

Thanks.

+4
source share
2 answers

As far as I know, the usual restore-backup mechanisms will work very well to restore the database in memory. Therefore, use the restoreFrom clause on the URL of your connection, as described here: http://db.apache.org/derby/docs/10.9/adminguide/tadminhubbkup44.html

+3
source

The fastest way I know about:

First use shutdown=true :

 boolean gotSQLExc = false; try { DriverManager.getConnection("jdbc:derby:memory:testdb;shutdown=true"); } catch (SQLException se) { if ( se.getSQLState().equals("08006") ) System.out.println("Database shut down normally"); else System.out.println("Database did not shut down normally") }

Then restoreFrom=

  Connection connection = DriverManager.getConnection("jdbc:derby:memory:testdb;restoreFrom=path/to/backup/file"); connection.close();

A db containing ~ 300 tables with some sample data recovered in ~ 150 ms on my dev machine this way.

This is really useful for testing junit integration where fast, fast db recovery is required. Depending on your installation, you may need to do additional additional work between tests, for example, if you use the c3p0 connection pool, you need to get all the connections from C3P0Registry and call hardReset () after this recovery. On the other hand, nothing needs to be done with some other pools.

+3
source

More articles:


All Articles