java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.XXXX

 Unable to start embedded container; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'webConfig': Unsatisfied dependency expressed through field 'myStatisticsListener': Error creating bean with name 'myStatisticsListener': Unsatisfied dependency expressed through field 'projectPhaseDao': Error creating bean with name 'projectPhaseDao' defined in file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\cn\com\teacher\dao\ProjectPhaseDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'projectPhaseDao' defined in file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\cn\com\teacher\dao\ProjectPhaseDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'myStatisticsListener': Unsatisfied dependency expressed through field 'projectPhaseDao': Error creating bean with name 'projectPhaseDao' defined in file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\cn\com\teacher\dao\ProjectPhaseDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'projectPhaseDao' defined in file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\cn\com\teacher\dao\ProjectPhaseDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [cn/com/teacher/config/MybatisConfig.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [E:\PROJECT\JTYLearningManagement\target\ROOT\WEB-INF\classes\mybatis\DownLoadFileMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving JdbcType. Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.STRING

解决办法

mapper.xml文件中的

sql语句数据类型拼错了

<select id="findFile" resultType="cn.com.teacher.entity.DownLoadFile">
    select file_id,file_url,create_time,
    from download_file
    where doc_name=#{fileName,jdbcType=VARCHAR}
    and doc_type=#{fileType,jdbcType=  VARCHR };
</select>

第四行语句少了一个A

详细文章请参考

Mybatis——No enum constant org.apache.ibatis.type.JdbcType.XXX的解决办法_Searchin_R的博客-CSDN博客_org.apache.ibatis.type.jdbctype.int