Calling ResultSet.getBlob() results in an error

[udittmer]

even though "ResultSet.getMetaData().getColumnTypeName(1) = BLOB"

The issue surfaced when using SquirrelJDBC, but the folks over there think it's a driver issue; see this ticket for the details.

ClassCastException.sqlite.zip

[gotson]

Is this still an issue ? Can you provide more details ?

[udittmer]

Yes, this still happens with sqlite-jdbc-3.36.0.3.jar

[gotson]

as indicated in #622 you can use getBytes to retrieve the whole blob as a byte[].

Implementing getBlob is not required in the JDBC spec, so SquirrelJDBC should be able to catch that SQLFeatureNotSupportedException and try a getBytes instead.

[gotson]

Closing this in favor of #622