samedi 20 décembre 2014

SQLite .dump Java example using Windows

I am new to SQLite in Java on Windows, and am trying to use the .dump statement. Everything is working with the database except the .dump. The statement I have is:



try {
stmt = c.createStatement();
sql = "test.db .dump > temp.sql";
stmt.executeUpdate(sql);
stmt.close();
c.close();


That statement is generating the following assertion


java.sql.SQLException: near "test": syntax error


However, test.db is the name of my database. So an example would be very helpful or advice on proper syntax. I have found many examples for ubuntu but non on a windows platform + Eclipse.


Thanks


Aucun commentaire:

Enregistrer un commentaire