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
Hi, I got this today too
Exception in component tMysqlInput_1
java.sql.SQLException: Cannot convert value '2014' from column 8 to TIMESTAMP.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1363)
at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:576)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6591)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6191)
at natcobidw.dlisting_1_0.dListing.tMysqlInput_1Process(dListing.java:2714)
at natcobidw.dlisting_1_0.dListing.tMysqlRow_1Process(dListing.java:472)
at natcobidw.dlisting_1_0.dListing.runJobInTOS(dListing.java:4472)
at natcobidw.dlisting_1_0.dListing.main(dListing.java:4337)
Caused by: java.lang.NumberFormatException: 548403012011912013-11-12 06:26:19
It is number format exception....
Can you show your input format and value in your column 8?
What timestamp value you set in metadata for column 8?
Vaibhav
