topic Re: cannot convert from int to BigDecimal in Talend Studio

cannot convert from int to BigDecimal

Anonymous — Wed, 23 Mar 2016 11:06:40 GMT

I am trying to insert some records in oracle table as target and it has one NUMBER type column.
The field is not null type so I am trying to insert default value 0 from mapping. I have created one variable in tmap with dataype integer and have put 0 in expression.
I have not set BigDecimal in table or in variable still it is giving error like below
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Type mismatch: cannot convert from int to BigDecimal
Please give suggestion to resolve this error.
Thanks.

Re: cannot convert from int to BigDecimal

Anonymous — Thu, 24 Mar 2016 07:45:25 GMT

Hi,

The field is not null type so I am trying to insert default value 0 from mapping. I have created one variable in tmap with dataype integer and have put 0 in expression.
I have not set BigDecimal in table or in variable still it is giving error like below

It seems something wrong with you expression. Could you please post your tMap editor screenshot into forum which will be helpful for us to address your issue?
Best regards
Sabrina

Re: cannot convert from int to BigDecimal

Anonymous — Wed, 06 Apr 2016 10:02:58 GMT

Hi,
It got resolved. Talend has assumed the datatype as bigdecimal though it was not in datatype. I have update it from metadata and tmap so it is now working fine.
Thanks.