The connection property 'zeroDateTimeBehavior' only accepts values of the form

前景概述:

表user_info中created_time 设计为:

created_time timestamp not null default current_timestamp;

java插入数据时没有填写createdTime字段

就抛出

Cause: java.sql.SQLException: The connection property 'zeroDateTimeBehavior' only accepts values of the form: 'exception', 'round' or 'convertToNull'. The value 'convertToNull ' is not in this set.

原因在这里:注意url的value值的最后有一个空格

<environments default="development">  
        <environment id="development">  
            <transactionManager type="JDBC"/>    
            <dataSource type="POOLED">  
                <property name="driver" value="com.mysql.jdbc.Driver"/>  
                <property name="url" value="jdbc:mysql://localhost:3306/foretaste?zeroDateTimeBehavior=convertToNull "/>  
                <property name="username" value="root"/>  
                <property name="password" value="mysql123"/>  
            </dataSource>  
        </environment>  
    </environments>

去掉这个空格就可以了.