mysqlデータベースの日付タイプはdatetimeで、mybatisでマッピングに失敗し、javaを報告します.sql.SQLException: Cannot convert value '0000-00-00 00:00:

環境:mysqlデータベース+mybatis
mysqlのフィールドは日付で、そのタイプはdatetimeです.そしてフレームワークはmybatisで、クエリー時にマッピング操作を行うのは新聞です.

java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP. 
      ：

 Mysql      DATETIME       ，  JDBC          ，     ResultSet.getTimestamp()，       java.sql.Timestamp     。         ResultSet.getDate()，     ResultSet.getTime()，       time  ，     date  。

     ResultSet.getTimestamp()         ，  ，      TIMESTAMP        '0000-00-00 00:00:00' ，         ，     ：Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP，    JDBC   '0000-00-00 00:00:00'        java.sql.Timestamp， Java ，     java.util.Date，     '0000-00-00'      ，         '0001-01-01 00:00:00'。

           ？        ：

Datetimes with all-zero components (0000-00-00 ...) — These values can not be represented reliably in Java. Connector/J 3.0.x always converted them to NULL when being read from a ResultSet.

Connector/J 3.1 throws an exception by default when these values are encountered as this is the most correct behavior according to the JDBC and SQL standards. This behavior can be modified using the zeroDateTimeBehavior configuration property. The allowable values are:

exception (the default), which throws an SQLException with an SQLState of S1009.
convertToNull, which returns NULL instead of the date.
round, which rounds the date to the nearest closest value which is 0001-01-01.
Starting with Connector/J 3.1.7, ResultSet.getString() can be decoupled from this behavior via noDatetimeStringSync=true (the default value is false) so that you can retrieve the unaltered all-zero value as a String. It should be noted that this also precludes using any time zone conversions, therefore the driver will not allow you to enable noDatetimeStringSync and useTimezone at the same time.

  ， JDBC URL   zeroDateTimeBehavior  ，     ：
String url = "jdbc:mysql://10.149.51.80:3306/test?relaxAutoCommit=true&zeroDateTimeBehavior=convertToNull";