java mapping for oracle number type

Question

I have database with oracle number type. Could there any possible issues with using java Double when updating table with numeric column. Should i switch BigDecimal or Double is approriate type.

As I fas as I know, BigDecimal is used when arbitrary precision required, when deal with prices for example.

Consider simple API updatePrice(Double d) Should i persist double as is or BigDecimal.valueOf(d) is preferable ?

there is no point in converting imprecise Double numbers to precise but wrong BigDecimals... — Aprillion
– Aprillion, Commented Jul 1, 2012 at 21:14

Aprillion · Accepted Answer · 2014-08-01 10:50:57Z

2

If you want precision use BigDecimal for arbitrary decimal points.

But the comment of @Aprillion is right: if you do a Java calculation containing doubles then you lose precision, even if the persistence data type is in BigDecimal format.

So use BigDecimal just if you want to ensure proper decimal precision from/to that field.

I hope this helps!

edited Aug 1, 2014 at 10:50

Aprillion

22.4k6 gold badges59 silver badges94 bronze badges

answered Jul 2, 2012 at 13:15

Vincenzo Maggio

3,86928 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java mapping for oracle number type

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related