Invalid bound statement (not found) 异常原因
来源:互联网 发布:淘宝宝贝描述图片像素 编辑:程序博客网 时间:2024/05/18 03:07
mybatis报错如下:
2、接口路径问题:
3、没有映射:
4、DAO层方法名和xml中的id不同
5、返回类型resultMap在xml中未声明
org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcherServlet] in context with path [/zc-beauty2] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.zc.beauty.dao.ICaptchaMapper.savePhoneCode] with root cause org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
原因如下:
1、没有加载mapper文件:
<mappers> <mapper resource="mappers/CaptchaMapper.xml" /> </mappers>
2、接口路径问题:
<!-- 这里namespace必须是接口的路径,不然要运行的时候要报错 “is not known to the MapperRegistry”--> <mapper namespace="com.zc.beauty.dao.ICaptchaMapper">
3、没有映射:
<bean id="CaptchaMapper" class="org.mybatis.spring.mapper.MapperFactoryBean" > <property name="sqlSessionFactory" ref="SqlSessionFactory" /> <property name="mapperInterface" value="com.zc.beauty.dao.ICaptchaMapper" /> </bean>
4、DAO层方法名和xml中的id不同
<!-- 这里的id必须和接口中的方法名相同,不然运行的时候也要报错 --> <insert id="savePhoneCode" parameterType="com.zc.beauty.model.PhoneCaptcha"> insert into phone_captcha(u_phone, c_phonecode, c_sendtime) values(#{u_phone}, #{c_phonecode}, #{c_sendtime}) </insert>
5、返回类型resultMap在xml中未声明
<resultMap id="RecsortChnResultMap" type="com.caissa.erp.caissafip.domain.basic.recsortchnconfig.po.RecsortChnConfigVo" > <id column="DBID" property="dbid" jdbcType="CHAR" /> <result column="FK_RECCHN_DBID" property="fkRecchnDbid" jdbcType="CHAR" /> <result column="UPDATEDEPTNAME" property="updatedeptname" jdbcType="VARCHAR" /> </resultMap><select id="selectChnRectypeByConfigDbid" resultMap="ChnRectypeResultMap" parameterType="java.lang.String">SELECT CRR.DBID, recsort.RECSORTNAME, chn.CHNNAME, rectype.RECTYPENAME,CRR.FK_CONFIG_DBID,CRR.FK_RECTYPE_DBID,rcconfig.FK_RECCHN_DBID,rcconfig.FK_RECSORT_DBID,rcconfig.ISRECEIVABLE,rcconfig.RECEIVABLECOMPANYCODE,rcconfig.RECEIVABLECOMPANYNAMEFROM FI_BS_CHN_RECTYPE_REF CRR LEFT JOIN FI_BS_RECSORT_CHN_CONFIG rcconfig on CRR.FK_CONFIG_DBID = rcconfig.dbidleft join FI_DC_RECEIVESORT recsort on recsort.dbid = rcconfig.FK_RECSORT_DBID and recsort.delflag = '1'left join FI_BS_CHN chn on chn.dbid = rcconfig.FK_RECCHN_DBID and chn.delflag = '1' left join FI_DC_RECEIVETYPE rectype on rectype.dbid = crr.FK_RECTYPE_DBID and rectype.delflag = '1'WHERE RCCONFIG.DELFLAG = '1' AND CRR.DELFLAG = '1'AND RCCONFIG.DBID = #{fkConfigDbid, jdbcType=VARCHAR} </select>
0 0
- Invalid bound statement (not found) 异常原因
- mybatis 异常:Invalid bound statement (not found) .
- Invalid bound statement (not found): 异常
- Mybatis异常:Invalid bound statement (not found)
- mybatis 异常 Invalid bound statement (not found)
- Invalid bound statement (not found):
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- Invalid bound statement (not found)
- invalid bound statement (not found)
- Invalid bound statement (not found)
- HBase详细介绍
- 解决:Cmake配置CGAL1.62.0出错
- 【C++面向对象】C++中成员函数的const属性
- Android 固定头部的ListView以及下拉刷新(附源码)
- 字体的应用
- Invalid bound statement (not found) 异常原因
- Android 根据EditText搜索框ListView动态显示数据
- Java SPI机制实践
- 《多线程编程》学习之二:Thread.currentThread()、isAlive()、Thread.sleep()的使用
- ERROR: JDWP Unable to get JNI 1.2 environment, jvm->GetEnv() return code = -2
- 如何卸载ninja?
- Eight Ways Your Android App Can Leak Memory
- redhat固定ip地址
- GANs学习系列(5): 生成式对抗网络Generative Adversarial Networks