i have a problem to get exact number value using BigDecimal class in Hibernate

Question

I have one variable which is BigDecimal abc and i have store in database with column_name is ( abc decimal(30,20) ) using Hibernate. so when i save data with abc variable and value = 00.0000000000 it will store in database perfectly, but when i get from database using Hibernate it will store as 0E-10 in BigDecimal abc but i need exact store value in database.

if any one have solution for above problem ??

i have already try to seach in google and also in stackoverflow.

How are you converting the value when writing/reading from/to the database? — Lino, Feb 05 '19 at 12:45
0E-10 is 0 to the precision of 10 decimal places, as you provided in your input, so seems to me like this is actually a more precise result than simply it returning 0 — obermillerk, Feb 05 '19 at 12:46
@Antoniossss problem is i need exact value 0.00.0000000000 not 0E-10. — Sagar, Feb 05 '19 at 13:02

score 1 · Answer 1 · answered Feb 05 '19 at 12:45

1

As explained here, Double Multiplication can get the unexpected result. You will have to store it as string and when you retrieve it, you made the conversion and it will conserve the right value.

answered Feb 05 '19 at 12:45

Jonathan Gagne

4,241
5
18
30

What is wrong with 0*1^-10 ? What is unexpected about it? – Antoniossss Feb 05 '19 at 12:45

i have a problem to get exact number value using BigDecimal class in Hibernate

1 Answers1