Hi
I use SQLite in a project of mine. I want to strore files in the
database. I tried to do it something like this. See Code section below.
I get an error that say it is not implementet. See Message section
below.
I use this driver
Class.forName("org.sqlite.JDBC");
The Jar files name is "sqlitejdbc-v056.jar".
So my question is. How do I store files in the database from Java? Is
it possible. I hope so. I don't want to change database.
Is there some other way to do this that work?
/Andreas
Code:
File file = new File("TestFile.txt");
FileInputStream stream = new FileInputStream(file);
PreparedStatement prep = dbConn.prepareStatement("UPDATE FileList SET
FileName = ?, File = ? WHERE FileList = ?;");
prep.setString(1, "TestFile.txt");
prep.setBinaryStream(2, stream, (int)file.length());
prep.setInt(3, 1);
prep.execute();
prep.close();
Message:
java.sql.SQLException: not implemented by SQLite JDBC driver
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
