Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import Data into SQLite

843859May 21 2010 — edited Feb 18 2011
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2011
Added on May 21 2010
3 comments
2,200 views