This is really just a database/jdbc problem, nothing to do with ibatis
itself. You probably have a precision problem relating to your
fraction (that is too small to show up in the 1.0E+18), setting the
scale on the BigDecimal before sending it to the database might sort
that out for you.
-J
On Jan 4, 2008 1:24 PM, chunnu <[EMAIL PROTECTED]> wrote:
>
> 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.
>
>
