Home » Archived » BIRT » Scripted Data Source
Scripted Data Source [message #202145] |
Tue, 21 November 2006 12:01  |
Eclipse User |
|
|
|
Originally posted by: brad.lwsi.com
Hello,
I'm trying to get the scripted datasource example to work:
http://www.eclipse.org/birt/phoenix/examples/scripting/scrip teddatasource/
however, I am completely lost with how to actually take the java file and
compile it into a class file within eclipse.
Can someone provide a walk-through of how to set up a BIRT project (like
the scripted datasource example) in Eclipse so that I can recreate the
example above?
thanks!
Brad
|
|
| | | |
Re: Scripted Data Source [message #202169 is a reply to message #202167] |
Tue, 21 November 2006 13:55   |
Eclipse User |
|
|
|
Originally posted by: bgustavesen.lwsi.com
Yes, I created a brand new java project in eclipse. I have two folders in
there, "bin" which has the saved class file, and "src" which has the .java
file. Do I need other files/folders in the project directory? if so, what
are they?
If you could send the class file that would be great, but I definitely
need to be able to figure out how to build the class files.
I put the .class file that I created into the ScriptLib folder and got
this error when I ran the report in my browser:
The following items have errors:
Table (id = 110):
+ There are errors evaluating script "favoritesClass = new SimpleClass();
favorites = favoritesClass.readData();
totalrows = favorites.size();
currentrow = 0;".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "favoritesClass = new SimpleClass();favorites =
favoritesClass.readData();totalrows = favorites.size();currentrow = 0;".
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.ScriptDataSet ScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:6 6)
at
org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open( ScriptDataSetRuntime.java:68)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.j ava:233)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java :209)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
at
org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
at
org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
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:689) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
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.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:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)Caused by:
org.eclipse.birt.data.engine.core.DataException: A BIRT exception
occurred: Error evaluating Javascript expression. Script engine error:
ReferenceError: "SimpleClass" is not defined. (DataSet[Fvr].__bm_OPEN#2)
Script source: DataSet[Fvr].__bm_OPEN, line: 1, text:__bm_OPEN(). See next
exception for more information.Error evaluating Javascript expression.
Script engine error: ReferenceError: "SimpleClass" is not defined.
(DataSet[Fvr].__bm_OPEN#2) Script source: DataSet[Fvr].__bm_OPEN, line: 1,
text:__bm_OPEN() 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:79)
at
org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
... 45 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error
evaluating Javascript expression. Script engine error: ReferenceError:
"SimpleClass" is not defined. (DataSet[Fvr].__bm_OPEN#2) Script source:
DataSet[Fvr].__bm_OPEN, line: 1, text:__bm_OPEN() 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)
... 47 moreCaused by: org.mozilla.javascript.EcmaError: ReferenceError:
"SimpleClass" is not defined. (DataSet[Fvr].__bm_OPEN#2) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at
org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRun time.java:3303)
at
org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRu ntime.java:1632)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java :1571) at
org.mozilla.javascript.gen.c63._c1(DataSet[Fvr].__bm_OPEN:2) at
org.mozilla.javascript.gen.c63.call(DataSet[Fvr].__bm_OPEN) at
org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRun time.java:105)
at
org.mozilla.javascript.gen.c20._c0(DataSet[setEnvironmentVar s].__bm_OPEN:1)
at
org.mozilla.javascript.gen.c20.call(DataSet[setEnvironmentVa rs].__bm_OPEN)
at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at
org.mozilla.javascript.gen.c20.call(DataSet[setEnvironmentVa rs].__bm_OPEN)
at
org.mozilla.javascript.gen.c20.exec(DataSet[setEnvironmentVa rs].__bm_OPEN)
at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:98)
... 49 more
+ There are errors evaluating script "if( currentrow >= totalrows ) {
return( false );
}
var favrow = favorites.get(currentrow);
var Customer = favrow[0];
var Favorite = favrow[1];
var Color = favrow[2];
row["Customer"] = Customer;
row["Favorite"] = Favorite;
row["Color"] = Color;
currentrow = currentrow + 1;
return ( true );".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "if( currentrow >= totalrows ) { return( false
);}var favrow = favorites.get(currentrow);var Customer = favrow[0];var
Favorite = favrow[1];var Color = favrow[2];row["Customer"] =
Customer;row["Favorite"] = Favorite;row["Color"] = Color;currentrow =
currentrow + 1;return ( true );". 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.ScriptDataSet ScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java: 100)
at
org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch (ScriptDataSetRuntime.java:84)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery. java:246)
at
org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch (OdiAdapter.java:148)
at
org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:91)
at
org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:243)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:206)
at
org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:65)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:109)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:65)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doSinglePass(PassManager.java:120)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:80)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:62)
at
org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:207)
at
org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:118)
at
org.eclipse.birt.data.engine.executor.CandidateQuery.execute (CandidateQuery.java:88)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java :212)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
at
org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
at
org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
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:689) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
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.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:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)Caused by:
org.eclipse.birt.data.engine.core.DataException: A BIRT exception
occurred: Error evaluating Javascript expression. Script engine error:
ReferenceError: "currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2)
Script source: DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH(). See
next exception for more information.Error evaluating Javascript
expression. Script engine error: ReferenceError: "currentrow" is not
defined. (DataSet[Fvr].__bm_FETCH#2) Script source:
DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH() 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:79)
at
org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
... 60 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error
evaluating Javascript expression. Script engine error: ReferenceError:
"currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2) Script source:
DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH() 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)
... 62 moreCaused by: org.mozilla.javascript.EcmaError: ReferenceError:
"currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at
org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRun time.java:3303)
at
org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRu ntime.java:1632)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java :1571) at
org.mozilla.javascript.gen.c64._c1(DataSet[Fvr].__bm_FETCH:2 ) at
org.mozilla.javascript.gen.c64.call(DataSet[Fvr].__bm_FETCH) at
org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRun time.java:105)
at
org.mozilla.javascript.gen.c22._c0(DataSet[setEnvironmentVar s].__bm_FETCH:1)
at
org.mozilla.javascript.gen.c22.call(DataSet[setEnvironmentVa rs].__bm_FETCH)
at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at
org.mozilla.javascript.gen.c22.call(DataSet[setEnvironmentVa rs].__bm_FETCH)
at
org.mozilla.javascript.gen.c22.exec(DataSet[setEnvironmentVa rs].__bm_FETCH)
at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:98)
... 64 more
+ Unhandled exception when executing script
|
|
| | | |
Re: Scripted Data Source [message #202295 is a reply to message #202243] |
Tue, 21 November 2006 21:59   |
Eclipse User |
|
|
|
Originally posted by: johnw.innoventsolutions.com
Brad,
Steps to create Java project:
-switch perspective over to Java(default)
-File/New project
-Select Java Project
-Name your project, specify your JRE, click next
-Include necessary libraries and click finish
-Go to file/new/class
-Make sure your class is under your project, name your class, include
main functions (not necessary, but useful for debugging) (Note: I did
not include a package. I left the package name blank).
-Write your Java code.
For example, I wrote this simple class to demonstrate, under a Project
called TestProject, no package name, and a class called Test:
public class Test {
/**
* @param args
*/
public String getName()
{
return "Test";
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Test t = new Test();
System.out.println(t.getName());
}
}
-Save your class, and do a test run by Right-Mouse clicking on your
TestProject in the navigator, going to Run-as, and choosing the correct
run type. (I had to go into the run... under Run-as, double-click on
Java application, and following the wizard to get the correct starter
class and other options).
-Once run, your program should be compiled. If you do not have "build
automatically" checked under your project menu, you can choose
Project/Build-all.
-Open the BIRT Perspective
-Create a new report project, new report.
-I copied the file "C:\eclipse\workspace\TEstProject\test.class" to
the same folder as my new Report Project.
-Exit and restart Eclipse
-Open the Data Sources, select Scripted Data Source, and select new Data
Set, choose your new Data Source as the Data Source.
-Create a new column (I created a new column called name of type string).
-Under the Open method for the scripted datasource, I created the following:
x = 0;
obj = Packages.Test();
-Under the fetch method, I created the following code:
if (x == 0)
{
row["name"] = obj.getName();
x++;
return true;
}
else
return false;
-Then I go back into the Layout, drag the data set over to the designer
window, and run. I get the results "Test" entered as the value of name
under my data table.
Hope this helps Brad.
John
Brad wrote:
> Thanks John. I found your article earlier today when searching.
> I still think that the main issue is how to set up the java project,
> build the class file and then run it.
>
|
|
| |
Re: Scripted Data Source [message #202426 is a reply to message #202418] |
Wed, 22 November 2006 10:08   |
Eclipse User |
|
|
|
Originally posted by: bgustavesen.lwsi.com
I was able to get the sample working so that when I preview the report
design in Eclipse, it pulls the data from the .class file.
However, when I copy over the files into the WebViewerExample, I get the
same error as yesterday with the . So I have as the directory stucture...
*mywebroot*/WebViewerExample/example.rptdesign
*mywebroot*/WebViewerExample/WEB-INF
*mywebroot*/WebViewerExample/webcontent
*mywebroot*/WebViewerExample/scriptlib
*mywebroot*/WebViewerExample/report
Should I be able to just copy over the files? If so, where do I paste them
in?
thanks for everyones help.
error from yesterday / today in the webviewerxample:
The following items have errors:
Table (id = 110):
+ There are errors evaluating script "favoritesClass = new
Packages.SimpleClass();
favorites = favoritesClass.readData();
totalrows = favorites.size();
currentrow = 0;".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "favoritesClass = new
Packages.SimpleClass();favorites = favoritesClass.readData();totalrows =
favorites.size();currentrow = 0;". 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.ScriptDataSet ScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:6 6)
at
org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open( ScriptDataSetRuntime.java:68)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.j ava:233)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java :209)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
at
org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
at
org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
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:689) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
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.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:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)Caused by:
org.eclipse.birt.data.engine.core.DataException: A BIRT exception
occurred: Error evaluating Javascript expression. Script engine error:
TypeError: [JavaPackage SimpleClass] is not a function.
(DataSet[Fvr].__bm_OPEN#2) Script source: DataSet[Fvr].__bm_OPEN, line: 1,
text:__bm_OPEN(). See next exception for more information.Error evaluating
Javascript expression. Script engine error: TypeError: [JavaPackage
SimpleClass] is not a function. (DataSet[Fvr].__bm_OPEN#2) Script source:
DataSet[Fvr].__bm_OPEN, line: 1, text:__bm_OPEN() 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:79)
at
org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
... 45 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error
evaluating Javascript expression. Script engine error: TypeError:
[JavaPackage SimpleClass] is not a function. (DataSet[Fvr].__bm_OPEN#2)
Script source: DataSet[Fvr].__bm_OPEN, line: 1, text:__bm_OPEN() 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)
... 47 moreCaused by: org.mozilla.javascript.EcmaError: TypeError:
[JavaPackage SimpleClass] is not a function. (DataSet[Fvr].__bm_OPEN#2) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime .java:3246)
at
org.mozilla.javascript.ScriptRuntime.typeError1(ScriptRuntim e.java:3258)
at
org.mozilla.javascript.ScriptRuntime.notFunctionError(Script Runtime.java:3317)
at
org.mozilla.javascript.ScriptRuntime.notFunctionError(Script Runtime.java:3308)
at org.mozilla.javascript.ScriptRuntime.newObject(ScriptRuntime .java:2057)
at org.mozilla.javascript.gen.c38._c1(DataSet[Fvr].__bm_OPEN:2) at
org.mozilla.javascript.gen.c38.call(DataSet[Fvr].__bm_OPEN) at
org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRun time.java:105)
at org.mozilla.javascript.gen.c39._c0(DataSet[Fvr].__bm_OPEN:1) at
org.mozilla.javascript.gen.c39.call(DataSet[Fvr].__bm_OPEN) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c39.call(DataSet[Fvr].__bm_OPEN) at
org.mozilla.javascript.gen.c39.exec(DataSet[Fvr].__bm_OPEN) at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:98)
... 49 more
+ There are errors evaluating script "if( currentrow >= totalrows ) {
return( false );
}
var favrow = favorites.get(currentrow);
var Customer = favrow[0];
var Favorite = favrow[1];
var Color = favrow[2];
row["Customer"] = Customer;
row["Favorite"] = Favorite;
row["Color"] = Color;
currentrow = currentrow + 1;
return ( true );".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "if( currentrow >= totalrows ) { return( false
);}var favrow = favorites.get(currentrow);var Customer = favrow[0];var
Favorite = favrow[1];var Color = favrow[2];row["Customer"] =
Customer;row["Favorite"] = Favorite;row["Color"] = Color;currentrow =
currentrow + 1;return ( true );". 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.ScriptDataSet ScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java: 100)
at
org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch (ScriptDataSetRuntime.java:84)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery. java:246)
at
org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch (OdiAdapter.java:148)
at
org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:91)
at
org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:243)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:206)
at
org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:65)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:109)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:65)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doSinglePass(PassManager.java:120)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:80)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:62)
at
org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:207)
at
org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:118)
at
org.eclipse.birt.data.engine.executor.CandidateQuery.execute (CandidateQuery.java:88)
at
org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java :212)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
at
org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
at
org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
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:689) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
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.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:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)Caused by:
org.eclipse.birt.data.engine.core.DataException: A BIRT exception
occurred: Error evaluating Javascript expression. Script engine error:
ReferenceError: "currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2)
Script source: DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH(). See
next exception for more information.Error evaluating Javascript
expression. Script engine error: ReferenceError: "currentrow" is not
defined. (DataSet[Fvr].__bm_FETCH#2) Script source:
DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH() 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:79)
at
org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
... 60 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error
evaluating Javascript expression. Script engine error: ReferenceError:
"currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2) Script source:
DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH() 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)
... 62 moreCaused by: org.mozilla.javascript.EcmaError: ReferenceError:
"currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at
org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRun time.java:3303)
at
org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRu ntime.java:1632)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java :1571) at
org.mozilla.javascript.gen.c40._c1(DataSet[Fvr].__bm_FETCH:2 ) at
org.mozilla.javascript.gen.c40.call(DataSet[Fvr].__bm_FETCH) at
org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRun time.java:105)
at org.mozilla.javascript.gen.c41._c0(DataSet[Fvr].__bm_FETCH:1 ) at
org.mozilla.javascript.gen.c41.call(DataSet[Fvr].__bm_FETCH) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c41.call(DataSet[Fvr].__bm_FETCH) at
org.mozilla.javascript.gen.c41.exec(DataSet[Fvr].__bm_FETCH) at
org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:98)
... 64 more
+ Unhandled exception when executing script
|
|
|
Re: Scripted Data Source [message #202543 is a reply to message #202426] |
Wed, 22 November 2006 16:59   |
Eclipse User |
|
|
|
Originally posted by: johnw.innoventsolutions.com
Brad,
I didn't try to deploy to an app server. I tried it and came up with the
same error. Here is how I corrected it:
-Copied *.rptdesign to my %APACHE_ROOT%\webapps\birt folder
-Copied the Test.class file to %APACHE_ROOT%\WEBAPPS\birt\scriptlib folder.
-tried to run my report (which gave an error).
-Checked the configuration under %birt_home%\webinf (web.xml,
web-template.xml) and found that BIRT is indeed expecting the files
under scriptlib, changed log level to FINE
-As a hunch, the config files say specifically "*.JAR" files, so I went
into the scriptlib folder and made a .JAR file with the following
command: (assuming Test.class is the only class file in that directory)
C:\Program Files\Java\jdk1.5.0_09\bin\jar -cf Test.jar *.class
-Restarted Apache
-Re-ran the report. It worked. That fixed the problem.
John
brad wrote:
> I was able to get the sample working so that when I preview the report
> design in Eclipse, it pulls the data from the .class file.
> However, when I copy over the files into the WebViewerExample, I get the
> same error as yesterday with the . So I have as the directory stucture...
>
> *mywebroot*/WebViewerExample/example.rptdesign
> *mywebroot*/WebViewerExample/WEB-INF
> *mywebroot*/WebViewerExample/webcontent
> *mywebroot*/WebViewerExample/scriptlib
> *mywebroot*/WebViewerExample/report
>
> Should I be able to just copy over the files? If so, where do I paste
> them in?
>
> thanks for everyones help.
>
>
>
>
> error from yesterday / today in the webviewerxample:
>
>
> The following items have errors:
>
> Table (id = 110): + There are errors evaluating script "favoritesClass =
> new Packages.SimpleClass();
> favorites = favoritesClass.readData();
> totalrows = favorites.size();
> currentrow = 0;". Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "favoritesClass = new
> Packages.SimpleClass();favorites = favoritesClass.readData();totalrows =
> favorites.size();currentrow = 0;". 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.ScriptDataSet ScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:6 6)
> at
> org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open( ScriptDataSetRuntime.java:68)
> at
> org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.j ava:233)
> at
> org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java :209)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
> at
> org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
> at
> org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
> at
> org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
> 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:689)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> 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.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:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)Caused by:
> org.eclipse.birt.data.engine.core.DataException: A BIRT exception
> occurred: Error evaluating Javascript expression. Script engine error:
> TypeError: [JavaPackage SimpleClass] is not a function.
> (DataSet[Fvr].__bm_OPEN#2) Script source: DataSet[Fvr].__bm_OPEN, line:
> 1, text:__bm_OPEN(). See next exception for more information.Error
> evaluating Javascript expression. Script engine error: TypeError:
> [JavaPackage SimpleClass] is not a function. (DataSet[Fvr].__bm_OPEN#2)
> Script source: DataSet[Fvr].__bm_OPEN, line: 1, text:__bm_OPEN() 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:79)
> at
> org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
> .. 45 moreCaused by: org.eclipse.birt.core.exception.CoreException:
> Error evaluating Javascript expression. Script engine error: TypeError:
> [JavaPackage SimpleClass] is not a function. (DataSet[Fvr].__bm_OPEN#2)
> Script source: DataSet[Fvr].__bm_OPEN, line: 1, text:__bm_OPEN() 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)
> .. 47 moreCaused by: org.mozilla.javascript.EcmaError: TypeError:
> [JavaPackage SimpleClass] is not a function. (DataSet[Fvr].__bm_OPEN#2)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
> at
> org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime .java:3246)
> at
> org.mozilla.javascript.ScriptRuntime.typeError1(ScriptRuntim e.java:3258)
> at
> org.mozilla.javascript.ScriptRuntime.notFunctionError(Script Runtime.java:3317)
> at
> org.mozilla.javascript.ScriptRuntime.notFunctionError(Script Runtime.java:3308)
> at
> org.mozilla.javascript.ScriptRuntime.newObject(ScriptRuntime .java:2057)
> at org.mozilla.javascript.gen.c38._c1(DataSet[Fvr].__bm_OPEN:2) at
> org.mozilla.javascript.gen.c38.call(DataSet[Fvr].__bm_OPEN) at
> org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRun time.java:105)
> at org.mozilla.javascript.gen.c39._c0(DataSet[Fvr].__bm_OPEN:1) at
> org.mozilla.javascript.gen.c39.call(DataSet[Fvr].__bm_OPEN) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at
> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c39.call(DataSet[Fvr].__bm_OPEN) at
> org.mozilla.javascript.gen.c39.exec(DataSet[Fvr].__bm_OPEN) at
> org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:98)
> .. 49 more
> + There are errors evaluating script "if(
> currentrow >= totalrows ) {
> return( false );
> }
>
> var favrow = favorites.get(currentrow);
>
> var Customer = favrow[0];
> var Favorite = favrow[1];
> var Color = favrow[2];
>
> row["Customer"] = Customer;
> row["Favorite"] = Favorite;
> row["Color"] = Color;
> currentrow = currentrow + 1;
>
> return ( true );". Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "if( currentrow >= totalrows ) { return( false
> );}var favrow = favorites.get(currentrow);var Customer = favrow[0];var
> Favorite = favrow[1];var Color = favrow[2];row["Customer"] =
> Customer;row["Favorite"] = Favorite;row["Color"] = Color;currentrow =
> currentrow + 1;return ( true );". 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.ScriptDataSet ScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java: 100)
> at
> org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch (ScriptDataSetRuntime.java:84)
> at
> org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery. java:246)
> at
> org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch (OdiAdapter.java:148)
> at
> org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:91)
> at
> org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:243)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:206)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:65)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:109)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:65)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doSinglePass(PassManager.java:120)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:80)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:62)
> at
> org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:207)
> at
> org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:118)
> at
> org.eclipse.birt.data.engine.executor.CandidateQuery.execute (CandidateQuery.java:88)
> at
> org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$Scri ptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java :212)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
> at
> org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
> at
> org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
> at
> org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
> 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:689)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> 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.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:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)Caused by:
> org.eclipse.birt.data.engine.core.DataException: A BIRT exception
> occurred: Error evaluating Javascript expression. Script engine error:
> ReferenceError: "currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2)
> Script source: DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH(). See
> next exception for more information.Error evaluating Javascript
> expression. Script engine error: ReferenceError: "currentrow" is not
> defined. (DataSet[Fvr].__bm_FETCH#2) Script source:
> DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH() 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:79)
> at
> org.eclipse.birt.report.engine.script.internal.DtEScriptExec utor.handleJS(DtEScriptExecutor.java:71)
> .. 60 moreCaused by: org.eclipse.birt.core.exception.CoreException:
> Error evaluating Javascript expression. Script engine error:
> ReferenceError: "currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2)
> Script source: DataSet[Fvr].__bm_FETCH, line: 1, text:__bm_FETCH() 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)
> .. 62 moreCaused by: org.mozilla.javascript.EcmaError: ReferenceError:
> "currentrow" is not defined. (DataSet[Fvr].__bm_FETCH#2) at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
> at
> org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRun time.java:3303)
> at
> org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRu ntime.java:1632)
> at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java :1571) at
> org.mozilla.javascript.gen.c40._c1(DataSet[Fvr].__bm_FETCH:2 ) at
> org.mozilla.javascript.gen.c40.call(DataSet[Fvr].__bm_FETCH) at
> org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRun time.java:105)
> at org.mozilla.javascript.gen.c41._c0(DataSet[Fvr].__bm_FETCH:1 ) at
> org.mozilla.javascript.gen.c41.call(DataSet[Fvr].__bm_FETCH) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at
> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c41.call(DataSet[Fvr].__bm_FETCH) at
> org.mozilla.javascript.gen.c41.exec(DataSet[Fvr].__bm_FETCH) at
> org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawS cript(JavascriptEvalUtil.java:98)
> .. 64 more
> + Unhandled exception when executing script
|
|
| |
Re: Scripted Data Source [message #202566 is a reply to message #202551] |
Wed, 22 November 2006 18:02  |
Eclipse User |
|
|
|
Originally posted by: johnw.innoventsolutions.com
Interesting. I was only able to get it to work by converting to a jar
file. I will try the classes folder (which doesn't exist, need to
create) and go from there.
Brad wrote:
> John,
>
> Actually, I just got it to work by doing the following:
>
> 1. copy the .class file or folder to:
> WebViewerExample\WEB-INF\classes
>
> 2. restarted Tomcat. ran the report and it worked.
> I've tested with a couple different class files now and they all seem to
> work.
>
>
>
|
|
|
Goto Forum:
Current Time: Mon Jun 09 18:36:15 EDT 2025
Powered by FUDForum. Page generated in 0.56620 seconds
|