Java启动异常：The driver has not received any packets from the server

最新推荐文章于 2024-03-13 21:40:59 发布
最新推荐文章于 2024-03-13 21:40:59 发布
阅读量4.1w 收藏 35
点赞数 29
分类专栏： Java 异常 文章标签： java spring boot mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42254034/article/details/118631025
版权

Java启动异常：The driver has not received any packets from the server

第一种问题

在这里插入图片描述

原因：驱动程序没有收到来自服务器的任何数据包，说人话就是数据库服务停止了。
这个是在linux，经过查看确实是mysql崩了，重启mysql就可以了
解决： 重启mysql：service mysqld start 或者 service mysqld restart

第二种问题

这个是在自己本地跑的，先看报错

2021-12-01 20:29:38.113 ERROR 10468 --- [Create-51362851] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://localhost:3306/mall-tiny?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai, errorCode 0, state 08S01

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.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1560) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468) ~[druid-1.1.10.jar:1.1.10]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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) ~[na:1.8.0_301]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_301]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_301]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_301]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:361) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1452) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:955) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	... 9 common frames omitted
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
	at sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:171) ~[na:1.8.0_301]
	at sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:101) ~[na:1.8.0_301]
	at sun.security.ssl.TransportContext.kickstart(TransportContext.java:238) ~[na:1.8.0_301]
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:394) ~[na:1.8.0_301]
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:373) ~[na:1.8.0_301]
	at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:316) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:352) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	... 16 common frames omitted

首先第一眼，我真以为是mysql没启动起来，但是我本地另外一个项目已经连着mysql的，我刚刚关掉，不可能是mysql没启动起来或者崩掉了，接着往后面看，
直到我看到这里(也就是上面报错第38行的时候)，javax.net.ssl.SSLHandshakeException，啊 这？

网上找了一下这个报错，
说法一：找到C:\Program Files\Java\jre里面的lib\security 下面有个java.security。找到对应的SSLv3，删除掉，重启项目就好
说法二：重新安装jdk，找到项目配置jdk位置，修改为新安装的jdk
emm 都不行，说法一说的哪个文件并不能修改的
然后我去查看了另一个可以连上的url，跟这个做了一个对比
得出结论： url 后面加上 &useSSL=false,不使用SSL链接

&useSSL=false

但是为什么从前的也是同样的配置并没有报错呢，我想到了jdk版本，于是我我换了jdk试，果然的不出我所料，换了jdk版本就不需要加 &useSSL=false

最后得出结论，之前的jdk版本默认不使用SSL连接mysql，而我现在电脑上的版本默认使用SSL链接mysql，所以需要指定不使用SSL

你是爱，是暖，是希望，
你是人间的四月天！

DNYDYS
关注
  • 29
    点赞
  • 踩
  • 35
    收藏
    觉得还不错? 一键收藏
  • 7
    评论
