java.sql.SQLException: Bad format for Timestamp error in talend

ksharma1628668043 — Fri, 15 Nov 2024 23:51:57 GMT

I am new user of Talend.

For my first job, I would like to copy data from a MySql table to another sql Table.

Here is my simple job :

tMysqlInput

tMap

tMSSqlOutput

When I execute my job, I got this error :

Exception in component tDBInput_1 (STG_TGT_SUBSIDY_F)

java.sql.SQLException: Bad format for Timestamp '464' in column 55.

at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1378)

at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127)

at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6587)

at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6187)

at dailyetljobs.stg_tgt_subsidy_f_0_1.STG_TGT_SUBSIDY_F.tDBInput_1Process(STG_TGT_SUBSIDY_F.java:20851)

at dailyetljobs.stg_tgt_subsidy_f_0_1.STG_TGT_SUBSIDY_F.runJobInTOS(STG_TGT_SUBSIDY_F.java:30038)

at dailyetljobs.stg_tgt_subsidy_f_0_1.STG_TGT_SUBSIDY_F.main(STG_TGT_SUBSIDY_F.java:29628)

I don’t understand because, in the schema, column 55 is YEAR ID (values as 19) .

At present datatype i am using is Big decimal.

Kindly drop your inputs.

Thanks for the help.

Karishma

Re: java.sql.SQLException: Bad format for Timestamp error in talend

Anonymous — Wed, 11 Aug 2021 09:34:34 GMT

Can you show us a screenshot of your schema (for the tDBInput component) and also give us the MySQL schema of the table you are reading from? It sounds like there is a misconfiguration in your data types.

topic java.sql.SQLException: Bad format for Timestamp error in talend in Talend Studio

java.sql.SQLException: Bad format for Timestamp error in talend

Re: java.sql.SQLException: Bad format for Timestamp error in talend