| stored procedure ??? [message #224952] |
Tue, 13 March 2007 22:58  |
Eclipse User |
|
|
|
i have called the stored procedure as below at beforeOpen method:
this.queryText="call
OCInventory7("params["recDate"]","params["recDate2"]", "params["cateFr"]","params["cateTo"]")";
is it any wrong with this query coz the errors as below are displayed:
Table (id = 363):
+ There are errors evaluating script "this.queryText="call
OCInventory7("params["recDate"]","params["recDate2"]", "params["cateFr"]","params["cateTo"]")";".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "this.queryText="call
OCInventory7("params["recDate"]","params["recDate2"]", "params["cateFr"]","params["cateTo"]")";".
at
org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:76)
at
org.eclipse.birt.report.engine.script.internal.DataSetScript Executor.handleJS(DataSetScriptExecutor.java:159)
at
org.eclipse.birt.report.engine.script.internal.DataSetScript Executor.handleBeforeOpen(DataSetScriptExecutor.java:64)
at
org.eclipse.birt.data.engine.impl.DataSetRuntime.beforeOpen( DataSetRuntime.java:495)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:204)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
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.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:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.eclipse.birt.data.engine.core.DataException: A BIRT exception
occurred: Error evaluating Javascript expression. Script engine error:
missing ; before statement (DataSet[Data Set].__bm_beforeOpen#2) Script
source: DataSet[Data Set].__bm_beforeOpen, line: 1, text:function
__bm_beforeOpen() {this.queryText="call
OCInventory7("params["recDate"]","params["recDate2"]", "params["cateFr"]","params["cateTo"]")";}
See next exception for more information.Error evaluating Javascript
expression. Script engine error: missing ; before statement (DataSet[Data
Set].__bm_beforeOpen#2) Script source: DataSet[Data Set].__bm_beforeOpen,
line: 1, text:function __bm_beforeOpen() {this.queryText="call
OCInventory7("params["recDate"]","params["recDate2"]", "params["cateFr"]","params["cateTo"]")";}
at
org.eclipse.birt.data.engine.core.DataException.wrap(DataExc eption.java:118)
at
org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJ SAsExpr(ScriptEvalUtil.java:552)
at
org.eclipse.birt.data.engine.script.JSMethodRunner.runScript (JSMethodRunner.java:74)
at
org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
... 49 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error
evaluating Javascript expression. Script engine error: missing ; before
statement (DataSet[Data Set].__bm_beforeOpen#2) Script source:
DataSet[Data Set].__bm_beforeOpen, line: 1, text:function
__bm_beforeOpen() {this.queryText="call
OCInventory7("params["recDate"]","params["recDate2"]", "params["cateFr"]","params["cateTo"]")";}
at
org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoExc eption(JavascriptEvalUtil.java:281)
at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:105)
at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScri pt(JavascriptEvalUtil.java:137)
at
org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJ SAsExpr(ScriptEvalUtil.java:548)
... 51 moreCaused by: org.mozilla.javascript.EvaluatorException: missing ;
before statement (DataSet[Data Set].__bm_beforeOpen#2) at
org.mozilla.javascript.DefaultErrorReporter.runtimeError(Def aultErrorReporter.java:95)
at
org.mozilla.javascript.DefaultErrorReporter.error(DefaultErr orReporter.java:82)
at org.mozilla.javascript.Parser.addError(Parser.java:120) at
org.mozilla.javascript.Parser.reportError(Parser.java:126) at
org.mozilla.javascript.Parser.statementHelper(Parser.java:11 68) at
org.mozilla.javascript.Parser.statement(Parser.java:616) at
org.mozilla.javascript.Parser.parseFunctionBody(Parser.java: 409) at
org.mozilla.javascript.Parser.function(Parser.java:515) at
org.mozilla.javascript.Parser.parse(Parser.java:342) at
org.mozilla.javascript.Parser.parse(Parser.java:287) at
org.mozilla.javascript.Context.compileImpl(Context.java:2349 ) at
org.mozilla.javascript.Context.compileString(Context.java:13 72) at
org.mozilla.javascript.Context.compileString(Context.java:13 61) at
org.eclipse.birt.core.script.JavascriptEvalUtil.getCompiledS cript(JavascriptEvalUtil.java:155)
at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:94)
... 53 more
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04024 seconds
Home