Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.