Having an SQLite database file, I do the equivalent of MySQL's load data local infile by doing
sqlite3 myDatabase
create table myTable (a, b, c);
.separator ','
.import myFile myTable
My Java code:
connection = DriverManager.getConnection(DATABASE, USERNAME, PASSWORD);
query = "import enswPaldo.txt paldo";
statement = connection.prepareStatement(query);
statement.executeUpdate();
connection.close();
complains that
java.sql.SQLException: near "import": syntax error
java.sql.SQLException: near "import": syntax error
at org.sqlite.DB.throwex(DB.java:288)
at org.sqlite.NativeDB.prepare(Native Method)
at org.sqlite.DB.prepare(DB.java:114)
at org.sqlite.PrepStmt.<init>(PrepStmt.java:37)
at org.sqlite.Conn.prepareStatement(Conn.java:231)
at org.sqlite.Conn.prepareStatement(Conn.java:224)
at org.sqlite.Conn.prepareStatement(Conn.java:213)
at org.kamusi.Editor.flushDatabase(Editor.java:280)
at org.kamusi.Restorer$RestorerThread.update(Restorer.java:187)
at org.kamusi.Restorer$RestorerThread.run(Restorer.java:206)
Any help?