Retrieving image from sqlite database java

Question

Trying to retrieve stored images from sqlite database but don't seem to be having any luck. My code:

int i = 0;
while (resultSet.next()) {
    InputStream in = resultSet.getBinaryStream(1);
    OutputStream f = new FileOutputStream(new File("PeoplesInfo"+i+".jpg"));
    i++;
    int c = 0;
    while ((c = in.read()) > -1) {
        f.write(c);
    }
    f.close();
    in.close();
}

The errors which i'm getting are:

java.sql.SQLException: not implemented by SQLite JDBC driver
at org.sqlite.Unused.unused(Unused.java:29)
at org.sqlite.Unused.getBinaryStream(Unused.java:92)
at Database.main(Database.java:50)

Bishan · Accepted Answer · 2014-07-17 14:58:04Z

2

The SQLite JDBC implementation you're using doesn't implement getBinaryStream.

You'll need to use the getBytes method instead.

answered Jul 17, 2014 at 14:58

Bishan

15.9k54 gold badges175 silver badges270 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieving image from sqlite database java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related