Minggu, 17 November 2019

Value '0000-00-00' can not be represented as java.sql.Timestamp IN PENTAHO (PDI)


In Kettle (Pentaho Data Integration), when you use a "Table Input" component, you have to create a database connection.
In the database connection form, fill the fields of your mysql database, and test it.
If successfull, go to Options (left tab)
In the right tab, below defaultFetchSize and useCursorFetch, add zeroDateTimeBehavior and it's value convertToNull


Hope this helps !

Tidak ada komentar: