Save BigDecimal in jpa

Asked Jul 06 '16 at 03:28

Active Jul 06 '16 at 10:21

Viewed 927 times

I use spring jpa and hibernate 4 for the implementation.

In a object, I have a bigDecimal field.

Before saving this field, I see the value: 0.09975.

When it's saved in mariadb, the value is 0.10.

In my objet

private BigDecimal tvqRate;

Jpa have created the table automatically

like a decimal
column size is 19, 
2 decimal digits.

I use spring data repository to save object.

How to save correctly the value?

edited Jul 06 '16 at 10:21

asked Jul 06 '16 at 03:28

bernard deromme

1

where is your column definition, and what annotations/XML have you specified for the field? – Neil Stockton Jul 06 '16 at 06:44
I just specified the type of the objet and jpa have created all the rest. – bernard deromme Jul 06 '16 at 10:28
1

maybe will need to put something like @Column(precision=6, scale=5) to be able to save something like 0.09975 – bernard deromme Jul 06 '16 at 13:06
maybe you do, and what happens when you try it? those attributes affect the generation of schema, so you have to perform that part – Neil Stockton Jul 06 '16 at 13:11
`SHOW VARIABLES LIKE 'div_precision_increment';` `SHOW CREATE TABLE` – Rick James Jul 09 '16 at 18:05

0 Answers0