|
我使用SQL数据,出现查询错误,我将数据复制到SQL查询分析器中能查询到数据。
从错误信息上看,要求时间的格式必须为yyyy-mm-dd hh:mm:ss.fffffffff
我查了数据库中的数据行中,日期的格式为:05 24 2014 12:46AM
我的日期是使用默认值插入的:currentDateTime()
该如何处理:
出错信息如下:
JUSTEP150210, 执行KSQL出错, KSQL: SELECT RB_TaskOpt.* FROM RB_TaskOpt RB_TaskOpt WHERE ((RB_TaskOpt.fTaskID='D7B06AD8FD83496DB1414BCC3E4E0DFC')) LIMIT 0, 20,刷新数据失败!
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT RB_TaskOpt.* FROM RB_TaskOpt RB_TaskOpt WHERE ((RB_TaskOpt.fTaskID='D7B06AD8FD83496DB1414BCC3E4E0DFC')) LIMIT 0, 20
Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT RB_TaskOpt.* FROM RB_TaskOpt RB_TaskOpt WHERE ((RB_TaskOpt.fTaskID='D7B06AD8FD83496DB1414BCC3E4E0DFC')) LIMIT 0, 20
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 26 more
Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
at java.sql.Timestamp.valueOf(Timestamp.java:185)
at net.sourceforge.jtds.jdbc.Support.convert(Support.java:387)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getTimestamp(JtdsResultSet.java:1160)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:250)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:250)
at com.justep.system.data.impl.TableUtilsImplement.fillRow(Unknown Source)
... 31 more
|
|