New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not implemented BLOB #135

Closed
donat-mueller opened this Issue Jul 8, 2016 · 4 comments

Comments

Projects
None yet
4 participants
@donat-mueller

donat-mueller commented Jul 8, 2016

Hi,
I try to retrieve an image as blob and get the message below:
Is this a bug or really a not supported jdbc feature ?

java.sql.SQLException: not implemented by SQLite JDBC driver
at org.sqlite.jdbc4.JDBC4ResultSet.unused(JDBC4ResultSet.java:320)
at org.sqlite.jdbc4.JDBC4ResultSet.getBlob(JDBC4ResultSet.java:343)

@gitblit

This comment has been minimized.

Show comment
Hide comment
@gitblit

gitblit Jul 8, 2016

Collaborator

It turns out this is currently not implemented, so the exception is the truth. This driver does not implement a lot of the JDBC spec.

Collaborator

gitblit commented Jul 8, 2016

It turns out this is currently not implemented, so the exception is the truth. This driver does not implement a lot of the JDBC spec.

@donat-mueller

This comment has been minimized.

Show comment
Hide comment
@donat-mueller

donat-mueller Jul 8, 2016

Thx a lot for the fast reply

donat-mueller commented Jul 8, 2016

Thx a lot for the fast reply

@rishisharan

This comment has been minimized.

Show comment
Hide comment
@rishisharan

rishisharan Dec 12, 2017

How to fix this issue?

rishisharan commented Dec 12, 2017

How to fix this issue?

@xerial

This comment has been minimized.

Show comment
Hide comment
@xerial

xerial Dec 13, 2017

Owner

sqlite has no support of reading BLOB in streaming manner, so the implementation will be anyway reading the entire data into memory. Using getByte is sufficient.

Owner

xerial commented Dec 13, 2017

sqlite has no support of reading BLOB in streaming manner, so the implementation will be anyway reading the entire data into memory. Using getByte is sufficient.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment