org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.Typ

最新推荐文章于 2023-07-09 00:34:31 发布

清欢ysy

最新推荐文章于 2023-07-09 00:34:31 发布

阅读量4.3k

点赞数 2

分类专栏：异常纪录

本文链接：https://blog.csdn.net/qq_33840251/article/details/88718119

版权

异常纪录专栏收录该内容

79 篇文章 4 订阅

订阅专栏

推荐阅读
●网站推荐
 ●软件推荐
 ●点击加入QQ群874514813交流学习，免费获取达内-黑马全套培训资料

异常信息

Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'categoryMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: categoryMap
    at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:103)
    at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:72)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118)
    ... 65 more
Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'categoryMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: categoryMap
    at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:117)
    at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:130)
    at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:101)
    ... 69 more
Caused by: java.lang.ClassNotFoundException: Cannot find class: categoryMap
    at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:190)
    at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89)
    at org.apache.ibatis.io.Resources.classForName(Resources.java:256)
    at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:113)
    ... 71 more

场景描述

resultMap
<resultMap id="categoryMap" type="category">
    <id property="id" column="a_id"/>
    <result property="name" column="a_name"/>
    <result property="parent_id" column="a_pid"/>
    <result property="species_num" column="a_count"/>
    <collection property="types" javaType="category">
        <id property="id" column="b_id"/>
        <result property="name" column="b_name"/>
        <result property="parent_id" column="b_pid"/>
        <result property="species_num" column="b_count"/>
    </collection>
</resultMap>
<select id="findOneCategory"  resultType="categoryMap">
    select a.id as a_id,a.name as a_name,a.parent_id as a_pid,a.species_num as a_count,b.id as b_id,b.name as b_name,b.parent_id as b_pid,b.species_num as b_count from category a inner join category b on a.id =b.parent_id
</select>

异常原因

自定义的resultMap问题，应该把下面的resultType改为resultMap

解决方案

resultMap id="categoryMap" type="category">
    <id property="id" column="a_id"/>
    <result property="name" column="a_name"/>
    <result property="parent_id" column="a_pid"/>
    <result property="species_num" column="a_count"/>
    <collection property="types" javaType="category">
        <id property="id" column="b_id"/>
        <result property="name" column="b_name"/>
        <result property="parent_id" column="b_pid"/>
        <result property="species_num" column="b_count"/>
    </collection>
</resultMap>
<select id="findOneCategory"  resultMap="categoryMap">
    select a.id as a_id,a.name as a_name,a.parent_id as a_pid,a.species_num as a_count,b.id as b_id,b.name as b_name,b.parent_id as b_pid,b.species_num as b_count from category a inner join category b on a.id =b.parent_id
</select>