apache/shardingsphere · error · UnsupportedDataTypeConversionException

0

0

Error message

Unsupported conversion data type '%s' for value '%s'.

What it means

Error "Unsupported conversion data type '%s' for value '%s'." thrown in apache/shardingsphere.

Source

Thrown at infra/executor/src/main/java/org/apache/shardingsphere/infra/executor/sql/execute/result/query/impl/driver/jdbc/type/stream/JDBCStreamQueryResult.java:141

        }
        if (ZonedDateTime.class == type) {
            return resultSet.getObject(columnIndex, type);
        }
        return resultSet.getObject(columnIndex);
    }
    
    @Override
    public Object getCalendarValue(final int columnIndex, final Class<?> type, @SuppressWarnings("UseOfObsoleteDateTimeApi") final Calendar calendar) throws SQLException {
        if (Date.class == type) {
            return resultSet.getDate(columnIndex, calendar);
        }
        if (Time.class == type) {
            return resultSet.getTime(columnIndex, calendar);
        }
        if (Timestamp.class == type) {
            return resultSet.getTimestamp(columnIndex, calendar);
        }
        throw new UnsupportedDataTypeConversionException(type, calendar).toSQLException();
    }
    
    @SuppressWarnings("deprecation")
    @Override
    public InputStream getInputStream(final int columnIndex, final String type) throws SQLException {
        switch (type) {
            case "Ascii":
                return resultSet.getAsciiStream(columnIndex);
            case "Unicode":
                return resultSet.getUnicodeStream(columnIndex);
            case "Binary":
                return resultSet.getBinaryStream(columnIndex);
            default:
                throw new UnsupportedStreamCharsetConversionException(type).toSQLException();
        }
    }
    
    @Override

View on GitHub (pinned to e952770a21)

Solutions

1. Request the column value with a supported JDBC type mapping.
2. Cast or convert the column in SQL to a type ShardingSphere can stream.
3. Avoid selecting unsupported large-object or vendor-specific types through this path.

When it happens

Trigger: JDBCStreamQueryResult is asked to convert a streamed column value to a data type it does not support.

Common situations: Reading BLOB/CLOB or vendor-specific columns as an incompatible Java type via the stream query result.

AI-assisted analysis of apache/shardingsphere@e952770a21 (2026-08-14). Data as JSON: /api/errors/e83ab65172277ee3. Report an issue: GitHub.