Mybatis利用配置文件方式常见错误

 1. Caused by: java.lang.ClassNotFoundException: Cannot find class: VARCHAR

Caused by: java.lang.ClassNotFoundException: Cannot find class: VARCHAR
	at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:200)
	at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89)
	at org.apache.ibatis.io.Resources.classForName(Resources.java:261)
	at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:116)
	... 75 more

错误排查:请查看结果集jdbcType和javaType是否弄错了.

这里是jdbcType而不是javaType

2.  Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.Integer

Caused by: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.Integer
	at java.lang.Enum.valueOf(Enum.java:238)
	at org.apache.ibatis.type.JdbcType.valueOf(JdbcType.java:25)
	at org.apache.ibatis.builder.BaseBuilder.resolveJdbcType(BaseBuilder.java:71)
	... 80 more

错误排查:查看jdbcType的类型是否写错了(一定要区分大小写)

这里"jdbcTye=INTEGER"而不是“jdbcTye=Integer”

3.org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): 

 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.imooc.dataobject.mapper.ProductCategoryMapper.selectByCategoryType

错误排查:排查配置文件中是否加入了mybatis的配置