tFileInputJSON: no Getter for field scale in class BigDecimal
Hello,
I'm reading some JSON files using tFileInputJSON component configured as the attached screenshot.
The problem is: whenever a file has numeric values with large decimal scale like 0.39268000000000003 and not enclosed by double quotes, I get the following exception:
java.lang.RuntimeException: no Getter for field scale in class java.math.BigDecimal
This happens no matter the data type configured in the component schema, even if everything is configured as String data type.
Here is a sample of the file:
{
"cemaden":
}
The cause of this exception is highlighted in bold. If this field is enclosed by double quotes, the file is read without errors.
Is there a way to overwhelm this exception without editing the file?
Thanks in advance.
Anselmo
Hello guys,
I'm having the exact same issue with the tExtractJSONFields component, and followed these steps:
upgrading Talend to 6.3.0
updating 3 components (
accessors-smart-1.1,
asm-5.0.3 and
json-smart-2.2.1)
But no luck so far.. I can not even use Xpath instead of JsonPath because it throws the "Cannot determine next state" error reported above.
Has any of you found a workaround until the 6.3.1 release is available ?
Thanks for your tips,
Maxime.