2023-04-12T16:38:05.616-05:00 ERROR 74117
--- [main] com.zaxxer.hikari.pool.HikariPool: HikariPool-1 - Exception during pool initialization.
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.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
~[mysql-connector-java-8.0.14.jar:8.0.14]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: java.net.SocketTimeoutException: Connect timed out
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
Process finished with exit code 1
If you are getting the above exception stack trace in your Spring Boot application, below are some reasons for this issue and ways to fix the issue,
- Make sure that the MySQL database server is running. If it's a remote server check with your DBA or DevOps team if the service is up.
- Try doing telnet/ping from your system to see if the MySQL server is reachable
- Check that you have provided the correct server hostname in the configuration in the Spring Boot project application.properties file.
- Make sure the JDBC driver is corret
- If you have connection pool set up say HikariCP, ensure that the pool configuration is correct
- Check if there is no firewall rule that is blocking access.
- Try restarting the MySQL server and Spring Boot application.
![Spring Boot Project MySQL Configuration File Setup Example Spring Boot Project MySQL Configuration File Setup Example](https://code2care.org/java/fix-spring-boot-mysql-cj-jdbc-communications-exception-link-failure/images/Spring Boot Project MySQL Configuration File Setup Example.png)
Facing issues? Have Questions? Post them here! I am happy to answer!
Author Info:
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
More Posts related to Java,
- Get the current timestamp in Java
- Java Stream with Multiple Filters Example
- Java SE JDBC with Prepared Statement Parameterized Select Example
- Fix: UnsupportedClassVersionError: Unsupported major.minor version 63.0
- [Fix] Java Exception with Lambda - Cannot invoke because object is null
- 7 deadly java.lang.OutOfMemoryError in Java Programming
- How to Calculate the SHA Hash Value of a File in Java
- Java JDBC Connection with Database using SSL (https) URL
- How to Add/Subtract Days to the Current Date in Java
- Create Nested Directories using Java Code
- Spring Boot: JDBCTemplate BatchUpdate Update Query Example
- What is CA FE BA BE 00 00 00 3D in Java Class Bytecode
- Save Java Object as JSON file using Jackson Library
- Adding Custom ASCII Text Banner in Spring Boot Application
- [Fix] Java: Type argument cannot be of primitive type generics
- List of New Features in Java 11 (JEPs)
- Java: How to Add two Maps with example
- Java JDBC Transition Management using PreparedStatement Examples
- Understanding and Handling NullPointerException in Java: Tips and Tricks for Effective Debugging
- Steps of working with Stored Procedures using JDBCTemplate Spring Boot
- Java 8 java.util.Function and BiFunction Examples
- The Motivation Behind Generics in Java Programming
- Get Current Local Date and Time using Java 8 DateTime API
- Java: Convert Char to ASCII
- Deep Dive: Why avoid java.util.Date and Calendar Classes
More Posts:
- How to Split a String using delimiter in Python - Python
- How to install micro text editor using brew on macOS - MacOS
- How to change default browser on Mac Monterey - MacOS
- How to enable Dark Mode in Windows 11 - Windows-11
- How to Change Java JDK Version in IntelliJ IDE - Java
- How to know the Serial Number of MacBook on macOS Ventura 13.0 - MacOS
- Send Extra Data with Ajax Get or Post Request - JavaScript
- Facebook : Warning: Request without access token missing application ID or client token - Facebook