How can I make use of Hibernate to perform a backup on my sqlite database? The output should ideally be in the form of an SQL script, similar to the .dump sqlite utility.
Also, to perform a restore of the sql script programmatically as well.
Add a comment
|
3 Answers
I have found an alternative to do this, and it is by invoking the sqlite3 command line shell via Java. Here's my sample solution
public class Test {
public static void main(String args[]) {
try {
String line;
Process p = Runtime.getRuntime().exec("cmd /c start /b sqlite3 db.sqlite .dump > dump.txt");
BufferedReader bri = new BufferedReader
(new InputStreamReader(p.getInputStream()));
BufferedReader bre = new BufferedReader
(new InputStreamReader(p.getErrorStream()));
while ((line = bri.readLine()) != null) {
System.out.println(line);
}
bri.close();
while ((line = bre.readLine()) != null) {
System.out.println(line);
}
bre.close();
p.waitFor();
System.out.println("Done.");
}
catch (Exception err) {
err.printStackTrace();
}
}
}
1 Comment
Java Man
but the generated file does not exist "DROP TABLE IF EXISTS" statement? then how to add this statement in the generated sql?
To my knowledge there is no mechanism in Java to do an SQL dump. But you could create a program to do it quite easily by:
- Iterating through a list of your entities - built up using reflection perhaps.
- Get you list of column names using JDBC direct (cant really do it with hibernate).
- Then creating a select query you pass the Entity name into as a parameter.
- Iterate over the result set and push the data via a formatted string to a file.
You can of course add in a DROP IF EXISTS before each CREATE if required.
Comments
For Unix Flavor cmd not working so used this for ubuntu.
try
{
String line;
Runtime rt = Runtime.getRuntime();
Process p = rt.exec(new String[]{"/bin/sh", "-c", "sqlite3 /home/ubuntu/test.sqlite .dump > /home/ubuntu/output.sql"});
BufferedReader bri = new BufferedReader(new InputStreamReader(p.getInputStream()));
BufferedReader bre = new BufferedReader(new InputStreamReader(p.getErrorStream()));
while ((line = bri.readLine()) != null) {
System.out.println(line);
}
bri.close();
while ((line = bre.readLine()) != null) {
System.out.println(line);
}
bre.close();
p.waitFor();
System.out.println("Done.");
} catch (Exception err) {
err.printStackTrace();
}