java.sql.SQLException:Invalid column type: getBigDecimal not implemented for class oracle.jdbc.driver.T4CDateAccessor

[Amit4]

Hi,

I am facing this issue in a job having error:

java.sql.SQLException:Invalid column type: getBigDecimal not implemented for class oracle.jdbc.driver.T4CDateAccessor

I am facing error in my input table.

Below is my input table schema:

The columns which are BigDecimal are NUMBER data type in Database side.

Please provide some assistance. Thanks in advance!

Best Regards,

Amit

[Amit4]

@Shicong Hong​ Please have a look.

[Anonymous · Accepted solution]

Hello,

Could you please try to change the schema on the Oracle in Talend Studio figure out if its ALL the BigDecimal type failing or just one of the columns?

(you may need to modify in "Metadata of Talend Type" under project settings)

When you created the schema, did you select "Guess schema"?

https://help.talend.com/r/en-US/8.0/studio-user-guide/accessing-mapping-files-and-defining-type-mapp...

Here is a related topic:

https://community.talend.com/s/feed/0D53p00007vClJECA0?language=en_US

Best regards

Sabrina

[Amit4]

Yeah, I tried Guess schema is resolved.

Thanks!

[Anonymous]

Hello,

Great it is resolved and feel free to let us know if there is any further help we can give.

Best regards

Sabrina