Hey all,
Using EJB3 RC9-FD patch on 4.0.4.GA Jboss AS.
Trying to handle financial calculations and outside of database versions for querying
calculations, I'm definately having problems on the POJO side.
| public class SampleBean implements Serializable {
| ...
| @javax.persistence.Column(precision=8, scale=2)
| public BigDecimal getAmountPaid() {
| return amountPaid;
| }
|
After persisting data to the database (with the database fields configured as Decimal(8,2)
on both Mysql and Postgresql), the return results are not 'accurate', or as
expected.
After setting a value of '58.11' and persisting to the database, then trying to
retrieve after a Query (i.e. completely new object as the other has been cleaned up):
| System.out.println(SampleBean.getAmountPaid());
| -->58.1099999999999994315658113919198513031005859375
|
In the database, it stores correctly. Query-level mathimatical calculations are working
correctly (assuming the database doesn't use floating point optimizations on Decimal
fields, such as Mysql => 5.0.3). But retrieval of the value, EVEN WITH SCALE SET, is
not working as expected.
Is there something different I should be doing for handling monetary amounts in EJB3/JPA?
-D
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3976067#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...