今天使用mybatis时使用useSSL=true报错(w)

最新推荐文章于 2022-05-04 20:06:48 发布
最新推荐文章于 2022-05-04 20:06:48 发布
阅读量1.5k 收藏 1
点赞数 1
分类专栏： 笔记 文章标签： mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43227626/article/details/109893944
版权

这是链接代码：

jdbc:mysql://localhost:3307/testmybatis?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=UTC

查询类已经序列化

错误：

"E:\hugh456\IDEA\IntelliJ IDEA 2019.3.1\jbr\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:E:\hugh456\IDEA\IntelliJ IDEA 2019.3.1\lib\idea_rt.jar=17334:E:\hugh456\IDEA\IntelliJ IDEA 2019.3.1\bin" -Dfile.encoding=UTF-8 -classpath "E:\hugh456\IDEA\IntelliJ IDEA 2019.3.1\lib\idea_rt.jar;E:\hugh456\IDEA\IntelliJ IDEA 2019.3.1\plugins\junit\lib\junit5-rt.jar;E:\hugh456\IDEA\IntelliJ IDEA 2019.3.1\plugins\junit\lib\junit-rt.jar;F:\学习资料123\黑马2018JAVA基础班IDEA\Myexcise8\testmybatis31\target\test-classes;F:\学习资料123\黑马2018JAVA基础班IDEA\Myexcise8\testmybatis31\target\classes;C:\my_java_web_hugh\maven_repository\org\mybatis\mybatis\3.5.6\mybatis-3.5.6.jar;C:\my_java_web_hugh\maven_repository\mysql\mysql-connector-java\5.1.49\mysql-connector-java-5.1.49.jar;C:\my_java_web_hugh\maven_repository\junit\junit\4.13\junit-4.13.jar;C:\my_java_web_hugh\maven_repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 hugh.MyTest,testone

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,606 milliseconds ago.  The last packet sent successfully to the server was 1,598 milliseconds ago.
### The error may exist in com/hugh/dao/StudentMapper.xml
### The error may involve com.hugh.dao.StudentMapper.students
### The error occurred while executing a query
### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,606 milliseconds ago.  The last packet sent successfully to the server was 1,598 milliseconds ago.

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
	at com.sun.proxy.$Proxy8.students(Unknown Source)
	at hugh.MyTest.testone(MyTest.java:16)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,606 milliseconds ago.  The last packet sent successfully to the server was 1,598 milliseconds ago.
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:202)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4869)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1656)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:224)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:219)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:95)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:432)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:139)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:61)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	... 32 more
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:320)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:263)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:258)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:641)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:460)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:360)
	at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
	at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:443)
	at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:421)
	at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:177)
	at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)
	at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1152)
	at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1063)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:402)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:187)
	... 64 more
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:303)
	at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1510)
	at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:625)
	... 75 more
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
	at java.base/sun.security.provider.certpath.PKIXCertPathValidator.validate(PKIXCertPathValidator.java:158)
	at java.base/sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:84)
	at java.base/java.security.cert.CertPathValidator.validate(CertPathValidator.java:309)
	at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:296)
	... 77 more


Process finished with exit code -1

使用才成功

