[jira] Assigned: (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 reassigned OPENJPA-686:
----------------------------------

    Assignee: Fay Wang

> 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
>            Reporter: Fay Wang
>            Assignee: Fay Wang
>            Priority: Minor
>         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.