How to resolve Communications link failure for MySQL [JDBC driver error]
Hi friends, someday before we have faced an issue with a JDBC driver to connect MySQL database com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure azure. this error came when we are trying to access azure PAAS mysql from java code.
In this, we will see how to resolve this issue
- first of all, you need to check your JDBC driver version. it should be the latest version.
- Check your PAAS mysql server parameter Time_zone were updated to the following: ‘+5:30’. By default, it was SYSTEM. the server time zone should be matched with your local machine time zone.
- The deprecated class using in JDBC driver was replaced with the new supported class
By following above step we have resolved our issue.
I am a professional Cloud Engineer and founder of LinuxFork. I am working on Infrastructure Deployment and focusing on the integration of open source technologies with the Cloud. I am an avid Linux lover and open source enthusiast. mostly, I am working with Redhat and Ubuntu Linux in the production environment. apart from this I always believe in knowledge sharing.