prestodb/presto · error · SQLFeatureNotSupportedException

updateClob

Error message

updateClob

What it means

updateClob in PrestoResultSet always throws SQLFeatureNotSupportedException: result sets produced by Presto are read-only and java.sql.Clob handles are not supported, so in-place Clob updates cannot be performed.

Source

Thrown at presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoResultSet.java:1257

    @Override
    public void updateBlob(int columnIndex, Blob x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateBlob");
    }

    @Override
    public void updateBlob(String columnLabel, Blob x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateBlob");
    }

    @Override
    public void updateClob(int columnIndex, Clob x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateClob");
    }

    @Override
    public void updateClob(String columnLabel, Clob x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateClob");
    }

    @Override
    public void updateArray(int columnIndex, Array x)
            throws SQLException
    {
        throw new SQLFeatureNotSupportedException("updateArray");
    }

    @Override
    public void updateArray(String columnLabel, Array x)

View on GitHub (pinned to 55bb57d202)

Solutions

1. Issue an UPDATE statement via Statement/PreparedStatement instead of updating through the result set
2. Fetch Clob content as a String with getString and manage updates in application code
3. Do not request updatable result set semantics from the Presto driver

When it happens

Trigger: Thrown at presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoResultSet.java:1257 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of prestodb/presto@55bb57d202 (2026-09-04). Data as JSON: /api/errors/c4813b3b4b1ab8e8. Report an issue: GitHub.