数据库 com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

最新推荐文章于 2025-04-23 17:24:44 发布

小小蜗牛139

最新推荐文章于 2025-04-23 17:24:44 发布

阅读量1.4k

点赞数 2

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/weixin_43688870/article/details/118637372

这篇博客主要讨论了在遇到`com.mysql.cj.jdbc.exceptions.CommunicationsException`和`SSLHandshakeException`错误时的问题定位和解决方案。错误的根本原因是由于SSL协议或加密套件不匹配导致的通信失败。解决方法包括删除`JAVA_HOMEjrelibsecurity`目录下的`java.security`文件，然后重启项目来恢复连接。请注意，此操作可能会导致其他依赖SSL的组件出现问题，因此建议备份文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题描述

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 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:340)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:167)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1348)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:157)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
	... 84 common frames omitted
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

问题定位 SSLHandshakeException

Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

解决方案

删除 JAVA_HOME \jre\lib\security中的java.security

重命名防止以后要用却不知道在哪里找到

重启项目