专栏目录
MySQL--连接超时提示：The driver has not received any packets from the server
JustinQin
11-25 8万+
今天访问部署在Linux上Tomcat一直跑着的项目时，报错了，查看Tomcat日志大致报错信息提示...last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 大概意思就是跑的项目的与mysql服务器连...
MySQL----JDBC无法连接数据库，报The driver has not received any packets from the server的解决办法
redrose2100的博客
04-14 7547
3、但是手动可以连接数据库，本地调试JAVA代码也是可以连接数据库，使用k8s部署后就会出现此问题。（2）然后在pom.xml文件中增加配置如下内容。（1）在JDBC的连接的URL后面加上如下内容。2、过一会JDBC连接超时，报如下错误。1、JDBC连接数据库时卡在如下位置。（3）重新部署后，解决。
The driver has not received any packets from the server
qq_38864315的博客
03-25 3334
idea启动本地项目提示报错“The driver has not received any packets from the server”，可能是数据库Mysql服务被停止。 解决办法： 1.打开计算机的任务管理器 2.点击“服务”模块，找到MySQL右击启动即可 3.重启启动本地项目，正常运行 ...
The driver has not received any packets from the server.
最新发布
m0_64307175的博客
03-13 667
在启动项目时，项目没有问题，用postman测试登录模块时出现：The driver has not received any packets from the server.解决：因为电脑关机，mysql服务关闭了，只需要开启mysql服务，电脑有两个sql端口，使用3306端口时可以利用Wampserver开启服务。
oom.rar_Out Of The Blue
09-23
This is the global socket data structure used for responding to the Out-of-the-blue (OOTB) packets. A control sock will be created for this socket at the initialization time.
xt_TCPMSS.rar_The Network
09-21
This is a module which is used for setting the MSS option in TCP packets for linux network
wangluofengbao.rar_The Novice
09-24
网络封包研究 适合新手,里面介绍进制的关系抓包封包转发Network packets that suit the novice, which capture the relationship between the introduction hexadecimal packet forwarding
The driver has not received any packets from the server，java.net.ConnectException: Connection refuse
qq_43290655的博客
08-12 2万+
idea插件db navigator：The driver has not received any packets from the server
今天遇到一个错误The driver has not received any packets from the server.
热门推荐
ShiningSilver的博客
09-09 7万+
今天遇到一个错误The driver has not received any packets from the server. 花了我接近一天的时间 直到最后才发现是端口号的问题Communications link failure
连接服务器数据库出现问题：The driver has not received any packets from the server.（暴力解决，会导致数据丢失，因此需要有备份，慎用！！！）
m0_53917001的博客
10-24 1万+
在云服务器上使用mysql数据库，发现突然连不上了，报错： W/System.err: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure W/System.err: W/System.err: The last packet sent successfully to the server was 0 milliseconds ago
连接mysql时报错：The driver has not received any packets from the server.
sanqianqiqi的博客
08-29 4544
连接mysql报错：The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
snmp.zip_The Program
09-23
this is a java program for scanning the packets in the system that is transferring using the snmp ie simple network management protocol , this is similar to the network sniffer
sct.rar_The Network_content firewall
09-24
对防火墙中的数据包进行协议还原,检测网络数据包的原始内容The firewall in the agreement to restore the packets to detect network packets of the original content
xt_NOTRACK.rar_On the Up_conntrack
09-24
This is a module which is used for setting up fake conntracks on packets so that they are not seen by the conntrack/NAT code for linux.
javafbp：基于流的编程（FBP）的Java实现
02-04
JavaFBP “经典”基于流程的编程（FBP）的Java实现 有关基于流的编程的一般网站： : 。 最新版本是v4.1.11 。 可以从Releases文件夹， build/libs或Maven中获取jar文件javafbp-4.1.11.jar 。 注意：下面的Maven“防护罩”将在新版本实际可用之前显示一段时间。 单击下面的Maven防护板后，选择Download ，然后选择jar 。 此实现是用于构建JavaFBP项目的工具包。 有关许多示例网络，请访问 。 对于您自己的项目，请在该项目的“构建路径”属性中包括JavaFBP jar文件。 一般 “经典” FBP的常规网站：
pwc.rar_The Driver
09-20
The driver keeps the current state of all guids, as they are in the HW.
The driver has not received any packets from the server.（linux中关于mysql相关命令）
a1290320893的博客
12-27 2311
原因：呃呃、重启服务器，没有重新启动mysql; linux中关于mysql相关命令 1、检查MYSQL是否已安装：yum list installed | grep mysql 2、查看mysql安装目录：whereis mysql 3、启动linux服务器中mysql命令： systemctl start mysqld systemctl enable mysqld systemctl status mysqld 3、进入mysql：mysql -uroot -p the last packet s
生产环境应用无法创建数据库连接问题解决 The driver has not received any packets from the server
zhang_yyii1的博客
09-19 7606
生产环境应用无法创建数据库连接问题解决 The driver has not received any packets from the server 背景： 业务小伙伴报告系统页面打不开进不去，无法正常操作； 遂查看日志 一、问题 以下是log com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications li...
the driver has not received any packets
03-29
As an AI language model, I am unable to provide a specific solution for this issue without more context. However, if a driver has not received any packets, it could be due to a variety of reasons such as: 1. Network connectivity issues: The network connection may be weak or unstable, causing packets to not be transmitted properly. 2. Driver issues: The driver may not be properly installed or configured, leading to a failure to receive packets. 3. Hardware issues: There may be a problem with the network adapter or other hardware components, preventing the driver from receiving packets. 4. Firewall or security software: Sometimes, security software can block or interfere with incoming packets, preventing the driver from receiving them. To troubleshoot this issue, you may need to consult the software or hardware documentation, contact technical support, or seek assistance from an IT professional.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 7
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值