You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
0
getBlob
null
java.sql.SQLFeatureNotSupportedException: getBlob
at org.duckdb.DuckDBVector.getBlob(DuckDBVector.java:284)
at org.duckdb.DuckDBResultSet.getBlob(DuckDBResultSet.java:514)
at org.jooq.testscripts.JDBC.main(JDBC.java:48)
This is because the WKB_BLOB type isn't supported by org.duckdb.DuckDBColumnType, and thus org.duckdb.DuckDBResultSetMetaData.TypeNameToType(String) can't look up the type name.
A workaround is to cast as ordinary BLOB or use a different function, such as st_ashexwkb:
"with the type WKB_BLOB (which can be cast to BLOB) instead of GEOMETRY"
This topic isn't documented very thoroughly, but I think it's reasonable to read between the lines that WKB_BLOB is safe to be treated as an ordinary BLOB when reading the value.
The text was updated successfully, but these errors were encountered:
Run this program:
It errors as follows:
This is because the
WKB_BLOB
type isn't supported byorg.duckdb.DuckDBColumnType
, and thusorg.duckdb.DuckDBResultSetMetaData.TypeNameToType(String)
can't look up the type name.A workaround is to cast as ordinary
BLOB
or use a different function, such asst_ashexwkb
:This prints:
According to the docs:
https://duckdb.org/docs/extensions/spatial
This topic isn't documented very thoroughly, but I think it's reasonable to read between the lines that
WKB_BLOB
is safe to be treated as an ordinaryBLOB
when reading the value.The text was updated successfully, but these errors were encountered: