topic Re: insert BigDecimal into table in Talend Studio

insert BigDecimal into table

Anonymous — Fri, 11 Sep 2015 13:08:32 GMT

I am trying to insert BigDecimal into table. But the value which get inserted in table has precision value 4.
The value which should get inserted is like 49.5365 but the value get inserted is 49.5400. Can you please help me out.
The table has a column with datatype as Number(16,4).
I dont want to change table structure.

Re: insert BigDecimal into table

Anonymous — Wed, 16 Sep 2015 07:43:26 GMT

Hi,

Could you please show us your screenshot of schema setting in DB component? What's DB type you are using? Does this issue repro on other studio?
Best regards
Sabrina

Re: insert BigDecimal into table

Anonymous — Wed, 16 Sep 2015 08:31:31 GMT

hi all,

some precision about BigDecimal. It's a java Object.
It's the only type in java to manipulate decimal with no loosing 'precision'.
So it's not a problem from your type in table (except if you try to insert decimal into integer

Have a llok about this java Object at
http://docs.oracle.com/javase/7/docs/api/java/math/BigDecimal.html
espacially about roundingmode : http://docs.oracle.com/javase/7/docs/api/java/math/RoundingMode.html

an example on stackoverflow : http://stackoverflow.com/questions/3843440/bigdecimal-setscale-and-round

regards
laurent