Jboss in a EAR with BIRT Runtime Jarfiles and Scripted Datasource

We are using a Jbos_5.1.0 where we deploy our software. I am using the BIRT Jars Files from the BIRT RUNTIME 3.7.2. I created an *.rpdtdesign and wanted to add data while running the jboss. So i created a custom java eventhandler class. If I test the class in Designer Enviroment I get the exepted report. When i try to create the Report in Runtime Enviroment I get following issue: 
 
The following items have errors: 
 
Table (id = 23): 
+ A BIRT exception occurred. See next exception for more information. 
Invalid javascript expression: dataSetRow["columnname"] (Element ID:23) 
 
and in Logger: 
WARNING: can not load the class from file:/C:/Programme/../AppServer/jboss-5.1.0.GA/bin/ReportDataPrepare.jar 
java.io.FileNotFoundException: C:\Programme\..\AppServer\jboss-5.1.0.GA\bin\ReportDataPrepare.jar 
 
Here the fetch script: 
<pre class='_prettyXprint _lang-auto _linenums:0'>@Override
public boolean fetch(IDataSetInstance dataSet, IUpdatableDataSetRow row)
throws ScriptException {
try {
data = textread.createData();
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
_rowCount = data.size();
try {
if (_rowIndex < _rowCount) {
String str = String.valueOf(_rowIndex);
// Column name festlegen und werte stringweise ziehen
setColumnInRow(row, COLUMNNAME, data.get(str));
// go to next row
_rowIndex++;

return true;
}
} catch (ScriptException e) {
e.printStackTrace();

}
return super.fetch(dataSet, row);
}</pre>
 
I know that if i want to succeed this way, i have to set the path to the jar-files. Like : <pre class='_prettyXprint _lang-auto _linenums:0'>EngineConfig config = new EngineConfig();
config.setProperty(EngineConstants.WEBAPP_CLASSPATH_KEY, "c:\temp\eh.jar;c:\java\meh.jar");</pre>In this case where i deploy an EAR to start the appserver. I dont know how to get the direct path to the EventHandler Jar file. 
Any ideas? 
 
My aim is to create reports out of the data created by our application. so I actually have no database. So I wantd to create different EventHandler-Classses and Template Files for different use cases. So it is easy to create new Report Generation Workflows. 
This data are information about the running processes. I am new at BIRT and tried to develop an easy option for getting any kind of reports, only by having a *.rptdesing file and the runtime enviroment. May be I can push the data otherwise into the report? or should I use BIRT otherwise like a Servlet ? My Major Issue is a solution to set a path to the jar files...

Find more posts tagged with

Comments

JasonW

If you are using the POJO Viewer you should not need to set this:
config.setProperty(EngineConstants.WEBAPP_CLASSPATH_KEY, "c:\temp\eh.jar;c:\java\meh.jar");

Just add the jar to the WEB-INF/lib of your app. This error:
WARNING: can not load the class from file:/C:/Programme/../AppServer/jboss-5.1.0.GA/bin/ReportDataPrepare.jar

Looks like you are adding the jar to the report which you should not have to do. You should just have to add the jar to the project preferences:
http://birtworld.blogspot.com/2009/12/birt-designer-classpath-changes.html

Jason

Rochben

Ok, I set the classpaths in the designer enviroment (where I already can create the right report).And deleted the classpaths setting in the code, so I didnt get the warning. 
I think the reason why i cant generate the report in Runtime Enviroment, is the fact that i include BIRT_Runtime as external library (with the jars from Runtime-Package. is the the creation of a birt.war necessary??). 
I still get this result: 
 
The following items have errors: 
data.engine.BirtException ( 1 time(s) ) 
detail : org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred. See next exception for more information. 
Invalid javascript expression: dataSetRow["columnname"] (Element ID:23) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216) 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96) 
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:92) 
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) 
at de.__.reportgenerator.ReportGenerator.executeReport(ReportGenerator.java:115) (Element ID:23) 
Invalid javascript expression: dataSetRow["columnname"] 
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:504) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:276) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:193) 
at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:370) 
at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148) 
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:212) 
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98) 
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939) 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) 
... 77 more 
Caused by: org.eclipse.birt.core.exception.CoreException: Invalid javascript expression: dataSetRow["columnname"] 
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:85) 
at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:282) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:499) 
... 87 more 
Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core 
at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledExprFromTree(ExpressionParserUtility.java:160) 
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:78) 
... 89 more 
 
