[BACKLOG-365] Unable to create a database table data source against Apache Hadoop

Handle case with old shims not having hive2 driver.
Detect pentaho hive's error message in setAutoCommit.
@brosander this is for old shims having pentaho's hive and in case of true, no exception will be thrown (https://github.com/pentaho/hive/blob/0.7.0-pentaho/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveConnection.java#L563) and this will go away once we will no longer support hadoop-20/hdp13. Other cases where apache's hive is used are covered by "Method not supported".