Ask Your Question
1

Error: JDBC- Failed to initialize connection

asked 2017-10-17 01:12:51 -0500

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to extract a table from mysql to HDFS. I use "JDBC Multitable" as origin. When i run the pipeline i get following error,

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=jdbc:mysql://localhost:3306/homlot

Can anyone help to fix this error...Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2017-10-17 10:40:55 -0500

jeff gravatar image

updated 2018-06-13 13:16:26 -0500

metadaddy gravatar image

Did you install the MySQL JDBC driver as per the instructions in the docs?

There are also troubleshooting steps in the documentation - you can usually identify the problem by working through the steps there.

edit flag offensive delete link more

Comments

Actually i fixed that issue by updating mysql connector jar. Thanks for your response Jeff...

Shruthi gravatar imageShruthi ( 2017-10-19 23:52:41 -0500 )edit

How did you update it? I have the same error

Issantv@gmail.com gravatar imageIssantv@gmail.com ( 2018-06-13 13:12:48 -0500 )edit

I just added a link to the troubleshooting steps to the answer.

metadaddy gravatar imagemetadaddy ( 2018-06-13 13:16:50 -0500 )edit

my JDBC driver is in the directory ok, /home/training/streamsets-datacollector-3.3.0/streamsets-libs/streamsets-datacollector-jdbc-lib/lib/streamsets-datacollector-jdbc-lib-3.3.0.jar ... but but the same error keeps coming up

Issantv@gmail.com gravatar imageIssantv@gmail.com ( 2018-06-13 14:01:22 -0500 )edit

this msg ... JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=jdbc:mysql://localhost:3306/streamsets

Issantv@gmail.com gravatar imageIssantv@gmail.com ( 2018-06-13 14:01:36 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-17 01:12:51 -0500

Seen: 1,659 times

Last updated: Jun 13