Ask Your Question
0

Streamsets JDBC producer: Unable to get driver instance

asked 2018-07-12 10:21:15 -0500

greatcanada gravatar image

updated 2018-07-18 08:54:40 -0500

metadaddy gravatar image

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,

edit retag flag offensive close merge delete

Comments

Have you placed JDBC connector jar? And how did you configure it?

Shruthi gravatar imageShruthi ( 2018-07-13 00:00:43 -0500 )edit

@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.

newbee2018 gravatar imagenewbee2018 ( 2018-07-17 08:43:23 -0500 )edit

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.

Shruthi gravatar imageShruthi ( 2018-07-18 00:12:20 -0500 )edit

I am using mysql-connector-java-5.1.44-bin.jar / mariadb-java-client-2.2.0.jar. Restart your streamsets after placing jars

Shruthi gravatar imageShruthi ( 2018-07-18 00:12:32 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
2

answered 2018-07-13 00:43:10 -0500

peter_f gravatar image

updated 2018-07-13 00:44:29 -0500

If you allready placed the. jar, it is possible that you have to configure the driver class name in the legacy tab in addition.

e.g. com.mysql.jdbc.Driver

I had to add that when using a mysql driver lower than version 8.

Best Peter

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-07-12 10:21:15 -0500

Seen: 137 times

Last updated: Jul 18