ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j-lists <jamisonli...@gmail.com>
Subject Re: BigDecimal conversion exception wth DB2
Date Fri, 04 Jan 2008 06:23:23 GMT
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 <gaurav.i2it@gmail.com> 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.
>
>

Mime
View raw message