topic Re: ERROR: Error retrieving DatabaseMetaData: java.sql.SQLFeatureNotSupportedException: getTypeInfo in Administration and Deployment

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

AhmedAl_Attar — Wed, 21 Feb 2024 19:38:13 GMT

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"

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

SASKiwi — Fri, 23 Feb 2024 00:01:40 GMT

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.

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

AhmedAl_Attar — Fri, 23 Feb 2024 12:42:14 GMT

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

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

AhmedAl_Attar — Fri, 23 Feb 2024 14:20:23 GMT

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

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

JuanS_OCS — Thu, 19 Jun 2025 15:36:17 GMT

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";

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

AhmedAl_Attar — Thu, 19 Jun 2025 19:55:37 GMT

@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 😉

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

JuanS_OCS — Thu, 19 Jun 2025 20:15:49 GMT

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!

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

AhmedAl_Attar — Thu, 19 Jun 2025 22:02:10 GMT

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 😉