Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1

最新推荐文章于 2024-07-25 19:03:53 发布

IT打工匠

最新推荐文章于 2024-07-25 19:03:53 发布

阅读量5.1k

点赞数 2

本文链接：https://blog.csdn.net/lu_wei_wei/article/details/76653291

版权

Mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

情景：

mybatis语句

AND (p.times_limited='NO' OR (p.times_limited='YES' AND times LIKE '%#{times}%'))

异常信息：

Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='times', mode=IN, javaType=class java.lang.Integer, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 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 (2 > number of parameters, which is 1).

解决方法：
需要将like 拼接一下否则解析不了出现异常