openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Lee (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (OPENJPA-686) Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase
Date Mon, 11 Aug 2008 16:24:44 GMT

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


Mime
View raw message