java连接MySQL时报错，unable to find valid certification path to requested target

最新推荐文章于 2024-05-01 17:27:34 发布
最新推荐文章于 2024-05-01 17:27:34 发布
阅读量1.5k 收藏 1
点赞数
文章标签： mysql java
原文链接：https://www.cnblogs.com/eternityz/p/14089412.html
版权

java连接mysql报错信息

05-Dec-2020 13:56:59.027 严重 [localhost-startStop-1] org.apache.catalina.core.StandardContext.filterStart 启动过滤器异常
	java.lang.RuntimeException: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. 
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 356 milliseconds ago.  The last packet sent successfully to the server was 351 milliseconds ago.
		at com.jfinal.core.Config.startPlugins(Config.java:116)
		at com.jfinal.core.Config.configJFinal(Config.java:53)
		at com.jfinal.core.JFinal.init(JFinal.java:63)
		at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)
		at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:281)
		at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:262)
		at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:106)
		at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4538)
		at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5181)
		at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
		at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
		at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
		at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
		at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:970)
		at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1840)
		at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
		at java.util.concurrent.FutureTask.run(FutureTask.java:266)
		at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
		at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
		at java.lang.Thread.run(Thread.java:748)
	Caused by: com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 356 milliseconds ago.  The last packet sent successfully to the server was 351 milliseconds ago.
		at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:50)
		at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:209)
		at com.jfinal.core.Config.startPlugins(Config.java:107)
		... 19 more
	Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 356 milliseconds ago.  The last packet sent successfully to the server was 351 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:404)
		at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988)
		at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:164)
		at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4894)
		at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1661)
		at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228)
		at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
		at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
		at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
		at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
		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:404)
		at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
		at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
		at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461)
		at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525)
		at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734)
		at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060)
		at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056)
		at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104)
		at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:38)
		... 21 more
	Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: 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:353)
		at sun.security.ssl.TransportContext.fatal(TransportContext.java:296)
		at sun.security.ssl.TransportContext.fatal(TransportContext.java:291)
		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:444)
		at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:422)
		at sun.security.ssl.TransportContext.dispatch(TransportContext.java:183)
		at sun.security.ssl.SSLTransport.decode(SSLTransport.java:154)
		at sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1279)
		at sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1188)
		at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:401)
		at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:373)
		at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:149)
		... 43 more
	Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
		at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:439)
		at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:306)
		at sun.security.validator.Validator.validate(Validator.java:271)
		at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:312)
		at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:221)
		at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:128)
		at sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:636)
		... 55 more
	Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
		at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
		at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
		at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280)
		at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434)
		... 61 more

mysql的配置信息

jdbcUrl = jdbc:mysql://127.0.0.1:3306/wawaji?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true
user = root
password =root

错误解决

将jdbcUrl中的useSSL去掉即可，修改之后为

