com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]

by

This is a wrapped exception and not really interesting. It is the root cause of the exception which actually tells us something about the root cause. Please look a bit further in the stacktrace. The chance is big that you’ll then face a SQLException: Connection refused or SQLException: Connection timed out.

If this is true in your case as well, then all the possible causes are:

  1. IP address or hostname in JDBC URL is wrong.
  2. Hostname in JDBC URL is not recognized by local DNS server.
  3. Port number is missing or wrong in JDBC URL.
  4. DB server is down.
  5. DB server doesn’t accept TCP/IP connections.
  6. Something in between Java and DB is blocking connections, e.g. a firewall or proxy.

To solve the one or the either, follow the following advices:

  1. Verify and test them with ping.
  2. Refresh DNS or use IP address in JDBC URL instead.
  3. Verify it based on my.cnf of MySQL DB.
  4. Start it.
  5. Verify if mysqld is started without the --skip-networking option.
  6. Disable firewall and/or configure firewall/proxy to allow/forward the port.

By the way (and unrelated to the actual problem), you don’t necessarily need to load the JDBC driver on every getConnection() call. Just only once during startup is enough.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. Multiple queries executed in java in single statement
  6. Java: Insert multiple rows into MySQL with PreparedStatement
  7. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  8. Cannot issue data manipulation statements with executeQuery()
  9. Handling MySQL datetimes and timestamps in Java
  10. Closing JDBC Connections in Pool
  11. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  12. Returning a ResultSet
  13. How to change MySQL timezone in a database connection using Java?
  14. How to configure Tomcat to connect with MySQL
  15. Retrieve an Image stored as BLOB on a MYSQL DB
  16. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. mysql prepared statement error: MySQLSyntaxErrorException
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. How to correctly write UTF-8 strings into MySQL through JDBC interface
  23. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  24. java.sql.SQLException: Before start of result set [duplicate]
  25. Stumped SQL Exception for JDBC
  26. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. java.sql.SQLException: No database selected – why?
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment