Streamsets JDBC producer: Unable to get driver instance
With the same JDBC connection string (with Kerberos): jdbcUrl=jdbc:hive2://f....;principal=hive/...;hive.server2.proxy.user=..., both Hive Metadata and Hive Metastore stages work well, why JDBC producer complains:
JDBC_00 - Cannot connect to specified database: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=jdbc:hive2://f....;principal=hive/...;hive.server2.proxy.user=..."?
What's wrong, how to correct the error? Thanks,
Have you placed JDBC connector jar? And how did you configure it?
@Shruthi, I am also running into this issue with JDBC query consumer as origin, I am providing jdbc url with legacy driver option, but where I have to place JDBC connector jar? and what version? Thanks in advance.
Go to 'Package Manager' and install all the required stage libraries. Here particularly Install 'JDBC' . Then you download JDBC connector jar and place here:- /streamsets-datacollector-3.1.0.0/streamsets-libs/streamsets-datacollector-jdbc-lib/lib.
I am using mysql-connector-java-5.1.44-bin.jar / mariadb-java-client-2.2.0.jar. Restart your streamsets after placing jars