Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameter

最新推荐文章于 2024-09-21 15:18:04 发布

原创最新推荐文章于 2024-09-21 15:18:04 发布 · 591 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #mybatis #servlet

ssm 专栏收录该内容

11 篇文章

订阅专栏

文章描述了一个在执行SQL查询时遇到的问题，错误信息涉及到MyBatis的PersistenceException，提示可能由于SQL语句中的注释导致参数设置异常，特别是参数索引超出范围。解决方案是删除SQL语句中的所有注释。

这个错误的解决办法就是删掉你的sql语句中的所有注释语句！！！！！

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='mohu', 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).
### The error may exist in com/zh/mapper/SpecialSQLMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='mohu', 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).