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.
