SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

Error querying database. Cause: java.sql.SQLException: Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp

解决方案

        <property name="url">
            <value>jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull</value>
        </property>

加上 zeroDateTimeBehavior=convertToNull