Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-report-engine-dev] setSpecification is not supported error...


I have a sample report that runs fine from eclipse birt plugin. When I move the report to my webapp, and call ReportEngine from my servlet, I do not see the jdbc query executed.

I have one report parameter ( RP_demo ) in the query which I pass using the following code:

IRunAndRenderTask task = ...;
task.setParameterValue("RP_Demo", "N");


In Birt log files, I find the following messages/error:



FINER: ENTRY DSP_demo true false
Nov 19, 2009 2:48:22 PM org.eclipse.birt.data.engine.odaconsumer.ParameterHint ParameterHint( String, boolean, boolean )
FINER: RETURN org.eclipse.birt.data.engine.odaconsumer.ParameterHint@10aa2da
Nov 19, 2009 2:48:22 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareStatement(String,String,QuerySpecification)
FINER: ENTRY select companyName, expiryDate
from client
where demo = ? org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet
Nov 19, 2009 2:48:22 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
FINER: ENTRY select companyName, expiryDate
from client
where demo = ? org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet org.eclipse.datatools.connectivity.oda.spec.QuerySpecification@752ccf Nov 19, 2009 2:48:22 PM org.eclipse.birt.report.data.oda.jdbc.Connection createStatement FINE: Connection.createStatement(org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet) Nov 19, 2009 2:48:22 PM org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec FINER: ENTRY org.eclipse.datatools.connectivity.oda.spec.QuerySpecification@752ccf Nov 19, 2009 2:48:22 PM org.eclipse.birt.report.data.oda.jdbc.Statement setSpecification
FINE: No named Parameter supported.
java.lang.UnsupportedOperationException: setSpecification is not supported.
at org.eclipse.birt.report.data.oda.jdbc.Statement.setSpecification(Statement.java:943) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.setSpecification(OdaQuery.java:1488) at org.eclipse.birt.data.engine.odaconsumer.Connection.setOdaQuerySpec(Connection.java:315) at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:279) at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:181) at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:269) at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:270) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:350) at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:337) at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:448) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:144) at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:511) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:139) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:254) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1818) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)


Thanks

gd



Back to the top