
If you are working with Database in your app using ORM or Spring JDBC/Spring Boot JPA, you may get this exception,
Exception:Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException:
Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException:
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server.
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Fix/Solutions:
- Make sure your Database is up. Check connection to the database via DB Client or Console. Try doing telnet.
- How you defined the right database Hostname/IP Address in your JDBC DriverManager Connection URL?
- Have you defined the right Database server Port?
- Make sure your firewall settings are not restricting access.
- Make sure you have Internet connectivity.
- Make sure the Database server if having an IP Whitelisting policy, your IP is listed.
- If the Database Server is on Cloud (AWS/Azure/GCS), the right policies are set.
- If Database is on Docker Container, make sure the host port is exposed and accesiible
-
Have Questions? Post them here!
More Posts related to Java,
- Add two numbers using Java Generics
- Convert Java List to Json String using Jackson
- Convert Java Object to JSON using Jackson Library
- Java SE JDBC: Insert with PreparedStatement Example
- [Program] How to read three different values using Scanner in Java
- Java JDBC Batch Update Example with PreparedStatement
- Java Stream flatmap() Examples
- Save Java Object as JSON file using Jackson Library
- Java get day of the week as an int using DayOfWeek
- Create Nested Directories using Java Code
- Java JDBC Delete a Record in Database Table using PreparedStatement
- List of jars required for Struts2 project
- Convert Java Object to XML using Jackson Library
- Struts2 : java.lang.ClassNotFoundException: org.apache.commons.fileupload.RequestContext
- Java JDBC Get Id of the Inserted Record with AutoIncrement
- How to list all tables using Java JDBC
- Java Jackson ObjectMapper Class with Examples
- Fix: Maven - Failed to execute goal - Compilation failure - Source/Target option 5 is no longer supported. Use 7 or later
- Eclipse : The type java.lang.CharSequence cannot be resolved. Indirectly referenced from required .class files
- Formatting Double in Java [Examples]
- How to run Java Unit Test cases with Apache Maven?
- [fix] NullPointerException Cannot Invoke findById because Repository is null - Java Spring
- [Fix] java: integer number too large compilation error
- [Java] Read a File with UTF-8 Encoding
- How to detect Operating System using Java code
More Posts:
- How to create tar.gz file using Terminal Command - Linux
- Find Hostname of Mac running on macOS Ventura 13 - MacOS
- Format Code in Visual Studio - VS Code [Mac/Windows/Linux] - HowTos
- How to fix bash ping command not found error - Bash
- [Fix] Microsoft teams error code 503 - Failed to reach https - Teams
- Obsolete marquee element alternatives html5 - Html
- How to Compare Strings in Bash - Bash
- What is Terminal Velocity and its Formula? How to calculate it programmatically? - Python