Skip to main content
Solved

Unable to connect to My Sql Database

  • November 22, 2022
  • 8 replies
  • 406 views

Hi

 

I am trying my lab to connect to My Sql

 

I did the following

 

In Deployment menu, I configured all the JDBC Library

In the engine I downloaded mysql-connector jar and restarted the engine

 

In the connection I gave the connection string, username and password, however when I test connection I am getting the following error

 

  • JDBC_00 - Cannot connect to specified database: java.sql.SQLException: No suitable driver found for jdbc:mysql://mysqldb:3306/zomato

Is there anything I am missing here.?

 

Best answer by AkshayJadhav

Hello @mr_manii - I’m glad that issue has been resolved. Could you please mark the reply as best answer and close the loop here. 

Thank you - AkshayJ

View original
Did this topic help you find an answer to your question?

8 replies

AkshayJadhav
StreamSets Employee
Forum|alt.badge.img
  • StreamSets Employee
  • 101 replies
  • November 22, 2022

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


AkshayJadhav
StreamSets Employee
Forum|alt.badge.img
  • StreamSets Employee
  • 101 replies
  • November 23, 2022

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

 

 


  • Author
  • Roadie
  • 7 replies
  • November 23, 2022

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

 


AkshayJadhav
StreamSets Employee
Forum|alt.badge.img
  • StreamSets Employee
  • 101 replies
  • November 23, 2022

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


  • Author
  • Roadie
  • 7 replies
  • November 24, 2022

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.

 


AkshayJadhav
StreamSets Employee
Forum|alt.badge.img
  • StreamSets Employee
  • 101 replies
  • November 24, 2022

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 


  • Author
  • Roadie
  • 7 replies
  • November 25, 2022

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


AkshayJadhav
StreamSets Employee
Forum|alt.badge.img
  • StreamSets Employee
  • 101 replies
  • Answer
  • November 25, 2022

Hello @mr_manii - I’m glad that issue has been resolved. Could you please mark the reply as best answer and close the loop here. 

Thank you - AkshayJ


Reply