prestodb/presto · error · SQLException

Unrecognized connection property '%s'

Error message

Unrecognized connection property '%s'

What it means

validateConnectionProperties checks every key of the merged connection properties against the set of known property names in ConnectionProperties. It fires when a property key (from the URL query or the driver Properties argument) is not a recognized Presto JDBC option — typically a typo like 'users' instead of 'user'.

Source

Thrown at presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoDriverUri.java:457

        setProperties(result, defaults);
        setProperties(result, urlProperties);
        setProperties(result, suppliedProperties);
        return result;
    }

    private static void setProperties(Properties properties, Map<String, String> values)
    {
        for (Entry<String, String> entry : values.entrySet()) {
            properties.setProperty(entry.getKey(), entry.getValue());
        }
    }

    private static void validateConnectionProperties(Properties connectionProperties)
            throws SQLException
    {
        for (String propertyName : connectionProperties.stringPropertyNames()) {
            if (ConnectionProperties.forKey(propertyName) == null) {
                throw new SQLException(format("Unrecognized connection property '%s'", propertyName));
            }
        }

        for (ConnectionProperty<?> property : ConnectionProperties.allProperties()) {
            property.validate(connectionProperties);
        }
    }

    @VisibleForTesting
    static void setRedirectHandler(RedirectHandler handler)
    {
        REDIRECT_HANDLER.set(requireNonNull(handler, "handler is null"));
    }
}

View on GitHub (pinned to 55bb57d202)

Solutions

1. Check the property name against the documented Presto JDBC connection properties and fix the typo
2. Remove the unknown property if it was not intended for Presto
3. Upgrade the driver version if the property was added in a newer release

When it happens

Trigger: Thrown at presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoDriverUri.java:457 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/e3f38b77b4260c93. Report an issue: GitHub.