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


    --- 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>

     

     


  • 相关阅读:
    googleMapReduce
    leveldb0
    大端模式和小端模式
    信号
    js中判断对象类型的几种方法
    js DOM之基础详解
    JavaScript作用域与闭包总结
    SCRIPT438: 对象不支持“trim”属性或方法
    JS合并多个数组去重算法
    js的 break 和 continue 计算问题
  • 原文地址:https://www.cnblogs.com/archie2010/p/1909241.html
Copyright © 2020-2023  润新知