系统时间参数格式错误

bex5学习ID

2017-02-07 10:08:44 执行sql: insert into SA_Log  (sCreatorPersonID, sCreatorOgnName, sDeviceType, sCreatorFName, version, sProcess, sParameters, sCreatorDeptID, sDescription, sActivity, sCreatorPosID, sCreateTime, sProcessName, sCreatorOgnID, sCreatorFID, sOperatingSystem, sCreatorPosName, sActivityName, sCreatorDeptName, sStatusName, sCreatorPersonName, SID, sActionName, sTypeName, sResult, sIP, sAction, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue), binds: [PSN01, 起步软件, Computer, /起步软件/system, 0, /portal/process/message/messageProcess, 参数名称: limit
参数值:
参数名称: aggregate
参数值:
参数名称: concept
参数值: {"value":"Portal_Message"}
参数名称: dataModel
参数值: {"value":"/portal/data"}
参数名称: range
参数值: {"value":[]}
参数名称: orderBy
参数值:
参数名称: condition
参数值:
参数名称: select
参数值: {"value":"Portal_Message.*"}
参数名称: columns
参数值:
参数名称: from
参数值: {"value":"Portal_Message Portal_Message"}
参数名称: distinct
参数值: {"value":false}
参数名称: idColumn
参数值: {"value":"Portal_Message"}
参数名称: variables
参数值:
参数名称: fnModel
参数值:
参数名称: aggregateColumns
参数值:
参数名称: offset
参数值:
参数名称: filter
参数值:
, , null, mainActivity, , 2017-02-07 10:08:44.415, message, ORG01, [url=]/ORG01.ogn/PSN01@ORG01.psm[/url], WINDOWS_7, , mainActivity, , 失败, system, 390904D2E71345F397EF49018E279B4A, queryWaitMessageAction, 操作日志, , 192.168.0.131, queryWaitMessageAction]失败
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'sCreateTime' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.justep.system.log.LogUtils.execSqlUpdate(Unknown Source)
at com.justep.system.log.LogUtils.log(Unknown Source)
at com.justep.system.log.LogUtils.log(Unknown Source)
at com.justep.system.interceptor.LogBefore.actionLog(Unknown Source)
at com.justep.system.interceptor.LogBefore.doActionLog(Unknown Source)
at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)

半导体

这个 是说你的sql语句有问题  你是自定义的action吗？

bex5学习ID

没有啊，  这个意思是我的系统时间与定义时间格式不匹配。  SA_Log   这张表 bex5  自带的

大雁子

看一下sCreateTime的字段格式和值是否相符

bex5学习ID

大雁子 发表于 2017-2-7 10:54
看一下sCreateTime的字段格式和值是否相符

我的系统 时间格式在哪里设置？

jishuang

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'sCreateTime' at row 1

确认用的mysql版本跟用的数据库驱动包是否匹配

bex5学习ID

是匹配的， 是个问题是部署在服务器后才出现的。

jishuang

mysql用的什么版本？
mysql日期类型的出现这个错误一般都是驱动不匹配的原因

bex5学习ID

jishuang 发表于 2017-2-7 16:32
mysql用的什么版本？
mysql日期类型的出现这个错误一般都是驱动不匹配的原因 ...

可以了， 谢谢

gost_1223

jishuang 发表于 2017-2-7 16:32
mysql用的什么版本？
mysql日期类型的出现这个错误一般都是驱动不匹配的原因 ...

替换tomcat/lib目录下的mysql jar包后 还是报这个错误。