openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-686) Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase
Date Fri, 08 Aug 2008 23:58:44 GMT

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

Fay Wang updated OPENJPA-686:
-----------------------------

    Attachment: openjpa_686.patch

The attached patch contains the update on the openjpa manual for this problem.

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


Mime
View raw message