Backup and restore of Hsqldb database in java code

Question

I am new in Hsqldb database. I want to know how to take backup and restore of Hsqldb database through java code.

Answer 1

Use the BACKUP DATABASE TO command.

Here is a link to the documentation:

HSQLDB System Management Documentation

I haven't tested this, but I imagine it's something along the lines of:

String backup = "BACKUP DATABASE TO " + "'" + filePath + "' BLOCKING";

PreparedStatement preparedStatement = connection.prepareStatement(backup);  

preparedStatement.execute();

You'll want to wrap it in a try-catch block of course.

As far as restoring the db goes, I think you have to perform that while the database is offline using the DbBackupMain application. So you would issue this command at the command line:

java -cp hsqldb.jar org.hsqldb.lib.tar.DbBackupMain --extract tardir/backup.tar dbdir