在用iBatis向DB2 character类型字段插入NULL值的时候报错:
2009-04-14 21:03:55,234 ERROR (com.delver.bms.card.service.CardManagerImpl:92) - org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [-99999];
--- The error occurred in com/delver/bms/card/dao/t_card_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the t_card.update-InlineParameterMap.
--- Check the parameter mapping for the 'priceType' property. iBatis 配置文件:
<insert id="insert" parameterClass="card">
insert into T_CARD
(ID,CARD_NO,CUSTOMER_NAME,PRICE_TYPE,REBATE_TYPE,
REBATE_LEVEL,SHOPGRADE_ID,POSTPAY_FLAG,CASHCARD_FLAG,CASH_AMOUNT,
CASH_TOTAL_RECHARGE,CASH_TOTAL_CONSUME,SCORE,CARD_TYPE,IDENTITY_TYPE,
IDENTITY_NO,ADDR,CREDIT_LEVEL,TEL,MOBILE,
BIRTHDAY,BIRTHDAY_FLAG,CUSTOMER_SEX,EMAIL,QQ_NO,
CUSTOMER_GROUP,REGISTER_DATE,REG_BRANCH,REG_STAFF,ISSUE_REASON,
VALIDITY_DATE,CARD_STATUS,UPDATE_DATE,OPERATOR,TENANTID)
values (#id:CHARACTER#,#cardNo:VARCHAR#,#customerName:VARCHAR#,#priceType:CHARACTER#,
#rebateType:INTEGER#,#rebateLevel:INTEGER#,#shopGradeId:CHARACTER#,
#postPayFlag:VARCHAR#,#cashCardFlag:VARCHAR#,#cashAmount:DECIMAL#,
#cashTotalRecharge:DECIMAL#,#cashTotalConsume:DECIMAL#,#score:DECIMAL#,
#cardType:VARCHAR#,#identityType:VARCHAR#,#identityNo:VARCHAR#,#addr:VARCHAR#,
#creditLevel:INTEGER#,#tel:VARCHAR#,#mobile:VARCHAR#,#birthday:DATE#,
#birthdayFlag:VARCHAR#,#customerSex:VARCHAR#,#email:VARCHAR#,#qqNo:VARCHAR#,
#customerGroup:CHARACTER#,#registerDate:DATE#,#regBranch:CHARACTER#,
#regStaff:CHARACTER#,#issueReason:VARCHAR#,#validityDate:DATE#,#cardStatus:VARCHAR#,
#updateDate:DATE#,#operator:CHARACTER#,#tenantId:VARCHAR#)
</insert>我试过定义一个paremeterMap也不行,请问用什么方法能够解决?
2009-04-14 21:03:55,234 ERROR (com.delver.bms.card.service.CardManagerImpl:92) - org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [-99999];
--- The error occurred in com/delver/bms/card/dao/t_card_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the t_card.update-InlineParameterMap.
--- Check the parameter mapping for the 'priceType' property. iBatis 配置文件:
<insert id="insert" parameterClass="card">
insert into T_CARD
(ID,CARD_NO,CUSTOMER_NAME,PRICE_TYPE,REBATE_TYPE,
REBATE_LEVEL,SHOPGRADE_ID,POSTPAY_FLAG,CASHCARD_FLAG,CASH_AMOUNT,
CASH_TOTAL_RECHARGE,CASH_TOTAL_CONSUME,SCORE,CARD_TYPE,IDENTITY_TYPE,
IDENTITY_NO,ADDR,CREDIT_LEVEL,TEL,MOBILE,
BIRTHDAY,BIRTHDAY_FLAG,CUSTOMER_SEX,EMAIL,QQ_NO,
CUSTOMER_GROUP,REGISTER_DATE,REG_BRANCH,REG_STAFF,ISSUE_REASON,
VALIDITY_DATE,CARD_STATUS,UPDATE_DATE,OPERATOR,TENANTID)
values (#id:CHARACTER#,#cardNo:VARCHAR#,#customerName:VARCHAR#,#priceType:CHARACTER#,
#rebateType:INTEGER#,#rebateLevel:INTEGER#,#shopGradeId:CHARACTER#,
#postPayFlag:VARCHAR#,#cashCardFlag:VARCHAR#,#cashAmount:DECIMAL#,
#cashTotalRecharge:DECIMAL#,#cashTotalConsume:DECIMAL#,#score:DECIMAL#,
#cardType:VARCHAR#,#identityType:VARCHAR#,#identityNo:VARCHAR#,#addr:VARCHAR#,
#creditLevel:INTEGER#,#tel:VARCHAR#,#mobile:VARCHAR#,#birthday:DATE#,
#birthdayFlag:VARCHAR#,#customerSex:VARCHAR#,#email:VARCHAR#,#qqNo:VARCHAR#,
#customerGroup:CHARACTER#,#registerDate:DATE#,#regBranch:CHARACTER#,
#regStaff:CHARACTER#,#issueReason:VARCHAR#,#validityDate:DATE#,#cardStatus:VARCHAR#,
#updateDate:DATE#,#operator:CHARACTER#,#tenantId:VARCHAR#)
</insert>我试过定义一个paremeterMap也不行,请问用什么方法能够解决?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货