jdbcUrl = jdbc:mysql://127.0.0.1:3306/wawaji?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull
user = root
password =root
YHJ
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
unable to find valid certification path to requested target 的问题
08-05
NULL 博文链接：https://hyl198611.iteye.com/blog/1988113
java.lang.RuntimeException: Unable to start activity ComponentInfo｛｝java.lang.ClassCastException: co
qq_17127527的博客
05-27 953
package com.xylophone.twenty_one; import android.app.DatePickerDialog; import android.app.TimePickerDialog; import android.icu.util.Calendar; import android.os.Build; import android.os.Bundle; import...
记录一次unable to find valid certification path to requested target报错解决方式
sinat_42623729的博客
03-02 522
出现这个报错是因为客户端发起的http请求缺少证书，如果服务端提供了证书，客户端按照服务端的要求安装证书即可，如果没有证书咋们可以使用apache提供方法进行绕过ssl认证达到正常的请求。下面咋们拿代码举例说明。
已解决java.lang.RuntimeException: java.lang.RuntimeException: org.codehaus.plexus.component.repository.
热门推荐
03-20 8万+
已解决java.lang.RuntimeException: java.lang.RuntimeException: org.codehaus.plexus.component.repository.exc异常的正确解决方法，亲测有效！！！
maven中排除冲突包遇到的坑
lrwyh5650的博客
11-29 570
项目启动时一开始报了以下错误 Caused by: java.lang.RuntimeException: java.io.IOException: invalid constant type: 18 at javassist.CtClassType.getClassFile2(CtClassType.java:203) at javassist.CtClassType.subtypeOf(CtClassType.java:303) at javassist.CtClassType.subty.
记一次Eclipse 报错：java.lang.RuntimeException: Exception in org.eclipse.osgi.framework.internal.core.Syst
u014471160的博客
03-26 6290
重新装过win10系统后，打开Eclipse(还有ADT)，启动时报错，错误日志如下：eclipse.buildId=v22.6.2-1085508java.version=10java.vendor=Oracle CorporationBootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=zh_CNFramework argument...
java activerecordplugin_ActiveRecordPlugin报错始终找不到原因在哪里
weixin_28846179的博客
02-25 1468
2018-08-27 17:58:11[ERROR]-[Thread: main]-[com.jfinal.core.Config.startPlugins()]: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin.File not found : E:\workspaces\waiter\file:\E:\...
jfinal异常
kun20031029的专栏
05-13 4299
[ERROR]-[Thread: qtp8918249-21]-[com.jfinal.core.ActionHandler.handle()]: /test/save com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViol
JFinal开发web项目出现问题小记
程序媛想事儿
10-23 1万+
导读作为中国优秀的开源项目之一JFinal有着极速开发的好处，是中小型应用开发的首选。在导师的建议下，我使用了JFinal来开发一个Java服务端应用，官方教程非常简单，就几十页（当然是中文的），学起来很快。然而在开发过程中肯定会遇到这样那样“无厘头”的问题，如何使用JFinal开发参考官方文档或网上某些人的教程即可，我再重写一遍也无多大意义，我这篇文章仅记录自己在使用JFinal开发过程中遇到的
mysql死锁抛出异常_循环Db.update(sql,.....)抛出了死锁异常， 请问要怎么解决呢,先谢谢啦...
weixin_34571972的博客
02-08 289
异常如下：com.jfinal.plugin.activerecord.ActiveRecordException:com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException:Deadlockfoundwhentryingtogetlock;tryrestartingtransactionatcom.j...
Spring boot maven项目报错unable to find valid certification path to requested target
01-07
参考： ...目录 一、更改镜像 二、手动将需要的插件和依赖下载放到本地厂库 三、下载阿里网站的资格证书，安装到jdk 四、设置maven的VM属性，这个...从https://start.spring.io/生成的spring boot项目，报错unable to f
ERROR: Cause: unable to find valid certification path to requested target终极解决方法
01-07
##ERROR: Cause: unable to find valid certification path to requested target终极解决方法 各位兄弟，觉得我的方法有用，可以赞我一下的呦 如果你是和我一样安装完Android studio，运行第一个Android程序，发现...
解决Android studio 3.6.1 出现Cause: unable to find valid certification path to requested target 报错的问题
01-03
// Top-level build file where you can add configuration options common to all sub-projects/modules. buildscript { repositories { maven { url '...
mysql 意向锁
csdn问鼎
04-25 215
介绍mysql 意向锁的作用
Mysql_数据库事务
weixin_69252724的博客
04-26 1200
事务就是由单独单元的一个或多个sql语句组成，在这个单元中，每个sql语句都是相互依赖的。而整个单独单元是作为一个不可分割的整体存在，类似于化学当中的原子（一种不可分割的最小单位）。往通俗的讲就是，事务就是一个整体，里面的内容要么都执行成功，要么都不成功。不可能存在部分执行成功而部分执行不成功的情况。就是说如果单元中某条sql语句一旦执行失败或者产生错误，那么整个单元将会回滚(返回最初状态)。
MySQL LIKE通配符(%,_)及escape实例讲解
2401_83432873的博客
04-26 801
LIKE操作符常用于模式匹配查询数据。以正确的方式使用LIKE运算符对于提高查询性能至关重要。LIKE操作符允许您从基于指定的模式选择表中的数据。因此，LIKE操作符经常用于SELECT语句的WHERE子句中。MySQL提供了两个通配符与LIKE操作符一起使用：百分比和下划线。
【MySQL】1.安装与配置
2301_79719531的博客
04-28 763
文件的安全性问题。文件不利于数据查询和管理。文件不利于存储海量数据。文件在程序中控制不方便。数据库存储介质：磁盘+内存。为了解决上述问题，专家们设计出更加利于管理数据的软件——数据库，他能更加有效的管理数据。数据库可以提供远程服务，即通过远程连接来使用数据库，因此也称为数据库服务器。
【MySQL】驱动表、被驱动表详解。—— 性能优化。
最新发布
我梦
05-01 290
【MySQL】驱动表、被驱动表详解。—— 性能优化。
java install unable to find valid certification path to requested target
09-19
当您遇到 "unable to find valid certification path to requested target" 错误时，这意味着您的Java应用程序或Maven无法在与远程服务器建立安全连接时验证服务器的证书。这通常是由于服务器的证书未被Java信任所...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值