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.