错误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的方法返回值类型