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] Created: (OPENJPA-686) Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase
Date Fri, 08 Aug 2008 22:02:44 GMT
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


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