cannot save image as blob to sqlite

Question

I am using SQLite and I cannot save a image to the database. This is my code :

File file = new File(url);
  try {
    fis = new FileInputStream(file);
  } catch (FileNotFoundException e) {}
fileLenght = (int) file.length();

stat.executeUpdate("create table "+tableName+" (id int,name String ,image Blob, features String);");
prep = conn.prepareStatement("insert into "+tableName+" values (?, ?, ?, ?);");
prep.setBinaryStream(3, fis, fileLenght);

This is the error i am getting:

java.sql.SQLException: not implemented by SQLite JDBC driver
  at org.sqlite.Unused.unused(Unused.java:29)
  at org.sqlite.Unused.setBinaryStream(Unused.java:58)

I am using the following jar : sqlitejdbc-v056.jar.

Any ideas? Thanks

Answer 1

The SQLite JDBC implementation you're using doesn't implement setBinaryStream (hence the accurate not implemented by SQLite JDBC driver error message).

You'll need to use the setBytes method instead.