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.

posted @ 2012-10-17 13:08  ccmaotang  阅读(724)  评论(0)  编辑  收藏  举报