[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.
@pavel-sakun what if they set autocommit to true? should we use a startsWith?