Data truncation: Incorrect datetime value: '' for column 'Acked_Time_Stamp' at row 1

错误原因

数据库由5.5.25升级为5.6.22导致的错误，mysql-connector-java没有升级对应的版本

解决方案

查看mysql官网说明之后，升级mysql-connector-java-5.0.3.jar为5.1.0之后的版本

java.sql.BatchUpdateException: Data truncation: Incorrect datetime value: '' for column 'Acked_Time_Stamp' at row 1
    at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:657)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    at $java.sql.PreparedStatement$$EnhancerByProxool$$32be4401.executeBatch(<generated>)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
    at org.abcom.sinms.apps.instantDumper.ActiveAlarmHandler.main(ActiveAlarmHandler.java:555)
 WARN [main] (JDBCExceptionReporter.java:77) - SQL Error: 0, SQLState: 22001
ERROR [main] (JDBCExceptionReporter.java:78) - Data truncation: Incorrect datetime value: '' for column 'Acked_Time_Stamp' at row 1