topic Re: Error java.sql.SQLDataException: [Amazon][JDBC](10400) Invalid type for data - column: 20, type: int. in Talend Studio

Error java.sql.SQLDataException: [Amazon][JDBC](10400) Invalid type for data - column: 20, type: int.

Sging — Sat, 16 Nov 2024 00:57:00 GMT

Hello,

I have a job that connects to Redshift Database and runs some queries and exports some files to s3 bucket (see image of failing component) .

Error message upon first run after building :

java.sql.SQLDataException: [Amazon][JDBC](10400) Invalid type for data - column: 20, type: int.

Inside the failing component I am just truncating and inserting data into 2 tables. Code in the failing components runs correctly I checked.

Talend Open Studio for Data Integration v7.3.1 .

OS: Windows

Thanks in advance

Anonymous — Wed, 16 Dec 2020 08:31:54 GMT

Please check if the number of columns on the schema map the select fields in the query, and check if each column has the right data type.

Regards

Shong

Sging — Wed, 16 Dec 2020 10:46:27 GMT

You are right error was fixed after applying this! Thanks !