org.apache.ibatis.exceptions.PersistenceException:

于 2022-03-22 11:24:51 发布
阅读量1.1k 收藏
点赞数
文章标签： eclipse java spring maven tomcat
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/just_learing/article/details/123656041
版权

今天上午高高兴兴的写个mybatis

突然 

就很快

出现了这个bug

D:\Study\JAVA\JaveJdk1.8\jdk1.8\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:\Study\ssmtools\ideal11\IntelliJ IDEA 2019.3.5\lib\idea_rt.jar=52054:D:\Study\ssmtools\ideal11\IntelliJ IDEA 2019.3.5\bin" -Dfile.encoding=UTF-8 -classpath "D:\Study\ssmtools\ideal11\IntelliJ IDEA 2019.3.5\lib\idea_rt.jar;D:\Study\ssmtools\ideal11\IntelliJ IDEA 2019.3.5\plugins\junit\lib\junit5-rt.jar;D:\Study\ssmtools\ideal11\IntelliJ IDEA 2019.3.5\plugins\junit\lib\junit-rt.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\charsets.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\deploy.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\access-bridge-64.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\cldrdata.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\dnsns.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\jaccess.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\jfxrt.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\localedata.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\nashorn.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\sunec.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\sunjce_provider.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\sunmscapi.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\sunpkcs11.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\ext\zipfs.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\javaws.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\jce.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\jfr.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\jfxswt.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\jsse.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\management-agent.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\plugin.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\resources.jar;D:\Study\JAVA\JaveJdk1.8\jdk1.8\jre\lib\rt.jar;D:\Study\ssmtools\mavan\mybatisTest04\mybatisTest0403\target\test-classes;D:\Study\ssmtools\mavan\mybatisTest04\mybatisTest0403\target\classes;C:\Users\12698\.m2\repository\org\projectlombok\lombok\1.18.22\lombok-1.18.22.jar;C:\Users\12698\.m2\repository\mysql\mysql-connector-java\8.0.26\mysql-connector-java-8.0.26.jar;C:\Users\12698\.m2\repository\com\google\protobuf\protobuf-java\3.11.4\protobuf-java-3.11.4.jar;C:\Users\12698\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\12698\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\12698\.m2\repository\org\mybatis\mybatis\3.5.2\mybatis-3.5.2.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 MyTest,a2
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
Class not found: org.jboss.vfs.VFS
JBoss 6 VFS API is not available in this environment.
Class not found: org.jboss.vfs.VirtualFile
VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
Using VFS adapter org.apache.ibatis.io.DefaultVFS
Find JAR URL: file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo
Not a JAR: file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo
Reader entry: Student.class
Reader entry: Teacher.class
Listing file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo
Find JAR URL: file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo/Student.class
Not a JAR: file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo/Student.class
Reader entry: ����   1 [
Find JAR URL: file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo/Teacher.class
Not a JAR: file:/D:/Study/ssmtools/mavan/mybatisTest04/mybatisTest0403/target/classes/com/pojo/Teacher.class
Reader entry: ����   1 I
Checking to see if class com.pojo.Student matches criteria [is assignable to Object]
Checking to see if class com.pojo.Teacher matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Opening JDBC Connection
Created connection 2044215423.
Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@79d8407f]
==>  Preparing: select * from mybatis4.student 
==> Parameters: 
<==    Columns: id, name, tid
<==        Row: 1, 小明, 1

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.dao.StudentMapper.getTeacher
### The error may exist in com/dao/StudentMapper.xml
### The error may involve com.dao.StudentMapper.getStudentInfo
### The error occurred while handling results
### SQL: select * from mybatis4.student
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.dao.StudentMapper.getTeacher

	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.invoke(MapperProxy.java:57)
	at com.sun.proxy.$Proxy5.getStudentInfo(Unknown Source)
	at MyTest.a2(MyTest.java:27)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	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: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.dao.StudentMapper.getTeacher
	at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:964)
	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:755)
	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:748)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNestedQueryMappingValue(DefaultResultSetHandler.java:743)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:465)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:441)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:404)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:354)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:328)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:301)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:194)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	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:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	... 28 more


Process finished with exit code -1

 后来发现问题都在mapper中 

常见问题 

1    sql的 ；问题 不要添加；

2写resultMap时 注意 是 数据库.表明

3 代码要写全 逻辑清晰 不要漏了  加注释就是我漏掉的内容

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.StudentMapper">

    <select id="getStudentInfo" resultMap="Student" >
        select * from mybatis4.student
    </select>

    <resultMap id="Student" type="Student">
        <result property="id" column="id"/>
        <result property="name" column="name"/>
        <association property="teacher" column="tid" javaType="Teacher" select="getTeacher"/>
    </resultMap>

<!--    <select id="getTeacher" resultType="Teacher">-->
<!--        select * from mybatis4.teacher where id=#{id}-->
<!--    </select>-->



</mapper>

问题解决啦！！！！！

kjshuan
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
ibatis-core-3.0.jar org.apache.ibatis.annotations.Param
01-05
搭建mybatis所需包org.apache.ibatis.annotations.Param @Param
解决org.apache.ibatis.binding.BindingException: Invalid bound statement (not found
10-16
出现以上的情况主要的原因是因为在主配置文件标签没正确的指向映射接口的配置文件。 解决方案：1.检查的name是否正确，如我的name属性填的就是com.it.dao 2、检查的class属性或resource属性，我resource这里写的是...
mybatis框架异常org.apache.ibatis.exceptions.PersistenceException ：全面解析
热门推荐
宜春
07-23 7万+
在学习mybatis框架中遇到了org.apache.ibatis.exceptions.PersistenceException问题，由于比较常见于测试映射文件，一不小心犯个小错就出现了，于是给自己总结一下，当然也希望对你有所帮助！！！ 分析 ...
org.apache.ibatis.exceptions.PersistenceException
梦之马
03-12 644
具体日志如下： org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConn...
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法
12-16
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法 一、问题描述 写好配置文件用JUnit进行测试，一运行就报错: org.apache.ibatis.exceptions.PersistenceException: ### Error querying ...
abc.rar_ABC_ibatis
最新发布
09-21
ibatis与hibernate的区别.很经典的
MyBatis异常org.apache.ibatis.exceptions.PersistenceException
a18792721831的博客
03-05 1万+
MyBatis测试映射文件时，非常的容易出现org.apache.ibatis.exceptions.PersistenceException异常。 解决方法：使用_parameter获取值。 完整的异常信息如下: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

kjshuan

点个赞就好啦！！！

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值