An java object field with type BigDecimal, set value of 2.4727E-9. It's mapped to an Oracle table field with type of number(16,13).
After it's saved, I find the value in the DB table changes to 2.6424E-9.
It's strange that everytime I retrieve this DB field with hibernate into java BigDecimal, the values becoms small than 2.6424E-9.. And the value becomes smaller and smaller after it's retrieved multi-times.
When I change the object field type to double, this problem disappear.
This field will be used in a big financial system, the precsion is very important, the double type is not acceptable. This problem trouble me so much, any one can help me?
Thanks a lot
|