[CALCITE-585] Avatica JDBC methods should throw SQLFeatureNotSupportedException

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.0-incubating
• Assignee: Julian Hyde
• Reporter: Ng Jiunn Jye
• Created: 04/Feb/15 07:20
• Updated: 26/Jul/17 19:44
• Resolved: 17/Apr/15 19:41

Description

The unsupported JDBC method are throwing UnsupportedOperationException.

This cause calcite jdbc client program fail to catch the exception and goes to unhandled exception routine.

For example
AvaticaStatement.java
public boolean getMoreResults() throws SQLException

{ throw new UnsupportedOperationException(); }

The expected exception for this is SQLFeatureNotSupportedException (a subclass of SQLException).

Issue Links

• relates to: DRILL-2769 many(?) JDBC methods throw non-SQLException exceptions (e.g., UnsupportedOperationException, RuntimeException)
• relates to: CALCITE-1902 ResultSet.previous() throws UnsupportedOperationException, but should throw SQLFeatureNotSupportedException