'PDI Timestamp : Unable to get timestamp from resultset at index 5

I have a transformation in PDI which basically read data from amazon S3 bucket and push data into mysql database.But today i am facing below error in PDI in time of transformation execution.

org.pentaho.di.core.exception.KettleDatabaseException: 
Couldn't get row from result set

Timestamp : Unable to get timestamp from resultset at index 5
Value '37467412015-04-18 13:58:472015-04-18 13:58:4700000-00-00 00:00:001:138' can not be represented as java.sql.Timestamp


at org.pentaho.di.core.database.Database.getRow(Database.java:2397)
at org.pentaho.di.core.database.Database.getRow(Database.java:2368)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

I have already used zeroDateTimeBehavior = convertToNull option in PDI

mysqlpentaho-spoon


Solution 1:[1]

The problem is due that Java Timestamp doesn't accept the '0000-00-00' date.

You can add this parameter to the jdbc connection string in the JNDI jdbc.properties:

jdbc:mysql://localhost:3306/......&zeroDateTimeBehavior=CONVERT_TO_NULL

The valid values are "EXCEPTION", "ROUND" and "CONVERT_TO_NULL"

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 abo

Related Questions