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

[JuanS_OCS · Accepted solution]

FYI, I see it is resolved with the latest version 1.3.1.0

83         libname x JDBC driverclass="org.duckdb.DuckDBDriver" URL="jdbc:duckdb::memory:"
83       ! classpath="/data-drivers/jdbc/duckdb_jdbc-1.3.1.0.jar";
NOTE: Libref X was successfully assigned as follows: 
      Engine:        JDBC 
      Physical Name: jdbc:duckdb::memory:
84         *libname x JDBC driverclass="org.duckdb.DuckDBDriver" URL="jdbc:duckdb::memory:"
84       ! classpath="/data/duckdb_jdbc-1.3.1.0.jar";

[AhmedAl_Attar]

@JuanS_OCS 

Just as a bonus, I managed to successfully connect SAS 9.4 M8 to DuckDB via SAS/ACCESS Interface to ODBC on Linux (RHEL 8.1) using DuckDB's 1.3.0.0 ODBC driver for Linux  😉

[JuanS_OCS]

Excellent, thanks! I am planning on testing all the options and figure out the differences, especially in basic performance 😉 I am curious about your progress too!

[AhmedAl_Attar]

I'll report back once I have some working code samples.

Note: I have had success with using the DuckDB CLI from SAS 9.4 via the xcmd interface and executed *.sql script that was dynamically modified by SAS. but Data Transfer between the two software was a bit cloggy, as I had to export to CSV from DuckDB and Import it in SAS to generate SAS data set(s). 

But now, using JDBC/ODBC would allow for better integration specially specially with using Explicit DuckDB SQL Statements 😉