Ibatis错误 The error happened while setting a property on the result object解决方法
今天遇到了一个问题,用Ibatis查询时,总是出现这个错误。对于异常信息,又没有明确指出是哪一个result属性出错。然后我用了最笨的方法,一行行的排除,终于在将<result property="paymentCash" column="PAYMENT_CASH"/>去掉后这个错误没有出现了。然后,我仔细看了数据库,这个字段是nullable的,然后数据有多条记录这个字段的值是空的,但是并不是null。然后我将<result property="paycash" column="PAYMENT_CASH" nullValue="0"/> 问题完全解决。
?
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in com/tongcard/tcc/report/ibatis/consumeReport_SqlMap.xml. --- The error occurred while applying a result map. --- Check the ConsumeReport_Map.consumeDetailsMap. --- The error happened while setting a property on the result object. --- Cause: net.sf.cglib.beans.BulkBeanException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/tongcard/tcc/report/ibatis/consumeReport_SqlMap.xml. --- The error occurred while applying a result map. --- Check the ConsumeReport_Map.consumeDetailsMap. --- The error happened while setting a property on the result object. --- Cause: net.sf.cglib.beans.BulkBeanException
?