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
- 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
Facing issues? Have Questions? Post them here! I am happy to answer!
More Posts related to Java,
- CRUD operations in Spring Boot + JDBC
- Java Check Leap Year - Programs with Code Examples
- [fix] Java JDBC ConnectException: Connection refused
- How to add hours and minutes to Java Instant
- Java Program: Random Number Generator
- Java: The value of the local variable string is not used
- How to get list of all Java versions installed on macOS
- Java SE JDBC with Prepared Statement Parameterized Select Example
- Java + Spring JDBC Template + Gradle Example
- Convert String to LocalDate in Java
- Remove Trailing zeros BigDecimal Java
- Java 8 Predicate Functional Interface isEqual() Method Example
- How to Hardcode Date in Java with Examples
- Java 8: Predicate negate() default Function Example
- Java: Collect Stream as ArrayList or LinkedList
- The Motivation Behind Generics in Java Programming
- How to Add/Subtract Days to the Current Date in Java
- Error: Can not find the tag library descriptor for
- Setting up JUnit 5 dependency with Maven Example
- Run Java Code Every Second
- How to create a tar.gz file using Java
- [Fix] java: integer number too large compilation error
- Java 8: Find the Max value in a List
- Your JBoss Application Server 7 is running However you have not yet added any users to be able to access the admin console
- Convert Java Array to ArrayList Code Example
- How to Download Windows Notepad Text Editor - Windows
- Check DNS Lookup using Mac Terminal - MacOS
- How to open a file via Mac Terminal - MacOS
- How to generate ssh key? - HowTos
- [Fix] ValueError: substring not found in Python - Python
- How to Check PowerShell Version? [Windows/Mac/Linux] - Powershell
- How to get the Execution Time of A Python Program - Python
- PHP Script to Upload Images to Server - PHP