[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