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

[ksharma1628668043]

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

1)

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

[Anonymous]

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.