I am getting this type of error JDBC_00 - Cannot connect to specified database: com.mysql.cj.jdbc.exceptions.CommunicationsException. Can anybody help me in this.
I am getting this type of error JDBC_00 - Cannot connect to specified database: com.mysql.cj.jdbc.exceptions.CommunicationsException. Can anybody help me in this.
Hi
This is an exception coming from MySQL driver, basically we are not able to establish the connection.
Quickly googling it, I’ve found this that might help you troubleshoot https://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql
Actually, I tried everything but than also not able to establish connection. So could you please tell me, is there any other way to establish a JDBC connection.
Have you tried doing a ping to the machine where the MySQL is located? Are we sure it is reachable? (Not blocked by a firewall or things like that)
Its Resolved automatically. Thanks for helping
Hello
I am actually experiencing the same issue. I was wondering if
Thanks in advance!
Make sure your data collector has access to the database.
Hi
Is there a specific place I should be checking to make sure of that?
Thank you!
If yes, then make sure your sdc docker is in the same docker network as your database.
you can validate it by docker exec into your instance and do a ping to the database.
cool. Let me know how it goes :-)
Hi
It seems as though both the SDC and mysqldb are on the same network but I’m still getting the same error.
can you please give a try with below jdbc connection string.
jdbc:mysql://///mysqldb:3306/zomato?enabledTLSProtocols=TLSv1.2
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.