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

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

Amit4 — Fri, 15 Nov 2024 21:06:48 GMT

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

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

Amit4 — Wed, 17 Jan 2024 10:22:55 GMT

@Shicong Hong Please have a look.

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

Anonymous — Thu, 18 Jan 2024 04:23:09 GMT

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-mappings

Here is a related topic:

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

Best regards

Sabrina

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

Amit4 — Thu, 18 Jan 2024 05:37:32 GMT

Yeah, I tried Guess schema is resolved.

Thanks!

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

Anonymous — Thu, 18 Jan 2024 07:06:38 GMT

Hello,

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

Best regards

Sabrina