Invalid bound statement (not found)

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): org.conjure.mapper.CategoryMapperCustom.getSubCatList

收起

5回答

一叶梧桐秋 2023-09-18 15:40:27

楼主，我也碰到这问题，你的现在解决了吗

心中有个梦 2020-08-07 11:46:05

是不是需要maven install 一下

xxxycl 2020-05-02 13:48:04

可以看一下org.conjure.pojo.vo.CategoryVO中的那个List是什么吗

提问者 _QhD 2020-04-25 23:16:14

1. mapper namespace 确认无误

namespace="org.conjure.mapper.CategoryMapperCustom"

Copy Reference 得到 "org.conjure.mapper.CategoryMapperCustom"

<select id="getSubCatList" ... 对比

public List<CategoryVO> getSubCatList(Integer rootCatId);

resultMap="myCategoryVO" 对比

mapper-locations: mapper/*.xml 改为 mapper-locations: classpath:org/conjure/mapper/*.xml

结果还是一样报错：

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): org.conjure.mapper.CategoryMapperCustom.getSubCatList

风间影月 2020-04-25 23:11:52

检查你的mapper里是否有重复id

提问者 _QhD #1

没有重复id <mapper namespace="org.conjure.mapper.CategoryMapperCustom" > <resultMap id="myCategoryVO" type="org.conjure.pojo.vo.CategoryVO"> <id column="id" property="id"/> <result column="name" property="name"/> <result column="type" property="type"/> <result column="fatherId" property="fatherId"/>  <collection property="subCatList" ofType="org.conjure.pojo.vo.SubCategoryVO"> <id column="subId" property="subId"/> <result column="subName" property="subName"/> <result column="subType" property="subType"/> <result column="subFatherId" property="subFatherId"/> </collection> </resultMap> <select id="getSubCatList" resultMap="myCategoryVO" parameterType="int"> SELECT f.id as id, f.`name` as `name`, f.type as type, f.father_id as fatherId, c.id as subId, c.`name` as subName, c.type as subType, c.father_id as subFatherId FROM category f LEFT JOIN category c on f.id = c.father_id WHERE f.father_id = #{rootCatId} </select> </mapper>

2020-04-25 23:20:22
seU 回复提问者 _QhD #2

建议你搜索一下 namespace 的包路径可能是标点符号引起的我也是这个问题结果发现是包路径在namespace搜索匹配不了

2020-08-05 20:42:08