[JIRA] Closed: (OFBIZ-565) DerbyDB truncates the values inserted in a numeric field instead of approximating them.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[JIRA] Closed: (OFBIZ-565) DerbyDB truncates the values inserted in a numeric field instead of approximating them.

JIRA jira@ofbiz.org
     [ http://jira.undersunconsulting.com/browse/OFBIZ-565?page=all ]
     
Jacopo Cappellato closed OFBIZ-565:
-----------------------------------

    Resolution: Duplicate

The right answer is to use BigDecimal... there are others task about the migration to BD so I'll close this issue.

> DerbyDB truncates the values inserted in a numeric field instead of approximating them.
> ---------------------------------------------------------------------------------------
>
>          Key: OFBIZ-565
>          URL: http://jira.undersunconsulting.com/browse/OFBIZ-565
>      Project: [OFBiz] Open For Business
>         Type: Bug
>   Components: entity, order
>  Environment: DerbyDB
>     Reporter: Jacopo Cappellato
>     Assignee: Jira Administrator

>
>
> DerbyDB truncates the values inserted in a numeric field instead of approximating them: see http://db.apache.org/derby/docs/10.0/manuals/reference/sqlj132.html
> Since the general approach in OFBiz is that of using db approximations (instead of doing them in the code), this is not a good thing because other databases (e.g. MaxDB/SapDB) perform approximations instead of truncations in the same situations.
> So switching from DerbyDB to another one could lead to different calculations.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira