[BACKLOG-365][5.2] 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.