mysql： timestamp导致的 异常

SQLException:Cannot convert value '0000-00-00 00:00:00'from column 5 to TIMESTAMP.
SQLState: S1009
VendorError:0
java.sql.SQLException:Cannot convert value '0000-00-00 00:00:00'from column 5 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:6343)
    at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5670)
    at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5491)
    at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5531)

 

解决办法：You can just add zeroDateTimeBehavior=convertToNull to your connectionjdbc:mysql://localhost/test?zeroDateTimeBehavior=convertToNull.

For me, it works perfectly. pls refer to this link for more detail.