Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
来源:互联网 发布:人工智能图像理解 编辑:程序博客网 时间:2024/05/20 04:31
情景:
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 拼接一下否则 解析不了 出现异常
CONCAT('%',#{times},'%'))
阅读全文
0 0
- Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
- Caused by: java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException Parameter index out of range (9 > number of parameters, which is 8)
- BIRT出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)的问题
- 造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
- 解决ava.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)类似问题
- 未重新服务器而导致的错误java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is
- sql异常之Parameter index out of range (1 > number of parameters, which is 0)
- MySQL 报错:Parameter index out of range (2> number of parameters, which is 1)
- Parameter index out of range (2 > number of parameters, which is 1).
- Parameter index out of range (2 > number of parameters, which is 1)
- mysql Parameter index out of range (2 > number of parameters, which is 1).
- 高性能Server---Reactor模型
- php结合redis实现高并发下的抢购、秒杀功能
- Android开发之----proloader
- C语言——希尔排序
- lower_bound()返回值
- Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
- TextView_跑马灯
- 白话经典算法系列之九 从归并排序到数列的逆序数对(微软笔试题)
- Spring依赖注入(dependency injection)
- 马尔科夫与隐马尔可夫总结
- Hoj 2010 GCD & LCM Inverse
- CSS样式初始化分为PC端和移动APP端
- mysql索引类型normal,unique,full text的区别是什么?
- 【ActiveMQ】ActiveMQ 管理页面点消息ID提示Error