|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
最近利用报表生成一个按日期统计的项目,由于需要的数据在两个数据库表中,需要联合查询,写的sql语句如下,运行可以得到需要的结果,但是在studio中写自定义action则会报日期不匹配错误,请教这是什么原因?
SQL:
select t1.fDate as fDate,t1.count1,t2.count2
from
(select SR_Ship_Repair_DBX.fDate as fDate, (count(SR_Ship_Repair_DBX.fDate)) as count1 from SR_Ship_Repair_DBX SR_Ship_Repair_DBX where SR_Ship_Repair_DBX.fShipSure is null OR SR_Ship_Repair_DBX.fFactorySure is null group by SR_Ship_Repair_DBX.fDate order by SR_Ship_Repair_DBX.fDate asc) t1
,
(select SR_Ship_Repair_BX.fWriterDate as fWriterDate, (count(SR_Ship_Repair_BX.fWriterDate)) as count2 from SR_Ship_Repair_BX SR_Ship_Repair_BX where SR_Ship_Repair_BX.fShipSure is null OR SR_Ship_Repair_BX.fFactorySure is null group by SR_Ship_Repair_BX.fWriterDate order by SR_Ship_Repair_BX.fWriterDate asc) t2
where t1.fDate = t2.fWriterDate
order by t1.fDate asc
报错:
Date Format yyyy-MM-dd does not match with the date data
java.text.ParseException: Unparseable date: ""
at java.text.DateFormat.parse(DateFormat.java:337)
at com.justep.chart.data.ChartDatasetHelper.createTimeSeriesDataSet(Unknown Source)
at com.justep.chart.data.ChartDatasetHelper.createDataSet(Unknown Source)
at com.justep.chart.BuildChart.initChartObj(Unknown Source)
at com.justep.chart.BuildChart.initChartObj(Unknown Source)
at com.justep.chart.BuildChart.build(Unknown Source)
at com.justep.chart.BuildChart.createChart(Unknown Source)
at com.justep.chart.JustepChartHelper.executeChart(Unknown Source)
at com.justep.report.core.XReportChartHelper.executeChart(Unknown Source)
at com.justep.report.core.XReportHelper.a(Unknown Source)
at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
at com.justep.report.controller.ReportController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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:662)
|
|