ERROR: Error retrieving DatabaseMetaData: java.sql.SQLFeatureNotSupportedException: getTypeInfo

[AhmedAl_Attar]

I'm wondering if anyone has experienced this in their SAS/ACCESS Interface to JDBC?

Trying to submit the following JDBC engine Libname statement

libname x JDBC driverclass="org.duckdb.DuckDBDriver" URL="jdbc:duckdb::memory:" classpath="/tmp/duckdb_jdbc-0.10.0.jar";

and getting this Error

ERROR: Error retrieving DatabaseMetaData: java.sql.SQLFeatureNotSupportedException: getTypeInfo
ERROR: Error in the LIBNAME statement.

Note: According to their Web site, "DuckDB’s JDBC API implements the main parts of the standard Java Database Connectivity (JDBC) API, version 4.1"

[SASKiwi]

I can find no reference to DuckDB and JDBC on the SAS Support site, nor the error encountered. I'd suggest tracking to Tech Support and posting the response here.

[AhmedAl_Attar]

Hi @SASKiwi 

That's exactly what I did. I have an active SAS Tech Support Track and, I opened an issue in the DuckDB's GitHub repo.

I posted to the forum to see if anyone has experienced similar issue with other ODBC/JDBC drivers and while using the SAS/ACCESS Interface to ODBC/JDBC

Thanks

[AhmedAl_Attar]

If anyone interested, here is the link to the DuckDB's GitHub issue
https://github.com/duckdb/duckdb/issues/10805