I am working with an Oracle database and number column are translated to BigDecimal in java. But I always have a type mismatch.
Is there a workaround ? Besides, the number column is the PK and is loaded with an oracle sequence.
I might put this as bug because the bigdecimal type is used by default when i retrieve a schema from oracle in the metadata repository
INT, INTEGER and even SMALLINT are sub-types or synonyms of NUMBER, ...
Type mismatch. cannot convert from long to Bigdecimal.
L4 cannot be resolved ...
Try with below expression for the Big Decimal coloumn:
hope this will resolve your error.