[HIVE-6712] HS2 JDBC driver is inconsistent w.r.t. auto commit

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.0
• Fix Version/s: 2.0.0
• Labels: jdbc
• Hadoop Flags: Incompatible change

Release Note

Changes the behavior of setAutoCommit to allow setAutoCommit(true) to succeed silently and setAutoCommit(false) to throw an exception and fail, as all Hive transactions automatically commit and hive does not yet support manual transactions (see https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations).

• Assignee: David McWhorter
• Reporter: Xuefu Zhang
• Created: 20/Mar/14 20:18
• Updated: 02/May/16 15:19
• Resolved: 02/May/16 15:19

Description

I see an inconsistency in HS2 JDBC driver code:

  @Override
  public void setAutoCommit(boolean autoCommit) throws SQLException {
    if (autoCommit) {
      throw new SQLException("enabling autocommit is not supported");
    }
  }

From above, it seems that auto commit is not supported. However,

  @Override
  public boolean getAutoCommit() throws SQLException {
    return true;
  }

Issue Links

• duplicates: HIVE-6705 hive jdbc can not used by jmeter, because of unsupported auto commit feature
• duplicates: HIVE-11293 HiveConnection.setAutoCommit(true) throws exception