useSSL=false
weixin_43227626
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Mybatis初体验之都是useSSL=true惹得祸
weixin_46093892的博客
09-16 971
今天第一次接触Mybatis,本人是跟着狂神的视频学习的，因为我觉得他讲的挺细的 跟着视频先理清思路，然后再自己试着敲，结果最后报错了。 org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last
MyBatis中关于SSL/TLS配置
weixin_45421692的博客
06-09 344
去除mybatis-config.xml中的environments分支，通过代码自行配置。mybatis-config.xml 配置文件中不支持TLS初始值设定。前提服务端已经配置好TLS，客户端拥有访问证书、证书密码等基本数据。运行结果控制台输出false，连接成功；java代码示例，根据实际情况更改。运行程序后，会出现如下错误。
mybatis 项目配置 xml文件时 报错提示（The reference to entity "useSSL" must end with the ';' delimiter.）
hugh 的博客
04-22 9154
最近在用mybatis时出了不少的问题，现在看来的确是掌握的不扎实。这次在配置xml文件时，出现错误提示（ The reference to entity “useSSL” must end with the ‘;’ delimiter.） 报错行为<property name="url" value="jdbc:mysql://www.xxxx.com:3306/db?characterEn
用useSSL=true或useSSL=false无法解决WARN: Establishing SSL connection without server‘s identity verificatio
zaweio的博客
05-17 2136
用useSSL=true或useSSL=false无法解决WARN: Establishing SSL connection without server’s identity verification is not recommended. …报错的解决方法（自用） 问题描述： 在b站自学mybatis，明明和视频操作一样但是报了WARN: Establishing SSL connection without server’s identity verification is not recommend
mysql数据库连接useSSL=true
weixin_34327761的博客
03-08 2870
web应用中连接mysql数据库时控制台会出现这样的提示： Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be...
解决mybatis-plus使用jdk8的LocalDateTime 查询时报错的方法
08-24
主要介绍了解决mybatis-plus使用jdk8的LocalDateTime 查询时报错的方法，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
使用mybatis-plus报错Invalid bound statement (not found)错误
09-07
主要介绍了使用mybatis-plus报错Invalid bound statement (not found)错误，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
mybatis中使用oracle关键字出错的解决方法
08-29
然而，在使用MyBatis时，可能会遇到一些问题，例如使用Oracle关键字时出现错误。在本文中，我们将讨论如何解决MyBatis中使用Oracle关键字出错的问题。 问题描述 在MyBatis中，如果使用的字段是Oracle的关键字，可能...
mybatis学习使用
07-31
MyBatis学习使用 MyBatis是一个持久层的框架，封装了JDBC功能，支持定制化SQL，屏蔽所有JDBC代码，使 用XML和注解配置，数据库映射到JAVA对象。MyBatis可以复杂定制，效率略低于Hibernate。 MyBatis的特点： 1. ...
Mybatis的详细使用教程
09-01
MyBatis可以使用简单的XML或注解进行配置和原始映射，将接口和Java的POJOs(Plain Old Java Objects，普通的Java对象)映射成数据库中的记录。 首先，要使用MyBatis，你需要引入必要的依赖。在Java项目中，这通常通过...
mybatis mysql ssl_Mybatis笔记四——useSSL=true导致的SSL协议异常
weixin_34547628的博客
01-21 606
useSSL=true导致的SSL协议异常org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last...
mybatis- useSSL=true会报错
qq_44241881的博客
02-14 696
D:\Java\jdk1.8.0_144\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 “-javaagent:D:\IntelliJ IDEA 2019.3.4\lib\idea_rt.jar=55227:D:\IntelliJ IDEA 2019.3.4\bin” -Dfile.encoding=UTF-8 -classpath “D:\IntelliJ IDEA 2019.3.4\lib\idea_rt.jar;D:\IntelliJ
mybatis使用时出现：对实体 “useSSL“ 的引用必须以 ‘；‘ 分隔符结尾问题的解决方法
叶卡捷琳堡的博客
03-06 794
文章目录问题描述解决方法 问题描述 最近在学习mybatis，访问数据库时idea报错 解决方法 后来查了一下才发现，原来在.xml文件中写“&”符号时会引起冲突，需要把&改为&amp;才行 下面这个代码报错 <!--连接数据库的url字符串--> <property name="url" value="jdbc:mysql://localhost:3306/mybatistest?serverTimezone=UTC&useSSL=false&a
mybatis的使用入门
momo131422的博客
05-04 431
mybatis的连接数据库以及简单实用
useSSL=true错误---报大量错误，又都是jdbc地方报错时候看
qq_42388853的博客
09-13 3115
今天遇到了问题，太鸡儿坑爹了,报错是这样的,看着错误摸着头想半天想不出来,上面都是c3p0的问题，对着c3p0改了半天没胡来，后面就偶然间改了下链接里的 jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai 把useSSL=true改成false就可以了，我真的想哭了，下面是报的错。 "
解决Mybatis连接Mysql出现错误的一种有效方法
m0_58272336的博客
03-17 2578
one of solutions to solve this problem.
Mysql 8.0使用Mybatis连接数据库会遇到的问题
Holmes_shuai的博客
08-04 585
Mysql 8.0使用Mybatis连接数据库会遇到的问题 <!-- mybatis主配置文件 --> <configuration> <!-- 配置环境 --> <environments default="mysql"> <!-- 配置mysql环境 --> <environment id="mysql"> <!-- 配置事务类型 -->
mybatis逆向工程出现对实体 “useSSL“ 的引用必须以 ‘；‘ 分隔符结尾。的解决办法
Abdulaziz的博客
12-30 196
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/库名?&amp;useSSL=false&amp;serverTimezone=UTC&amp;allowPublicKeyRetrieval=true" userId="用户名" password="密码"/> 标注红色为问题出现项，处理
Mybatis配置和容易出现的错误
心藏_的博客
05-26 466
关于mybatis的配置和易出现的错误，解释一下jdbc:mysql://localhost:3306/mybatis? useSSL=true&useUnicode=true&characterEncoding=UTF8
jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT&useSSL=FALSE完整的几句话
最新发布
06-12
这是一个 JDBC 连接 MySQL 数据库的 URL，其中： - `jdbc` 是协议名； - `mysql` 是子协议名，表示要连接 MySQL 数据库； - `localhost` 是 MySQL 数据库所在的主机名；...- `useSSL=FALSE` 表示不使用 SSL 连接。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值