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