[IGNITE-13000] Connection.prepareStatement(String,int) always throws UnsupportedException ignoring 'autoGeneratedKeys' parameter

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.8
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Pavel Vinokurov
• Created: 12/May/20 09:10
• Updated: 02/Apr/21 14:07

Description

Below the method call throwing Exception.

conn.prepareStatement(query, Statement.NO_GENERATED_KEYS)

But there is should be the same result as for:

conn.prepareStatement(query)

The possible fix:

@Override 
public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException {
    ensureNotClosed();
    if(autoGeneratedKeys == Statement.RETURN_GENERATED_KEYS)
        throw new SQLFeatureNotSupportedException("Auto generated keys are not supported.");
    return prepareStatement(sql);
}