create connection SQLException

最新推荐文章于 2025-03-22 23:59:56 发布

熊崽_张

最新推荐文章于 2025-03-22 23:59:56 发布

阅读量2.2w

点赞数

分类专栏：问题文章标签： MySQL

问题专栏收录该内容

37 篇文章

订阅专栏

本文记录了一次使用Druid连接池连接MySQL时遇到的SSL握手失败问题，详细展示了错误堆栈跟踪，并给出了针对MySQL 8.0的解决方案，即通过调整连接参数useSSL为false来避免证书验证引发的问题。

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

问题描述如下：

10:51:24.314 [Druid-ConnectionPool-Create-3305495] ERROR c.a.d.p.DruidDataSource - [run,2471] - create connection SQLException, url: jdbc:mysql://localhost:3306/**?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true, errorCode 0, state 08S01
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 70 milliseconds ago. The last packet sent successfully to the server was 53 milliseconds ago.
   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.jdbc.Util.handleNewInstance(Util.java:425)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
   at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
   at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4912)
   at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
   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.jdbc.Util.handleNewInstance(Util.java:425)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
   at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
   at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218)
   at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1560)
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623)
   at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468)
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.Alerts.getSSLException(Alerts.java:192)
   at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1964)
   at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:328)
   at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:322)
   at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1614)
   at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)
   at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1052)
   at sun.security.ssl.Handshaker.process_record(Handshaker.java:987)
   at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1072)
   at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)
   at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)
   at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)
   at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
   ... 21 common frames omitted
Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
   at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:302)
   at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:992)
   at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1596)
   ... 29 common frames omitted
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:154)
   at sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:80)
   at java.security.cert.CertPathValidator.validate(CertPathValidator.java:292)
   at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:295)
   ... 31 common frames omitted
10:51:24.324 [Druid-ConnectionPool-Create-3305495] ERROR c.a.d.p.DruidDataSource - [run,2471] - create connection SQLException, url: jdbc:mysql://localhost:3306/**?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true, errorCode 0, state 08S01
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure