【问题解决】Parameter index out of range (2 大于 number of parameters, which is 1)

最新推荐文章于 2025-06-16 09:33:14 发布

原创最新推荐文章于 2025-06-16 09:33:14 发布 · 3.8w 阅读

6 ·

CC 4.0 BY-SA版权

错误记录并解决专栏收录该内容

52 篇文章

订阅专栏

本文记录了一个因SQL语句中参数数量不匹配导致的应用错误，并详细解释了错误原因及修正过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

（1）错误描述：这个错误大概是说需要的参数是一个，而你传入了两个参数，导致了参数变多抛异常

2019-03-28 09:05:09.375 ERROR 287527 --- [nio-1601-exec-2] o.s.b.w.servlet.support.ErrorPageFilter : Forwarding to error page from request [/isvSearch/getSearchManagerInfoList] due to exception [nested exception is org.apache.ibatis.type.TypeException: 
Could not set parameters for mapping: ParameterMapping{property='venderId', mode=IN, javaType=class java.lang.Object, 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: 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).]

日志打印sql：

Preparing: SELECT DISTINCT app_key,channel_name FROM sms_channel 
WHERE ((entity_code = concat('B','?')) OR (entity_code = concat('P','?')))AND app_key=?

日志打印入参：

 查询ISV名称入参：venderId=6****2，appId=3FA3B5D**************D6C6215C6EE4

（2）错误解决

出现这种问题的最本质原因在入参跟需要传入的参数个数不一致，导致出现类似错误，多了少了的。

这时候我们应该先定位到相应位置，我这边入参传入的是String类型的，然后我在mybaits取入参的时候又加了一层引号导致它未检测到，传入两个参数而只有一个坑位，所以报错了。

原错误sql：

 @Select(
    "<script>SELECT DISTINCT app_key,channel_name FROM sms_channel" +
    " WHERE ((entity_code = concat('B'," + "'#{venderId}')) " +
    "OR (entity_code =  concat('P'," + "'#{venderId}')))" +
    "AND app_key=#{appId}</script>")

改正后sql：

 @Select(
 "<script>SELECT  app_key,channel_name,id,entity_code  FROM sms_channel " +
 "WHERE ((entity_code = concat('B'," + "#{venderId})) " +
 "OR (entity_code =  concat('P'," + "#{venderId}))) " +
 "AND app_key=#{appId}</script>")