error message : Cannot convert value '0000-00-00'

[Anonymous]

Hey everybody! can you help me?.
I have a problem with tmysqlinput, if I want to load data from input table to output table, I got message error. The message was like this
?Cannot convert value '0000-00-00' from column 8 to TIMESTAMP?
Thanks a lot for your information

[Anonymous]

Recently fixed, see 1195

[_AnonymousUser]

hai ...
I still doesn't understand. What must i do if i found this case...
thx
i'm already user talend version 2.0.3 and use java language. i'm already see bugtacker. can u help me to explain what must i do?

Manda

[Anonymous]

Hello,
As you can see in the bug properties, it has been Fixed in Version 2.1.0M2.
Either you update to last testing version of 2.1 (2.1RC1 is currently available), either you wait for 2.1 final release.
Regards,

[Anonymous]

And where's RC1 for linux ?!?!?

[Anonymous]

This RC1 is for all OS.

[Anonymous]

Then you should had the linux icon next to it in the Download Page cause currently, it looks like it's for Windows Only.
Thanks,

[Anonymous]

Then you should had the linux icon next to it in the Download Page cause currently, it looks like it's for Windows Only.

job's done (by ocarbone)

[Anonymous]

And rename it some like TOS-ALL-V2.1.0RC1 instead of TOS-Win32-V2.1.0RC1.
hehe

[Anonymous]

hi ,
i got the Same execption in TOS-All-r26090-V3.1.3.

Exception in component tMysqlInput_1
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6678)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5845)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5645)
at zwh.dsa_0_1.dsa.tMysqlInput_1Process(dsa.java:2715)
at zwh.dsa_0_1.dsa.runJobInTOS(dsa.java:3623)
at zwh.dsa_0_1.dsa.main(dsa.java:3412)

please provide solution for this.