Apr 8, 2005 11:35:51 AM org.eclipse.birt.report.engine.data.dte.DteDataEngine execute SEVERE: Cannot execute the statement. org.eclipse.birt.data.engine.core.DataException: Cannot execute the statement. at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:402) at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:430) at org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$ExtendedDSQueryExecutor.executeOdiQuery(PreparedExtendedDSQuery.java:232) at org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.execute(PreparedQuery.java:454) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:85) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.execute(DteDataEngine.java:244) at org.eclipse.birt.report.engine.executor.ReportItemExecutor.openResultSet(ReportItemExecutor.java:136) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:125) at org.eclipse.birt.report.engine.executor.ReportExecutorVisitor.visitTableItem(ReportExecutorVisitor.java:358) at org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:72) at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:138) at org.eclipse.birt.report.engine.impl.ReportHandle.execute(ReportHandle.java:254) at org.eclipse.birt.report.engine.impl.EmbeddedReportHandle.viewReport(EmbeddedReportHandle.java:72) at org.eclipse.birt.report.viewer.aggregation.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.viewer.aggregation.BaseFragment.service(Unknown Source) at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doPost(Unknown Source) at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:365) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: A JDBC Exception occured: No value specified for parameter 1 at org.eclipse.birt.report.data.oda.jdbc.Statement.execute(Statement.java:287) at org.eclipse.birt.data.engine.odaconsumer.manager.OdaStatement.doExecute(OdaStatement.java:561) at org.eclipse.birt.data.engine.odaconsumer.manager.OdaStatement.execute(OdaStatement.java:523) at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:398) ... 34 more Caused by: java.sql.SQLException: No value specified for parameter 1 at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2296) at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2249) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1319) at org.eclipse.birt.report.data.oda.jdbc.Statement.execute(Statement.java:283) ... 37 more