org.springframework.jdbc.CannotGetJdbcConnectionException:

最新推荐文章于 2024-04-26 00:56:45 发布
最新推荐文章于 2024-04-26 00:56:45 发布
阅读量2.2k 收藏
点赞数
分类专栏： 技术 文章标签： java intellij-idea maven
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xuyoujia1991/article/details/121959183
版权 
Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is 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 org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:431)
	at com.xyj.test.JdbcTemplateTest.main(JdbcTemplateTest.java:16)
Caused by: 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:172)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:155)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:146)
	at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:205)
	at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:169)
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	... 3 more
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)
	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:59)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:355)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:789)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:499)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:217)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1411)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:982)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
	... 15 more
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at sun.security.ssl.Alert.createSSLException(Alert.java:131)
	at sun.security.ssl.TransportContext.fatal(TransportContext.java:370)
	at sun.security.ssl.TransportContext.fatal(TransportContext.java:313)
	at sun.security.ssl.TransportContext.fatal(TransportContext.java:308)
	at sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:652)
	at sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:471)
	at sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:367)
	at sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:376)
	at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:479)
	at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:457)
	at sun.security.ssl.TransportContext.dispatch(TransportContext.java:200)
	at sun.security.ssl.SSLTransport.decode(SSLTransport.java:154)
	at sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1290)
	at sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1199)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:401)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:373)
	at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:213)
	at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:206)
	at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:350)
	... 22 more
Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:280)
	at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1255)
	at sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:636)
	... 37 more
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at sun.security.provider.certpath.PKIXCertPathValidator.validate(PKIXCertPathValidator.java:158)
	at sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:84)
	at java.security.cert.CertPathValidator.validate(CertPathValidator.java:292)
	at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:273)
	... 39 more

Process finished with exit code 1

在pom文件种增加：

<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.3.12</version>
    </dependency>
xuyoujia1991
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
出现 org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC 解决方法（全面分析）
码农研究僧的博客
06-27 333
org.springframework.jdbc.CannotGetJdbcConnectionException org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at
mybatis连接MySQL8出现的问题解决方法
08-26
SSM框架是一个基于Spring的框架，它提供了一个简单的方式来访问数据库。在使用SSM框架时，需要注意MyBatis的版本问题，以避免出现问题。 总结 本文介绍了MyBatis连接MySQL8出现的问题解决方法。通过升级mysql-...
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection； nested
weixin_55229531的博客
06-07 1万+
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30015ms.
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection；
最新发布
qq_69588103的博客
04-26 3073
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
解决Springboot + MyBatis框架“Cause: org.springframework.jdbc.CannotGetJdbcConnectionException”问题
热门推荐
Lili Liang的博客
05-05 9万+
目录 1 出错类型一（连接MySQL失败） 2 出错类型二（MySQL密码错误） 3 出错类型三（XXXMapper.xml中SQL语句语法问题） 前言： 最近用springboot写项目的时候，写Dao层测试利用MyBatis访问数据库遇到了bug，困扰了一两天，因此记录一下。 1 出错类型一（连接MySQL失败） ### Cause: org.springframework...
mybatis报错：org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC
qq_50376377的博客
04-22 1299
记录一下今天遇到的一个错误，错误日志如下： org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection；
m0_64259792的博客
06-05 6183
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server.) java.lang.NullPointerException
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
weixin_65140509的博客
03-07 683
在使用完全注解的方式配置时，复制了上一个练习的代码。在测试时出现了报错org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection。在检查代码正确和在网上查找结果不尽人意时，我又检查了一遍注解是否正确和配置文件是否正常。最后发现原因为：因为使用的是父子工程的缘故，我在上一次练习时将mysql的依赖只导入到子工程并未在父工程进行配置，所以导致出现了这个错误。
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException:
weixin_47056195的博客
03-15 2万+
一、 异常信息：Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sq
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题处理
csdn565973850的博客
07-02 4123
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection问题处理报错信息问题分析 报错信息 2021-07-02 11:08:56,465 INFO [org.jasig.cas.web.flow.InitialFlowSetupAction] - <Setting path for cookies to: /cas/> 2021-07-02 11:09:09,933 ERRO
Springboot+MySQL，出现Could not get JDBC Connection
12-14
在Spring Boot应用中集成MySQL数据库时，可能会遇到“Could not get JDBC Connection”的错误，这个问题通常是由于数据源配置问题、数据库连接参数错误或者数据库权限问题所导致的。让我们深入了解一下这个问题的...
spring boot整合mybatis连接不上数据库
12-14
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using ...
dbcp 连接池不合理的锁导致连接耗尽解决方案
01-20
DBCP（Database Connection Pool）是Apache的一个开源项目，提供了一个基于Java的数据源连接池实现。在上述问题中，应用程序遇到了由于连接池不合理的锁机制导致的连接耗尽问题，表现为无法从连接池获取新的数据库...
SPRING API 2.0.CHM
04-29
CannotGetJdbcConnectionException CannotLoadBeanClassException CannotSerializeTransactionException CciDaoSupport CciLocalTransactionManager CciOperationNotSupportedException CciOperations ...
小程序开发笔记-block，wx:for等知识
xuyoujia1991的博客
11-04 774
小程序笔记 今天完成小程序的商户信息列表和详情页面的开发。涉及到的空间有{{items.value1}}{{item.value2}}…… wx:for中是js中data传过来的参数，这个参数就是一个数组[1,2,3,4,5],而item就是其中的1，2，3，4…… 涉及到的方法 wx.request请求方法：参数有url,header,success,fail setTimeout(()=>{ })：进行延时方法 onPulldownRefresh方法:当用户进行下拉操作的时候触发
2021-11-08-ajax跨域问题笔记
xuyoujia1991的博客
11-11 678
ajax跨域问题 通过ajax访问“http://www.kuaidi100.com/query”，浏览器报错： Access to XMLHttpRequest at ‘http://www.kuaidi100.com/query?type=zhongtong&postid=78237558620256’ from origin ‘null’ has been blocked by CORS policy: Response to preflight request doesn’t pass a
web项目的修改步骤及idea调试
xuyoujia1991的博客
01-22 596
如何将普通application项目改成web项目 1.pom文件中添加：war 2.pom文件中新增tomcat插件 3.在main路径下创建src/main/webapp/WEB-INF/web.xml，web.xml是servlet的描述服务 maven打包操作 进入项目的路径：D:\ideaProjects\geetbanglesson\think-in-spring\bean-scope mvn --version mvn clean package ----提示以下异常-----------
org.springframework.jdbc.cannotgetjdbcconnectionexception:
06-06
org.springframework.jdbc.CannotGetJdbcConnectionException是Spring框架中的一个异常类，表示无法获取JDBC连接。这可能是由于数据库连接池中的连接已用尽，或者数据库服务器不可用等原因导致的。要解决此问题，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值