Int to Date conversion error without any changes happening in data model in Talend

Question

I had the ETL working until two days ago when I started receiving:

Exception in component tDBInput_1 (test4) java.sql.SQLDataException: Unsupported conversion from TIMESTAMP to java.lang.Integer

Clueless what happened here.

Answer 1

It look like your schema in your tDb_Input_1 is not the same between schema inside component and your database table type. For exemple product_line_id is a varchar in your table and it's a Integer in your schema.

Try to redefine your schema in yout tDBInput Component.

You can do it like that :

• Define your DB connection inside metadata (in Db Connection)
• Retrieve schema from your database in order to import the schema automatically in Talend. (See screeshot)
• Use the schema retrieved in your component and propagate to all the job.