RODA

An error occurs when importing MySQL databases with columns of type DateTime, when the value is '0000-00-00 00:00:00'.

java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    at com.mysql.jdbc.ResultSetImpl.getTimestampFromString(ResultSetImpl.java:6291)
    at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5627)
    at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5448)
    at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5488)
    at pt.gov.dgarq.roda.common.convert.db.Import.jdbc.JDBCImportModule.convertRawToCell(JDBCImportModule.java:482)
    at pt.gov.dgarq.roda.common.convert.db.Import.jdbc.JDBCImportModule.convertRawToRow(JDBCImportModule.java:458)
    at pt.gov.dgarq.roda.common.convert.db.Import.jdbc.JDBCImportModule$1.next(JDBCImportModule.java:429)
    at pt.gov.dgarq.roda.common.convert.db.Export.DBMLExportModule.exportTableData(DBMLExportModule.java:374)
    at pt.gov.dgarq.roda.common.convert.db.Export.DBMLExportModule.exportData(DBMLExportModule.java:361)
    at pt.gov.dgarq.roda.common.convert.db.Export.DBMLExportModule.setDatabase(DBMLExportModule.java:147)
    at pt.gov.dgarq.roda.common.convert.db.Main.main(Main.java:75)
Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    at com.mysql.jdbc.ResultSetImpl.getTimestampFromString(ResultSetImpl.java:6049)
    ... 10 more