MyBatis使用的错误 A query was run and no Result Maps were found for the Mapped Statement it’s likely that

错误1:There is no getter for property named ‘…’ in ‘class …’

### Error querying database.  Cause: org.apache.ibatis.reflection.ReflectionException: 
There is no getter for property named 'values' in 'class java.lang.String'  
### Cause: org.apache.ibatis.reflection.ReflectionException: 
There is no getter for property named 'values' in 'class java.lang.String'  
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)  
......

错误原因:Mapper文件中 #{id}, #{title}, #{type} …接收输入参数的内容有单词拼写错误

错误2:Expected one result (or null) to be returned by selectOne(), but found: 7
org.apache.ibatis.exceptions.TooManyResultsException: 
Expected one result (or null) to be returned by selectOne(), but found: 7  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)  
    at com.sniper.mybatis.first.MybatisFirst.findUserByName(MybatisFirst.java:86)  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 

错误原因:结果集中包含了多条记录,不应该使用selectOne,应该使用selectList

错误3:A query was run and no Result Maps were found for the Mapped Statement ‘test.insertUser!selectKey’. It’s likely that neither a Result Type nor a Result Map was specified.
### Error updating database.  Cause: org.apache.ibatis.executor.ExecutorException: 
A query was run and no Result Maps were found for the Mapped Statement 'test.insertUser!selectKey'.  
It's likely that neither a Result Type nor a Result Map was specified.  

### The error may exist in sqlmap/User.xml  
### The error may involve test.insertUser!selectKey  
### The error occurred while handling results  
### SQL: SELECT LAST_INSERT_ID()  
### Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'test.insertUser!selectKey'.  It's likely that neither a Result Type nor a Result Map was specified.  
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:172)  
.....

错误原因:Mapper文件中没有指定返回的类型

错误4:Type interface com.sniper.mybatis.mapper.UserMapper is not known to the MapperRegistry.
org.apache.ibatis.binding.BindingException: Type interface com.sniper.mybatis.mapper.UserMapper is not known to the MapperRegistry.  
    at org.apache.ibatis.binding.MapperRegistry.getMapper(MapperRegistry.java:47)  
    at org.apache.ibatis.session.Configuration.getMapper(Configuration.java:689)  
    at org.apache.ibatis.session.defaults.DefaultSqlSession.getMapper(DefaultSqlSession.java:250)  
......

错误原因:mapper.xml问没有注册到到mybatis的配置文件中

错误5:Could not resolve type alias ‘users’. Cause: java.lang.ClassNotFoundException: Cannot find class: users
### Error building SqlSession.  
### The error may exist in mapper/UserMapper.xml  
### Cause: org.apache.ibatis.builder.BuilderException: 
Error parsing SQL Mapper Configuration. 
Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'users'.  
Cause: java.lang.ClassNotFoundException: Cannot find class: users  
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)  
    at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:82)  
 ......

错误原因:类路径或者别名写错了

错误5:Mapping is missing column attribute for property null
### Error building SqlSession.  
### The error may exist in com/sniper/mybatis/mapper/OrdersCustomMapper.xml  
### The error occurred while processing mapper_resultMap[OrdersUserResultMap]_association[user]  
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. 
    Cause: java.lang.IllegalStateException: Mapping is missing column attribute for property null  
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)  
    at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:82)  
......

错误原因:
映射文件格式有问题
1.检查mapper.xml文件里的方法有没有resultType
2.如果是注解方式请检查mapper的方法返回值类型

  • 11
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值