SEVERE: #{MarginRuleEntry.btnSave_action}: javax.faces.el.EvaluationException: com.ibatis.dao.client.DaoException: Failed to update - id [updateMarginRuleDetail] - parameterObject [idx : 3marginruleid : null auid : 13 cpartyid : 0 initmargin : 1.0E+18 margin : 999999999999999999 granularity : null exid : null entryid : admin modidx : nullauuserid : null acronym : null indate : 2008-01-04 10:31:59.406002 efdate : 2008-01-04 10:31:59.406002 exdate : null]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in Common/reference/MarginRuleDetailSqlMap.xml. --- The error occurred while applying a parameter map. --- Check the updateMarginRuleDetail-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.ibm.db2.jcc.b.SqlException: BigDecimal conversion exception [ibm][db2][jcc][converters] Overflow occurred during numeric data type conversion of "1.0E+18".. See attached Throwable. Caused by: com.ibm.db2.jcc.b.SqlException: BigDecimal conversion exception [ibm][db2][jcc][converters] Overflow occurred during numeric data type conversion of "1.0E+18".. See attached Throwable. javax.faces.FacesException: #{MarginRuleEntry.btnSave_action}: javax.faces.el.EvaluationException: com.ibatis.dao.client.DaoException: Failed to update - id [updateMarginRuleDetail] - parameterObject [idx : 3marginruleid : null auid : 13 cpartyid : 0 initmargin : 1.0E+18 margin : 999999999999999999 granularity : null exid : null entryid : admin modidx : nullauuserid : null acronym : null indate : 2008-01-04 10:31:59.406002 efdate : 2008-01-04 10:31:59.406002 exdate : null]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in Common/reference/MarginRuleDetailSqlMap.xml. --- The error occurred while applying a parameter map. --- Check the updateMarginRuleDetail-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.ibm.db2.jcc.b.SqlException: BigDecimal conversion exception [ibm][db2][jcc][converters] Overflow occurred during numeric data type conversion of "1.0E+18".. See attached Throwable. Caused by: com.ibm.db2.jcc.b.SqlException: BigDecimal conversion exception [ibm][db2][jcc][converters] Overflow occurred during numeric data type conversion of ":-/
in databse i created a column of type decimal and size is 32,6 -- View this message in context: http://www.nabble.com/BigDecimal-conversion-exception-wth-DB2-tp14611156p14611156.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.