[jira] Resolved: (OPENJPA-686) Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase

["Albert Lee (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OPENJPA-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Albert Lee resolved OPENJPA-686.
--------------------------------

    Resolution: Fixed

> Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase
> -----------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-686
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-686
>             Project: OpenJPA
>          Issue Type: Improvement
>    Affects Versions: 1.0.3, 1.1.0, 1.2.0
>            Reporter: Fay Wang
>            Assignee: Fay Wang
>            Priority: Minor
>             Fix For: 1.2.1, 1.3.0
>
>         Attachments: openjpa_686.patch
>
>
> Applications performing update/insert data of the BigDecimal java type may fail with OptimisticException if the the 
> data exceeds the scale or precision of the db column on Sybase,. 
> The Sybase behavior is working as documented, as shown in the following link:
> http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/3524;pt=693/* 
> In Openjpa, it is not possible to specify precision/scale for the column mapped by a BigDecimal type. 
> However, applications can specify the plugin value for the column type mapped by the BigDecimal java type:
> http://openjpa.apache.org/docs/latest/manual/manual.html#openjpa.jdbc.DBDictionary
> to avoid this trunction error problem. 
> It is desirable to update the "database restrictions" section of the openjpa manual for this Sybase-specific trunction problem.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.