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.
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:
- Android : Exception raised during rendering: action_bar API 22 - Android
- Limit scrollback rows in macOS Terminal - MacOS
- Setup Git + Visual Studio Code Tutorial - Git
- Python: How to POST Json Data with HTTP Request - Python
- Correct way to Get the Current Date in Java 8 or above - Java
- Installing Google Cloud macOS SDK - Google
- Calculate Area of ellipse - C-Program
- How to use SSH in Windows Terminal - Windows