Unable to connect to My Sql Database

Hi @mr_manii - Thank you for reaching out to the StreamSets Community. 

The error indicate that you not have the proper driver jar available to connect to the Mysql server. Could you please download the jar version 8.0.30 from https://jar-download.com/artifacts/mysql/mysql-connector-java and upload the jar by navigating to Setup» Deployment » Click on Deployment » Engine » External Resources » External Libraries » Click on Upload button.

This will require the restart of the data collector, once you restart you will see the jar as shown in the image:

Please run the pipeline and let us know how it goes.

Thank you - AkshayJ

Hello @mr_manii - Could you please confirm what is the status of the issue?

Well, while I was trying this my lab environment got crashed. Now trying to resolve the same😥

Sure @mr_manii. Please keep us posted on the issue.

Hi @AkshayJadhav 

I downloaded the mysql-connector-java-8.0.30.jar from given link, added the jar in the external resource link but still getting the same error.

Hello @mr_manii - Thank you for the update.

I’m able to get my pipeline running after uploading the same jar file to data collector and these are the steps that I followed:

1. Installed the JDBC_Library.
2. Developed the pipeline to connect to Mysql database.
3. Upload the jar in the external jar section on engine page.
4. Validation successful.

Here is the screenshot of pipeline preview:

I can see that jar has been uploaded to the engine by navigating to the Engine » select the engine » External Resources » External Libraries.

Could you please confirm if you see the jar file under the external libraries and review the attach pipeline to double check the JDBC configuration?

-AkshayJ 

I think I got the issue now, I am attaching the library in the wrong area, I corrected it and the test connection was successful.

Thanks for the help