[
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.
