com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value:

来源：互联网发布：数据结构课程设计java 编辑：程序博客网时间：2024/05/21 14:54

做项目是遇到MySQL数据库连接jar版本太低抛出的异常：

异常信息如下

insert into wj_object(title,discribe,createtime,state,remark,anonymousFlag) values(?,?,?,?,?,?)com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'createtime' at row 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2868)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)at qn.honest.service.VolumeService.intsertObjectBean(VolumeService.java:37)at org.apache.jsp.view.wjNewAction_jsp._jspService(wjNewAction_jsp.java:100)at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at qn.honest.filter.CharacterEncoding.doFilter(CharacterEncoding.java:27)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:744)

解决办法：更换驱动包即可解决、将驱动由mysql-connector-java-5.0.4-bin.jar更新为mysql-connector-java-5.1.40-bin.jar 问题解决。

驱动包下载链接：mysql-connector-java-5.1.40-bin.jar

阅读全文

0 0