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
{{ message }}
Repository navigation
JDBC: ResultSet.getObject(int, java.util.Map.class) fails for MAP column #901
For a MAP column, DuckDB JDBC reports java.util.LinkedHashMap as the column class through ResultSetMetaData, but ResultSet.getObject(..., Map.class) fails with a conversion error.
Reproduction
Create a table containing a MAP column:
CREATETABLEtest_table (
map_col MAP(VARCHAR, INTEGER) NOT NULL
);
Execute a simple query:
SELECT map_col FROM test_table;
The ResultSetMetaData reports:
Metadata
Value
getColumnName()
map_col
getColumnTypeName()
MAP(VARCHAR, INTEGER)
getColumnType()
1111 (java.sql.Types.OTHER)
getColumnClassName()
java.util.LinkedHashMap
However, attempting to retrieve the value using the JDBC typed getter:
Map<?, ?> value = resultSet.getObject(1, Map.class);
fails with:
java.sql.SQLException: Can't convert value to interface java.util.Map, SQL type: MAP
Environment
DuckDB JDBC: 1.5.6.0
SQL type: MAP(VARCHAR, INTEGER)
Java type reported by metadata: java.util.LinkedHashMap
changed the title [-]JDBC: ResultSet.getObject(int, class) fails for MAP as java.util.Map[/-][+]JDBC: ResultSet.getObject(int, java.util.Map.class) fails for MAP column [/+]on Oct 8, 2026
Activity
[-]JDBC: ResultSet.getObject(int, class) fails for MAP as java.util.Map[/-][+]JDBC: ResultSet.getObject(int, java.util.Map.class) fails for MAP column [/+]ResultSet enhancements
staticlibs commentedon Oct 20, 2026
Closing as fixed in #942.
ResultSet enhancements (2.0)