jdbc启动错误（The driver has not received any packets from the server）

最新推荐文章于 2026-05-03 05:56:14 发布
转载 最新推荐文章于 2026-05-03 05:56:14 发布 · 10w+ 阅读 · 18
本文探讨了在使用C3P0数据源时遇到的MySQL连接超时问题，并提供了通过修改my.ini配置文件来解决该问题的方法。通过将wait_timeout和interactive_timeout参数设置为较高值，可以有效避免连接超时，确保应用程序稳定运行。
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.GeneratedConstructorAccessor15.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:690)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1093)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
    at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
    at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2539)
    at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:614)
    ... 20 more
2012-04-20 10:17:57,976-[HL] WARN Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@3729f7 com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1e88181 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
  com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

　　原因大概就是启动的时候发送了一些测试语句到mysql，但是没有得到响应，估计是连接超时的问题

  java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
    at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)
    at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)
    at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1460)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1398)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:540)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:842)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:416)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:516)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@192c07a -- timeout at awaitAvailable()
    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
    ... 38 more

　　这个东西以前没有注意到，上网找来了很多的解决方法

最好的如下：

jdbc.url=jdbc:mysql://localhost:3306/totosea?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false

　　在mysql的安装目录下找到my.ini

添加

wait_timeout=31536000
interactive_timeout=31536000
CannotGetJdbcConnectionException和SQLException和InvalidConnectionAttributeException
123
05-04 543
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server time zone value '?й???????' is unrecognized or...
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
09-23 2547
最近下载代码，启动后报错。
c3p0.properties配置引起的com.mchange.v2.resourcepool.TimeoutException
进阶之路
06-16 2万+
c3p0.properties配置引起的com.mchange.v2.resourcepool.TimeoutException 最近由于客户业务量的增长，公司决定使用分布式处理的方式来解决客户反应的处理速度慢的问题。本博主要讲解项目中遇到的问题，如有不对敬请批评指正。废话不多说直接上干货。 首先，我把业务逻辑重新梳理了一遍，抽出了无关的业务和可能产生并发的逻辑，以便考虑分布式（简单分布式）。
手把手教你用文本编辑器搞定CAN2.0到CANFD的DBC文件转换（附Vector CANoe配置要点）
最新发布
weixin_30751947的博客
05-03 710
本文详细介绍了如何通过文本编辑器实现CAN2.0到CANFD的DBC文件转换，包括关键字段修改和Vector CANoe配置要点。通过对比协议差异和分步实战指南，帮助开发者高效完成通信矩阵升级，提升电子电气架构的稳定性和性能。
The driver has not received any packets from the server，java.net.ConnectException: Connection refuse
qq_43290655的博客
08-12 3万+
idea插件db navigator：The driver has not received any packets from the server
Java启动异常：The driver has not received any packets from the server
weixin_42254034的博客
07-10 4万+
Java启动异常：The driver has not received any packets from the server 原因：驱动程序没有收到来自服务器的任何数据包，说人话就是数据库服务停止了。 解决： 重启mysql：service mysqld start 或者 service mysqld restart ...
The driver has not received any packets from the server.（linux中关于mysql相关命令）
a1290320893的博客
12-27 2678
原因：呃呃、重启服务器，没有重新启动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.
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
The driver has not received any packets from the server.
m0_64307175的博客
03-13 4865
在启动项目时，项目没有问题，用postman测试登录模块时出现：The driver has not received any packets from the server.解决：因为电脑关机，mysql服务关闭了，只需要开启mysql服务，电脑有两个sql端口，使用3306端口时可以利用Wampserver开启服务。
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异常 ： The driver has not received any packets from the server.
weixin_36988264的博客
08-22 1619
异常：结论：域名写错了或报这个异常 原创作者: u_15958225 转载于: https://blo...
The driver has not received any packets from the server
qq_38864315的博客
03-25 4077
idea启动本地项目提示报错“The driver has not received any packets from the server”，可能是数据库Mysql服务被停止。 解决办法： 1.打开计算机的任务管理器 2.点击“服务”模块，找到MySQL右击启动即可 3.重启启动本地项目，正常运行 ...
MySQL----JDBC无法连接数据库，报The driver has not received any packets from the server的解决办法
redrose2100的博客
04-14 9432
3、但是手动可以连接数据库，本地调试JAVA代码也是可以连接数据库，使用k8s部署后就会出现此问题。（2）然后在pom.xml文件中增加配置如下内容。（1）在JDBC的连接的URL后面加上如下内容。2、过一会JDBC连接超时，报如下错误。1、JDBC连接数据库时卡在如下位置。（3）重新部署后，解决。
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire...
weixin_30438813的博客
11-29 2480
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@1483de4 -- timeout at awaitAvail...
mysql 错误：The driver has not received any packets from the server.
默默不代表沉默
05-15 3万+
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets fr...
连接mysql时报错：The driver has not received any packets from the server.
sanqianqiqi的博客
08-29 5179
连接mysql报错：The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
评论 13
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值