update avatica lib to version 1.12.0 to have a Dremio JDBC more compliant

[egwada]

It was impossible to connect Dremio to Knowage, an open source business intelligence platform through JDBC bridge. The main cause was the method com.dremio.jdbc.impl.isValid() was unsupported.

It appeared that the Avatica version 1.12.0 had some improvements which supports some methods needed to allow the connection between Dremio and Knowage.

During the compilation phase I got those errors and made the needed enhancements:

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.2:compile (default-compile) on project dremio-client-jdbc: Compilation failure: Compilation failure: [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioConnectionImpl.java:[403,28] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioConnectionImpl.java:[682,27] unreported exception java.sql.SQLException; must be caught or declared to be thrown

[ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioStatementImpl.java:[210,33] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioStatementImpl.java:[297,35] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioStatementImpl.java:[315,30] unreported exception java.sql.SQLException; must be caught or declared to be thrown

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.2:compile (default-compile) on project dremio-client-jdbc: Compilation failure: Compilation failure: [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioPreparedStatementImpl.java:[93,54] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioPreparedStatementImpl.java:[173,33] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioPreparedStatementImpl.java:[278,35] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioPreparedStatementImpl.java:[296,30] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioPreparedStatementImpl.java:[341,21] unreported exception java.sql.SQLException; must be caught or declared to be thrown

[ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioPreparedStatementImpl.java:[587,29] unreported exception java.sql.SQLException; must be caught or declared to be thrown

[ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioResultSetImpl.java:[92,10] unreported exception java.sql.SQLException; must be caught or declared to be thrown [ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioResultSetImpl.java:[93,64] unreported exception java.sql.SQLException; must be caught or declared to be thrown

[ERROR] /u01/Dev/dremio/project/dremio-oss/client/jdbc/src/main/java/com/dremio/jdbc/impl/DremioJdbc41Factory.java:[180,12] unreported exception java.sql.SQLException; must be caught or declared to be thrown

Because now the laste Avatica version is 1.15.0 (release date 13 May 2019) perhaps it would be more interesting to use that version to have a suitabler Dremio JDBC.