连接数据库报错：Communications link failure,PKIX path building failed：findvalid certification path to reque

本文主要是介绍连接数据库报错：Communications link failure,PKIX path building failed：findvalid certification path to reque，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

连接数据库报错。

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
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:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2385)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor38.newInstance(Unknown Source)
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:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
at org.logicalcobwebs.proxool.ProxoolDataSource.getConnection(ProxoolDataSource.java:97)
at com.hanweb.common.datasource.AdaptiveDataSource.getConnection(AdaptiveDataSource.java:174)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at net.bull.javamelody.JdbcWrapper $3. in v o k e (Jd b c W r a pp er . ja v a : 781) a t n e t . b u ll . ja v am e l o d y . Jd b c W r a pp er$ DelegatingInvocationHandler.invoke(JdbcWrapper.java:294)
at com.sun.proxy. $P ro x y 39. g e tC o nn ec t i o n (U nkn o w n S o u rce) a t s u n . re f l ec t . G e n er a t e d M e t h o d A ccessor 60. in v o k e (U nkn o w n S o u rce) a t s u n . re f l ec t . De l e g a t in g M e t h o d A ccessor I m pl . in v o k e (De l e g a t in g M e t h o d A ccessor I m pl . ja v a : 43) a t ja v a . l an g . re f l ec t . M e t h o d . in v o k e (M e t h o d . ja v a : 498) a t or g . s p r in g f r am e w or k . a o p . s u pp or t . A o p U t i l s . in v o k e J o in p o in t U s in g R e f l ec t i o n (A o p U t i l s . ja v a : 344) a t or g . s p r in g f r am e w or k . a o p . f r am e w or k . R e f l ec t i v e M e t h o d I n v oc a t i o n . in v o k e J o in p o in t (R e f l ec t i v e M e t h o d I n v oc a t i o n . ja v a : 198) a t or g . s p r in g f r am e w or k . a o p . f r am e w or k . R e f l ec t i v e M e t h o d I n v oc a t i o n . p rocee d (R e f l ec t i v e M e t h o d I n v oc a t i o n . ja v a : 163) a t n e t . s f . l o g 4 j d b c . D a t a S o u rce Sp y I n t erce pt or . in v o k e (D a t a S o u rce Sp y I n t erce pt or . ja v a : 29) a t or g . s p r in g f r am e w or k . a o p . f r am e w or k . R e f l ec t i v e M e t h o d I n v oc a t i o n . p rocee d (R e f l ec t i v e M e t h o d I n v oc a t i o n . ja v a : 186) a t or g . s p r in g f r am e w or k . a o p . f r am e w or k . Jd k Dy nami c A o pP ro x y . in v o k e (Jd k Dy nami c A o pP ro x y . ja v a : 212) a t co m . s u n . p ro x y .$ Proxy41.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
… 23 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 12 milliseconds ago. The last packet sent successfully to the server was 12 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:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:105)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:5170)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1676)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2324)
… 58 more
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.ssl.Alert.createSSLException(Alert.java:131)
at sun.security.ssl.TransportContext.fatal(TransportContext.java:327)
at sun.security.ssl.TransportContext.fatal(TransportContext.java:270)
at sun.security.ssl.TransportContext.fatal(TransportContext.java:265)
at sun.security.ssl.CertificateMessage $T 12 C er t i f i c a t e C o n s u m er . c h ec k S er v er C er t s (C er t i f i c a t e M ess a g e . ja v a : 646) a t s u n . sec u r i t y . ss l . C er t i f i c a t e M ess a g e$ T12CertificateConsumer.onCertificate(CertificateMessage.java:465)
at sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:361)
at sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:376)
at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:451)
at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:428)
at sun.security.ssl.TransportContext.dispatch(TransportContext.java:184)
at sun.security.ssl.SSLTransport.decode(SSLTransport.java:154)
at sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1198)
at sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1107)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:400)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:372)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:90)
… 63 more

原因：在程序进行切库操作时提示以上报错，在网上搜了好多解决方案，发现根本解决不了原因。后来仔细排查竟然发现一个小小的数据库连接配置导致这一系列错误。重点是此配置文件在本地环境切库正常，然而生产环境却不行。
在这里插入图片描述就这么一个小配置导致数据库连接不上。需要把useSSL=true修改为useSSL=false；