| Error in processing Input Parameters [message #21969] |
Mon, 21 March 2005 23:06  |
Eclipse User |
|
|
|
Originally posted by: dizfire.comcast.net
Just started evaluating BIRT this week and am fairly impressed with the
intuitive interface and css approach to field and label formatting..great
job so far.
Am now attempting to evaluate it as a component of an app server suite, so I
installed it on my Tomcat server and had no problems instantiating the
reports using the viewerservlet (I am, however, looking forward to the
relative file reference for identifying the rptdesign files..)
I have run into difficulty implementing Input Parameters; here is what I've
done and what errors are being generated.:
1.. Placed a single SQL ? symbol in my query ("WHERE `record`.`recordid` =
?"),
2.. Created a single entry on the Input Parameter dialog box (called
"recordid"), and
3.. Created a parameter via the New Parameter dialog box so that I can
pass the parameter value via url or a dialog on the viewer.
When I complete step 2, Eclipse will sometimes responds with an error
"java.lang.IllegalArgumentException occurred - Parameter position cannot be
less than 1.", but I am ultimately able to close the dialog and move on;
however the report won't generate, neither via an entry of the parameter
value in the viewer dialog or when I pass it on the url. I have the stack
trace from Tomcat below and it appears the setPosition method of the
ParameterHint object is trying to apply "0" as the index to this parameter
in the SQL statement. Let me know if I missed something procedurally or if
this needs to be Bugzilla'd.
java.lang.IllegalArgumentException: Parameter position cannot be less than
1.
at
org.eclipse.birt.data.engine.odaconsumer.ParameterHint.setPo sition(Unknown
Source)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.addPar ameterHints(Unkn
own Source)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(Unknown
Source)
at
org.eclipse.birt.data.engine.impl.PreparedExtendedDSQuery$Ex tendedDSQueryExe
cutor.prepareOdiQuery(Unknown Source)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.exe cute(Unknown
Source)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doExecute(Un known Source)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(Unknown
Source)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.
java:250)
at
org.eclipse.birt.report.engine.executor.ReportItemExecutor.o penResultSet(Rep
ortItemExecutor.java:135)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemE
xecutor.java:130)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem
(ReportExecutorVisitor.java:359)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.jav
a:72)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecuto
r.java:145)
at
org.eclipse.birt.report.engine.impl.ReportHandle.execute(Rep ortHandle.java:2
48)
at
org.eclipse.birt.report.engine.impl.EmbeddedReportHandle.vie wReport(Embedded
ReportHandle.java:71)
at
org.eclipse.birt.report.viewer.aggregation.EngineFragment.do Service(Unknown
Source)
at
org.eclipse.birt.report.viewer.aggregation.RootFragment.serv ice(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.internalDoFi lter(Application
FilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterCh
ain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.ja
va:214)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.ja
va:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105
)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogVa lve.java:526)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(Single SignOn.java:365)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java
:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:825)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConne
ction(Http11Protocol.java:731)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.jav
a:526)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWo
rkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.jav
a:684)
at java.lang.Thread.run(Unknown Source)
|
|
|
| Re: Error in processing Input Parameters [message #22102 is a reply to message #21969] |
Tue, 22 March 2005 13:27  |
| Eclipse User |
|
|
|
Scott,
Thanks for the great feedback.
As you found, there are known problems with SQL parameter handling. The
development team is looking into the issue. This is a high priority with the
team. Sorry for the inconvenience.
- Paul
Paul Rogers
BIRT PMC
"Scott Dismeier" <dizfire@comcast.net> wrote in message
news:d1oac3$cn4$1@news.eclipse.org...
....
> I have run into difficulty implementing Input Parameters; here is what
> I've
> done and what errors are being generated.:
>
>
>
> 1.. Placed a single SQL ? symbol in my query ("WHERE `record`.`recordid`
> =
> ?"),
> 2.. Created a single entry on the Input Parameter dialog box (called
> "recordid"), and
> 3.. Created a parameter via the New Parameter dialog box so that I can
> pass the parameter value via url or a dialog on the viewer.
....
|
|
|
Powered by
FUDForum. Page generated in 0.03130 seconds
Home