java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

最新推荐文章于 2023-11-23 23:18:48 发布

转载最新推荐文章于 2023-11-23 23:18:48 发布 · 94 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/archie2010/archive/2010/12/17/1909241.html

文章标签：

#java

本文记录了一次使用ibatis框架时遇到的SQL参数映射错误，详细介绍了错误发生的原因及解决过程。作者通过检查SQL语句和参数映射配置，发现了一个未正确设置参数的SQL插入语句，最终通过修正SQL语句中的参数占位符解决了问题。

--- The error occurred in sqlMap/adInfo.xml.
--- The error occurred while applying a parameter map.
--- Check the insertAdInfo-InlineParameterMap.
--- Check the parameter mapping for the 'clicks' property.
--- Cause: 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).
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)

查了很久，才发现写了一个很傻的sql { } ..............唉

<insert id="insertAdInfo" parameterClass="com.tq365.vo.AdInfo">
insert into
ad_info(
clicks,
impressions,
clicksRate,
costPerClick,
cost,
averagePosition,
conversions,
costMConversions,
conversionsRate,
googleAdId,
insertTime
)values{
#clicks#,
#impressions#,
#clicksRate#,
#costPerClick#,
#cost#,
#averagePosition#,
#conversions#,
#costMConversions#,
#conversionsRate#,
#googleAdId#,
#insertTime#
}
</insert>

转载于:https://www.cnblogs.com/archie2010/archive/2010/12/17/1909241.html