nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping:

最新推荐文章于 2025-04-11 11:25:05 发布

jacka03

最新推荐文章于 2025-04-11 11:25:05 发布

阅读量3.1k

点赞数 1

文章标签： mysql mybatis error

本文链接：https://blog.youkuaiyun.com/weixin_43644231/article/details/119836672

版权

error信息

 [DUBBO] Decode decodeable message com.alibaba.dubbo.rpc.protocol.dubbo.DecodeableRpcResult, dubbo version: 2.6.0, current host: 192.168.48.1
java.lang.RuntimeException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='code', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #9 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (9 > number of parameters, which is 8).
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='code', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #9 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (9 > number of parameters, which is 8).
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)

原因：
在这里插入图片描述
在dao.xml中编写sql语句有注释，而注释中包含了#{}参数。
mybatis执行时仍然把里面的#{code}执行了，导致报错，参数异常，需要参数与实际传参不一致导致错误。
可以删除或者尝试使用