I attached the last Report Engine Log. 
If I start execute the code in Eclipse in a Main Class it works fine as well. 
Only when I am deploying the programm on jboss in our application I get this result. I wanted to integrate BIRT into our own application, so later on we can expand the functions. 
And here the following code snippet I use to generate the Report: 
<pre class='_prettyXprint _lang-auto _linenums:0'>public void executeReport() throws EngineException {

IReportEngine engine = null;
EngineConfig config = null;

try {
config = new EngineConfig();

config.setLogConfig("C:/Program Files/../AppServer/jboss-5.1.0.GA/server/default/log", Level.FINEST);
Platform.startup(config);
IReportEngineFactory factory = (IReportEngineFactory) Platform
.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
engine = factory.createReportEngine(config);

IReportRunnable design = null;
// Open the report design
design = engine.openReportDesign(_designpath);

if (_outputformat == "html") {
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
// task.setParameterValue("Top Count", (new Integer(5)));
// task.validateParameters();
outputpathrenamer();
HTMLRenderOption options = new HTMLRenderOption();
options.setOutputFileName(_outputpath);
options.setOutputFormat(_outputformat);
// options.setHtmlRtLFlag(false);
// options.setEmbeddable(false);
// options.setImageDirectory("C:\\test\\images");
task.setRenderOption(options);
task.run();
task.close();
} else {
IRunAndRenderTask ptask = engine.createRunAndRenderTask(design);
PDFRenderOption poptions = new PDFRenderOption();
outputpathrenamer();
poptions.setOutputFileName(_outputpath);
poptions.setOutputFormat(_outputformat);

ptask.setRenderOption(poptions);
ptask.run();
ptask.close();
}
engine.destroy();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
Platform.shutdown();
}</pre>

Rochben

Here the Designfile I use : 
<pre class='_prettyXprint _lang-auto _linenums:0'><?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408></property>
<html-property name="description">Test Template</html-property>
<property name="units">in</property>
<text-property name="displayName"> Test</text-property>
<property name="iconFile">/templates/logo.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<script-data-source name="Data Source" id="18"/>
</data-sources>
<data-sets>
<script-data-set name="Data Set" id="19">
<property name="eventHandlerClass">de.ott.reportInterface.reportdata.prepare.ReportDataPrepare</property>
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">columnname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Test</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">columnname</property>
</structure>
<structure>
<property name="columnName">Test</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">columnname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Test</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
</script-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<text id="9">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<H1>
<CENTER>
TITLE
</CENTER>
</H1>]]></text-property>
</text>
<table id="10">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">columnname</property>
<text-property name="displayName">columnname</text-property>
<expression name="expression" type="javascript">dataSetRow["columnname"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="17"/>
<header>
<row id="11">
<cell id="12"/>
</row>
</header>
<detail>
<row id="13">
<cell id="14">
<data id="22">
<property name="textAlign">left</property>
<property name="resultSetColumn">columnname</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="15">
<cell id="16"/>
</row>
</footer>
</table>
<table id="28">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Test</property>
<text-property name="displayName">Test</text-property>
<expression name="expression" type="javascript">dataSetRow["Test"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="35"/>
<header>
<row id="29">
<cell id="30">
<label id="36">
<text-property name="text">Test</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="31">
<cell id="32">
<data id="37">
<property name="textAlign">right</property>
<property name="resultSetColumn">Test</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="33">
<cell id="34"/>
</row>
</footer>
</table>
</body>
<list-property name="images">
<structure>
<property name="name">logo_prostep.jpg</property>
<property name="data">
</property>
</structure>
</list-property>
</report>
</pre>
For further information : I tried this <a class='bbc_url' href='http://wiki.eclipse.org/BIRT_3.7_Runtime_Deployment_Guide'>http://wiki.eclipse.org/BIRT_3.7_Runtime_Deployment_Guide</a> -> BIRT POJO Engine

JasonW

A couple of things. Does a simple report from the sampledb work in your deployed environment?
This code:
engine.destroy(); } catch (Exception ex) { ex.printStackTrace(); } finally { Platform.shutdown(); }

Really should only happen once in the lifetime of your application. Starting up the platform and shutting it down is expensive.

Jason

Rochben

Thanks for the quick responses. I know these are couple of things. I thought it would be usefull to give you as many information as possible. 
 
The sample Report has following error message: 
 
exception.error ( 1 time(s) ) 
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details: 
A BIRT exception occurred. See next exception for more information. 
Invalid javascript expression: row["CUSTOMERNAME"] (Element ID:1) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.doPrepareQuery(AbstractDataEngine.java:225) 
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doPrepareQuery(DteDataEngine.java:272) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:182) 
at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:122) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60) 
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60) 
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:61) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:178) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) 
at de.ott.reportgenerator.ReportGenerator.executeReport(ReportGenerator.java:115)Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details: 
A BIRT exception occurred. See next exception for more information. 
Invalid javascript expression: row["CUSTOMERNAME"] 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:677) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.doPrepareQuery(AbstractDataEngine.java:218) 
... 77 more 
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information. 
Invalid javascript expression: row["CUSTOMERNAME"] 
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:504) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractColumnExpression(ExpressionCompilerUtil.java:116) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractColumnExpression(ExpressionCompilerUtil.java:89) 
at org.eclipse.birt.data.engine.impl.PreparedQueryUtil.validateSorts(PreparedQueryUtil.java:314) 
at org.eclipse.birt.data.engine.impl.PreparedQueryUtil.validateQuery(PreparedQueryUtil.java:270) 
at org.eclipse.birt.data.engine.impl.PreparedQueryUtil.newInstance(PreparedQueryUtil.java:96) 
at org.eclipse.birt.data.engine.impl.DataEngineImpl.prepare(DataEngineImpl.java:408) 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:469) 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:660) 
... 78 more 
Caused by: org.eclipse.birt.core.exception.CoreException: Invalid javascript expression: row["CUSTOMERNAME"] 
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:85) 
at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:282) 
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:499) 
... 86 more 
Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core 
at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledExprFromTree(ExpressionParserUtility.java:160) 
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:78) 
... 88 more 
and in Report Log: 
[color="#8B0000"]FEIN: Invalid javascript expression: row["STATE"] 
org.eclipse.birt.core.exception.CoreException: Invalid javascript expression: row["STATE"] 
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:85) 
at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:282) 
at org.eclipse.birt.core.data.ExpressionUtil.getColumnBindingName(ExpressionUtil.java:221) 
at org.eclipse.birt.report.engine.parser.EngineIRVisitor.getColumnBinding(EngineIRVisitor.java:1167) 
at org.eclipse.birt.report.engine.parser.EngineIRVisitor.locateGroupIcon(EngineIRVisitor.java:1064) 
at org.eclipse.birt.report.engine.parser.EngineIRVisitor.visitTable(EngineIRVisitor.java:963) 
at org.eclipse.birt.report.engine.parser.MultiViewEngineIRVisitor.visitTable(MultiViewEngineIRVisitor.java:70) 
at org.eclipse.birt.report.model.api.DesignVisitorImpl$Forwarder.visitTable(DesignVisitorImpl.java:1100) 
at org.eclipse.birt.report.model.elements.TableItem.apply(TableItem.java:91) 
at org.eclipse.birt.report.model.api.DesignVisitorImpl.apply(DesignVisitorImpl.java:127) 
at org.eclipse.birt.report.engine.parser.EngineIRVisitor.visitReportDesign(EngineIRVisitor.java:414) 
at org.eclipse.birt.report.model.api.DesignVisitorImpl$Forwarder.visitReportDesign(DesignVisitorImpl.java:1222) 
at org.eclipse.birt.report.model.elements.ReportDesign.apply(ReportDesign.java:65) 
at org.eclipse.birt.report.model.api.DesignVisitorImpl.apply(DesignVisitorImpl.java:127) 
at org.eclipse.birt.report.engine.parser.EngineIRVisitor.translate(EngineIRVisitor.java:276) 
at org.eclipse.birt.report.engine.parser.ReportParser.parse(ReportParser.java:178) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.getReport(ExecutionContext.java:2206) 
at org.eclipse.birt.report.engine.executor.ReportExecutor.<init>(ReportExecutor.java:86) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:106) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) 
at de.ott.reportgenerator.ReportGenerator.executeReport(ReportGenerator.java:115)

JasonW

As a test can you deploy the viewer as described here:
http://wiki.eclipse.org/BirtPOJO_Viewer_JBOSS_Deployment
and run the report in the viewer?

Jason

Rochben

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="101643" data-time="1338827319" data-date="04 June 2012 - 09:28 AM">
As a test can you deploy the viewer as described here: 
<a class='bbc_url' href='http://wiki.eclipse.org/BirtPOJO_Viewer_JBOSS_Deployment'>http://wiki.eclipse.org/BirtPOJO_Viewer_JBOSS_Deployment</a> 
and run the report in the viewer? 
 
Jason </blockquote>
 
I created the birt.war in the deploy folder of the jboss-server...How can I run Reports there? Is there any tutorial which explains how to run the reports?

JasonW

Take a look at this page:
http://www.eclipse.org/birt/phoenix/deploy/viewerUsageMain.php

Jason