Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine
Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #554957] Tue, 24 August 2010 21:44 Go to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Hi,

I'm using birt 2.3.1 engine api in a web service deployed to weblogic 10.x. The birt engine is instantiated properly on the first call. i keep getting 'Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine' error on subsequent calls.

I kind of following implementation example on http://wiki.eclipse.org/Servlet_Example_%28BIRT%29_2.1 because i can't find an birt 2.3 Servlet implementation example.

I appreciate any help in advance.

dash.

// code snippets
private IReportEngine getBirtEngine(ServletContext sc) {


IReportEngine re = null;

if (sc != null) {
EngineConfig ec = new EngineConfig();

ec.setLogConfig(BIRT_LOGS_PATH, Level.FINE);
ec.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOADE R_KEY, Thread.currentThread().getContextClassLoader());
ec.setEngineHome("");
IPlatformContext pc = new PlatformServletContext(sc);
ec.setPlatformContext(pc);


try {
Platform.startup(ec);

}
catch (BirtException be) {
e.printStackTrace();
}

IReportEngineFactory ref = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_ REPORT_ENGINE_FACTORY);

// offending line. remote debugger hangs here.
re = ref.createReportEngine(ec);
}


return re;
}


@WebMethod
public RetrieveReportResponse getReport(RetrieveReportRequest request)
throws OperationTimeoutException, OperationValidationException, OperationException
{


ServletContext sc = wsctx.getHttpSession().getServletContext();


IReportEngine re = getBirtEngine(sc);

if (re != null) {
// debugging code
String [] formats = re.getSupportedFormats();
if (formats != null){
for (String format: formats){
System.out.println("*****supported format:" + format);
}
}
}
else {
System.out.println("***** Unable to obtain birt engine");
}

try {
if (re != null) {
re.destroy();
re = null;
}
Platform.shutdown();


}
catch (Exception e){
// handle exception
}

return response;
}


Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #554960 is a reply to message #554957] Tue, 24 August 2010 22:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

It looks like you are trying to start-up the engine each time. Look at
the BirtEngine class in the wiki page that you referenced:

public static synchronized IReportEngine getBirtEngine

It only starts up the platform once.

Also look further down the wiki page for later version examples.

Jason

On 8/24/2010 5:44 PM, dash wrote:
> Hi,
>
> I'm using birt 2.3.1 engine api in a web service deployed to weblogic
> 10.x. The birt engine is instantiated properly on the first call. i keep
> getting 'Could not initialize class
> org.eclipse.birt.report.engine.api.impl.ReportEngine' error on
> subsequent calls.
>
> I kind of following implementation example on
> http://wiki.eclipse.org/Servlet_Example_%28BIRT%29_2.1 because i can't
> find an birt 2.3 Servlet implementation example.
>
> I appreciate any help in advance.
>
> dash.
>
> // code snippets
> private IReportEngine getBirtEngine(ServletContext sc) {
>
>
> IReportEngine re = null;
>
> if (sc != null) {
> EngineConfig ec = new EngineConfig();
>
> ec.setLogConfig(BIRT_LOGS_PATH, Level.FINE);
> ec.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOADE R_KEY,
> Thread.currentThread().getContextClassLoader());
> ec.setEngineHome("");
> IPlatformContext pc = new PlatformServletContext(sc);
> ec.setPlatformContext(pc);
>
>
> try {
> Platform.startup(ec);
>
> }
> catch (BirtException be) {
> e.printStackTrace();
> }
>
> IReportEngineFactory ref = (IReportEngineFactory)
> Platform.createFactoryObject(IReportEngineFactory.EXTENSION_
> REPORT_ENGINE_FACTORY);
>
> // offending line. remote debugger hangs here.
> re = ref.createReportEngine(ec);
> }
>
> return re;
> }
>
>
> @WebMethod
> public RetrieveReportResponse getReport(RetrieveReportRequest request)
> throws OperationTimeoutException, OperationValidationException,
> OperationException
> {
>
>
> ServletContext sc = wsctx.getHttpSession().getServletContext();
>
>
> IReportEngine re = getBirtEngine(sc);
>
> if (re != null) {
> // debugging code
> String [] formats = re.getSupportedFormats();
> if (formats != null){
> for (String format: formats){
> System.out.println("*****supported format:" + format);
> }
> }
> }
> else {
> System.out.println("***** Unable to obtain birt engine");
> }
>
> try {
> if (re != null) {
> re.destroy();
> re = null;
> }
> Platform.shutdown();
>
>
> }
> catch (Exception e){
> // handle exception
> }
>
> return response;
> }
>
>
>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555204 is a reply to message #554960] Wed, 25 August 2010 19:35 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

Thanks for your prompt response. I've the birt engine issue resolved. However, I run into another issue with the birt designer when I try to preview my report. The designer keeps crashing and hanging. The datasource and dataset work fine individually.

After a bit Googling, I use the following settings to start the Ganymede. But, the issue remains.

C:\dev\ganymede\eclipse\ganymede-eclipse.exe -clean vmargs -Xms128m -Xmx512m -XX:MaxPermSize=512m

Your help is greatly appreciated!

Thanks,
kenny

// log
!SESSION 2010-08-25 14:17:05.880 -----------------------------------------------
eclipse.buildId=M20090211-1700
java.version=1.6.0_18
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Framework arguments: vmargs -Xms128m -Xmx512m -XX:MaxPermSize=512m
Command-line arguments: -os win32 -ws win32 -arch x86 -clean vmargs -Xms128m -Xmx512m -XX:MaxPermSize=512m

!ENTRY org.eclipse.ui.workbench.texteditor 4 0 2010-08-25 14:17:17.177
!MESSAGE The 'org.eclipse.wst.jsdt.web.ui.internal.hyperlink.script.JSPJa vaHyperlinkDetector' extension from plug-in 'org.eclipse.wst.jsdt.web.ui' to the 'org.eclipse.ui.workbench.texteditor.hyperlinkDetectors' extension point will be ignored because it contains invalid attributes.

!ENTRY org.eclipse.ui.workbench.texteditor 4 0 2010-08-25 14:17:17.177
!MESSAGE The 'org.eclipse.wst.jsdt.web.ui.internal.hyperlink.script.event .JSPJavaHyperlinkDetector' extension from plug-in 'org.eclipse.wst.jsdt.web.ui' to the 'org.eclipse.ui.workbench.texteditor.hyperlinkDetectors' extension point will be ignored because it contains invalid attributes.

// accounts.rptdesign
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build &lt;2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="iconFile">/templates/simple_listing.gif</property>
<property name="cheatSheet"> org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting </property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="myDataSrc" id="27">
<property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:@ps51201:1521:DEVDB</property >
<property name="odaUser">john</property>
<encrypted-property name="odaPassword" encryptionID="base64">dWJ2YnVpbGQ=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="accounts" id="28">
<list-property name="columnHints">
<structure>
<property name="columnName">ID</property>
<property name="displayName">ID</property>
</structure>
<structure>
<property name="columnName">EXTERNALACCOUNTNUMBER</property>
<property name="displayName">EXTERNALACCOUNTNUMBER</property>
</structure>
<structure>
<property name="columnName">ACCOUNTNAME</property>
<property name="displayName">ACCOUNTNAME</property>
</structure>
<structure>
<property name="columnName">STATUS</property>
<property name="displayName">STATUS</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ACCOUNTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">STATUS</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">myDataSrc</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ID</property>
<property name="nativeName">ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<property name="nativeName">EXTERNALACCOUNTNUMBER</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ACCOUNTNAME</property>
<property name="nativeName">ACCOUNTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
</list-property>
<property name="queryText">select *
from ACCOUNTS</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ID</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>EXTERNALACCOUNTNUMBER</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>EXTERNALACCOUNTNUMBER</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>EXTERNALACCOUNTNUMBER</design:label>
<design:formattingHints>
<design:displaySize>32</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ACCOUNTNAME</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ACCOUNTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ACCOUNTNAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STATUS</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STATUS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATUS</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="24">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="25">
<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="26">
<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">
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.25in</property>
<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>
<table id="4">
<property name="width">100%</property>
<property name="dataSet">accounts</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<property name="displayName">EXTERNALACCOUNTNUMBER</property>
<expression name="expression">dataSetRow["EXTERNALACCOUNTNUMBER"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ACCOUNTNAME</property>
<property name="displayName">ACCOUNTNAME</property>
<expression name="expression">dataSetRow["ACCOUNTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATUS</property>
<property name="displayName">STATUS</property>
<expression name="expression">dataSetRow["STATUS"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<column id="20"/>
<column id="21"/>
<column id="22"/>
<column id="23"/>
<header>
<row id="5">
<cell id="6"/>
<cell id="7">
<label id="29">
<text-property name="text">EXTERNALACCOUNTNUMBER</text-property>
</label>
</cell>
<cell id="8">
<label id="31">
<text-property name="text">ACCOUNTNAME</text-property>
</label>
</cell>
<cell id="9">
<label id="33">
<text-property name="text">STATUS</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="10">
<cell id="11"/>
<cell id="12">
<data id="30">
<property name="resultSetColumn">EXTERNALACCOUNTNUMBER</property>
</data>
</cell>
<cell id="13">
<data id="32">
<property name="resultSetColumn">ACCOUNTNAME</property>
</data>
</cell>
<cell id="14">
<data id="34">
<property name="resultSetColumn">STATUS</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="15">
<cell id="16"/>
<cell id="17"/>
<cell id="18"/>
<cell id="19"/>
</row>
</footer>
</table>
</body>
</report>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555221 is a reply to message #555204] Wed, 25 August 2010 22:16 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

I've the report designer crashing issue fixed by starting the designer with -vm C:\dev\jdk1.5.0_22\bin\java.exe. I'm able to preview my report with proper data showing in the designer.

However, when I run the same report in WebLogic, the data don't show up in the generated pdf, that shows the headings and date/time. The birt log indicates that the data are returned properly, so there isn't an issue of the jdbc connection.

Any thought?

Thanks,
kenny

// birt log
Aug 25, 2010 4:48:56 PM org.eclipse.birt.data.engine.odaconsumer.ResultSet fetch
FINEST: Fetched next row: 1,TestComp,Testing Company,1 .

Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555245 is a reply to message #555221] Thu, 26 August 2010 04:14 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report?

On 8/25/2010 6:16 PM, dash wrote:
> Jason,
>
> I've the report designer crashing issue fixed by starting the designer
> with -vm C:\dev\jdk1.5.0_22\bin\java.exe. I'm able to preview my report
> with proper data showing in the designer.
> However, when I run the same report in WebLogic, the data don't show up
> in the generated pdf, that shows the headings and date/time. The birt
> log indicates that the data are returned properly, so there isn't an
> issue of the jdbc connection.
>
> Any thought?
>
> Thanks,
> kenny
>
> // birt log
> Aug 25, 2010 4:48:56 PM
> org.eclipse.birt.data.engine.odaconsumer.ResultSet fetch
> FINEST: Fetched next row: 1,TestComp,Testing Company,1 .
>
>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555403 is a reply to message #555245] Thu, 26 August 2010 14:02 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Here is the report.

Thanks for your help,
kenny


<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build &lt;2.3.2.v20090218-0730></property>
<property name="units">in</property>
<property name="iconFile">/templates/first_report.gif</property>
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.firstreport </property>
<property name="bidiLayoutOrientation">ltr</property>
<template-parameter-definitions>
<template-parameter-definition name="NewTemplateParameterDefinition" id="28">
<property name="allowedType">Table</property>
<text-property name="description">Customer Listing</text-property>
<default>
<table id="29">
<property name="width">100%</property>
<property name="pageBreakInterval">50</property>
<column id="49"/>
<column id="50"/>
<column id="51"/>
<column id="52"/>
<header>
<row id="30">
<cell id="31">
<label id="32">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Contact</text-property>
</label>
</cell>
<cell id="33">
<label id="34">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">First</text-property>
</label>
</cell>
<cell id="35">
<label id="36">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Last</text-property>
</label>
</cell>
<cell id="37">
<label id="38">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Phone</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="39">
<cell id="40"/>
<cell id="41"/>
<cell id="42"/>
<cell id="43"/>
</row>
</detail>
<footer>
<row id="44">
<cell id="45"/>
<cell id="46"/>
<cell id="47"/>
<cell id="48"/>
</row>
</footer>
</table>
</default>
</template-parameter-definition>
<template-parameter-definition name="NewTemplateParameterDefinition1" id="78">
<property name="allowedType">Table</property>
<text-property name="description">Customer Listing Table</text-property>
<default>
<table id="79">
<property name="width">100%</property>
<property name="refTemplateParameter">NewTemplateParameterDefinition </property>
<property name="pageBreakInterval">50</property>
<column id="99"/>
<column id="100"/>
<column id="101"/>
<column id="102"/>
<header>
<row id="80">
<cell id="81">
<label id="82">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Contact</text-property>
</label>
</cell>
<cell id="83">
<label id="84">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">First</text-property>
</label>
</cell>
<cell id="85">
<label id="86">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Last</text-property>
</label>
</cell>
<cell id="87">
<label id="88">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Phone</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="89">
<cell id="90"/>
<cell id="91"/>
<cell id="92"/>
<cell id="93"/>
</row>
</detail>
<footer>
<row id="94">
<cell id="95"/>
<cell id="96"/>
<cell id="97"/>
<cell id="98"/>
</row>
</footer>
</table>
</default>
</template-parameter-definition>
<template-parameter-definition name="NewTemplateParameterDefinition2" id="132">
<property name="allowedType">Table</property>
<text-property name="description">Customer Listing Table</text-property>
<default>
<table id="133">
<property name="width">100%</property>
<property name="refTemplateParameter">NewTemplateParameterDefinition1 </property>
<property name="pageBreakInterval">50</property>
<column id="157"/>
<column id="158"/>
<column id="159"/>
<column id="160"/>
<header>
<row id="134">
<cell id="135">
<label id="136">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Contact</text-property>
</label>
</cell>
<cell id="137">
<label id="138">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">First</text-property>
</label>
</cell>
<cell id="139">
<label id="140">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Last</text-property>
</label>
</cell>
<cell id="141">
<label id="142">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Phone</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="143">
<cell id="144">
<data id="145"/>
</cell>
<cell id="146">
<data id="147"/>
</cell>
<cell id="148">
<data id="149"/>
</cell>
<cell id="150">
<data id="151"/>
</cell>
</row>
</detail>
<footer>
<row id="152">
<cell id="153"/>
<cell id="154"/>
<cell id="155"/>
<cell id="156"/>
</row>
</footer>
</table>
</default>
</template-parameter-definition>
</template-parameter-definitions>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="devDataSource" id="248">
<property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:@devdb.lab.com:1521:DEVDB</property >
<property name="odaUser">devuser</property>
<encrypted-property name="odaPassword" encryptionID="base64">dWJ2YnVpbGQ=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="accounts" id="249">
<list-property name="columnHints">
<structure>
<property name="columnName">ID</property>
<property name="displayName">ID</property>
</structure>
<structure>
<property name="columnName">EXTERNALACCOUNTNUMBER</property>
<property name="displayName">EXTERNALACCOUNTNUMBER</property>
</structure>
<structure>
<property name="columnName">ACCOUNTNAME</property>
<property name="displayName">ACCOUNTNAME</property>
</structure>
<structure>
<property name="columnName">STATUS</property>
<property name="displayName">STATUS</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ACCOUNTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">STATUS</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="devDataSource">devuser</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ID</property>
<property name="nativeName">ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<property name="nativeName">EXTERNALACCOUNTNUMBER</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ACCOUNTNAME</property>
<property name="nativeName">ACCOUNTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">STATUS</property>
<property name="nativeName">STATUS</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
</list-property>
<property name="queryText">select *
from APPACCOUNT</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ID</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>EXTERNALACCOUNTNUMBER</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>32</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>EXTERNALACCOUNTNUMBER</design:displayName >
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>EXTERNALACCOUNTNUMBER</design:label>
<design:formattingHints>
<design:displaySize>32</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ACCOUNTNAME</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ACCOUNTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ACCOUNTNAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STATUS</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>2</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STATUS</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STATUS</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="110">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="246">
<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="247">
<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">
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.25in</property>
<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>
<label id="245">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">x-large</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Customer Listing</text-property>
</label>
<table id="163">
<property name="width">100%</property>
<property name="dataSet">accounts</property>
<property name="refTemplateParameter">NewTemplateParameterDefinition2 </property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ACCOUNTNAME</property>
<property name="displayName">ACCOUNTNAME</property>
<expression name="expression">dataSetRow["ACCOUNTNAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<property name="displayName">EXTERNALACCOUNTNUMBER</property>
<expression name="expression">dataSetRow["EXTERNALACCOUNTNUMBER"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">STATUS</property>
<property name="displayName">STATUS</property>
<expression name="expression">dataSetRow["STATUS"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">ID</property>
<property name="displayName">ID</property>
<expression name="expression">dataSetRow["ID"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<column id="187"/>
<column id="188"/>
<column id="189"/>
<column id="190"/>
<header>
<row id="164">
<cell id="165">
<label id="166">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Account Name</text-property>
</label>
</cell>
<cell id="167">
<label id="168">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Ext Name</text-property>
</label>
</cell>
<cell id="169">
<label id="170">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Last</text-property>
</label>
</cell>
<cell id="171">
<label id="172">
<property name="fontFamily">sans-serif</property>
<property name="fontWeight">bold</property>
<text-property name="text">Phone</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="173">
<cell id="174">
<data id="250">
<property name="dataSet">accounts</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">ACCOUNTNAME</property>
<expression name="expression">dataSetRow["ACCOUNTNAME"]</expression >
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">ACCOUNTNAME</property>
</data>
</cell>
<cell id="176">
<data id="251">
<property name="dataSet">accounts</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">EXTERNALACCOUNTNUMBER</property>
<expression name="expression">dataSetRow["EXTERNALACCOUNTNUMBER"]</expression >
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">EXTERNALACCOUNTNUMBER</property>
</data>
</cell>
<cell id="178">
<data id="252">
<property name="resultSetColumn">STATUS</property>
</data>
</cell>
<cell id="180">
<data id="253">
<property name="resultSetColumn">ID</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="182">
<cell id="183"/>
<cell id="184"/>
<cell id="185"/>
<cell id="186"/>
</row>
</footer>
</table>
</body>
</report>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555459 is a reply to message #555403] Thu, 26 August 2010 16:30 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kenny,

If you create a report off the sample db does it work?

Jason

On 8/26/2010 10:02 AM, dash wrote:
> Here is the report.
>
> Thanks for your help,
> kenny
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/first_report.gif</property>
> <property
> name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.firstreport
> </property>
> <property name="bidiLayoutOrientation">ltr</property>
> <template-parameter-definitions>
> <template-parameter-definition name="NewTemplateParameterDefinition"
> id="28">
> <property name="allowedType">Table</property>
> <text-property name="description">Customer Listing</text-property>
> <default>
> <table id="29">
> <property name="width">100%</property>
> <property name="pageBreakInterval">50</property>
> <column id="49"/>
> <column id="50"/>
> <column id="51"/>
> <column id="52"/>
> <header>
> <row id="30">
> <cell id="31">
> <label id="32">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Contact</text-property>
> </label>
> </cell>
> <cell id="33">
> <label id="34">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">First</text-property>
> </label>
> </cell>
> <cell id="35">
> <label id="36">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Last</text-property>
> </label>
> </cell>
> <cell id="37">
> <label id="38">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Phone</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="39">
> <cell id="40"/>
> <cell id="41"/>
> <cell id="42"/>
> <cell id="43"/>
> </row>
> </detail>
> <footer>
> <row id="44">
> <cell id="45"/>
> <cell id="46"/>
> <cell id="47"/>
> <cell id="48"/>
> </row>
> </footer>
> </table>
> </default>
> </template-parameter-definition>
> <template-parameter-definition name="NewTemplateParameterDefinition1"
> id="78">
> <property name="allowedType">Table</property>
> <text-property name="description">Customer Listing Table</text-property>
> <default>
> <table id="79">
> <property name="width">100%</property>
> <property name="refTemplateParameter">NewTemplateParameterDefinition
> </property>
> <property name="pageBreakInterval">50</property>
> <column id="99"/>
> <column id="100"/>
> <column id="101"/>
> <column id="102"/>
> <header>
> <row id="80">
> <cell id="81">
> <label id="82">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Contact</text-property>
> </label>
> </cell>
> <cell id="83">
> <label id="84">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">First</text-property>
> </label>
> </cell>
> <cell id="85">
> <label id="86">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Last</text-property>
> </label>
> </cell>
> <cell id="87">
> <label id="88">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Phone</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="89">
> <cell id="90"/>
> <cell id="91"/>
> <cell id="92"/>
> <cell id="93"/>
> </row>
> </detail>
> <footer>
> <row id="94">
> <cell id="95"/>
> <cell id="96"/>
> <cell id="97"/>
> <cell id="98"/>
> </row>
> </footer>
> </table>
> </default>
> </template-parameter-definition>
> <template-parameter-definition name="NewTemplateParameterDefinition2"
> id="132">
> <property name="allowedType">Table</property>
> <text-property name="description">Customer Listing Table</text-property>
> <default>
> <table id="133">
> <property name="width">100%</property>
> <property name="refTemplateParameter">NewTemplateParameterDefinition1
> </property>
> <property name="pageBreakInterval">50</property>
> <column id="157"/>
> <column id="158"/>
> <column id="159"/>
> <column id="160"/>
> <header>
> <row id="134">
> <cell id="135">
> <label id="136">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Contact</text-property>
> </label>
> </cell>
> <cell id="137">
> <label id="138">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">First</text-property>
> </label>
> </cell>
> <cell id="139">
> <label id="140">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Last</text-property>
> </label>
> </cell>
> <cell id="141">
> <label id="142">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Phone</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="143">
> <cell id="144">
> <data id="145"/>
> </cell>
> <cell id="146">
> <data id="147"/>
> </cell>
> <cell id="148">
> <data id="149"/>
> </cell>
> <cell id="150">
> <data id="151"/>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="152">
> <cell id="153"/>
> <cell id="154"/>
> <cell id="155"/>
> <cell id="156"/>
> </row>
> </footer>
> </table>
> </default>
> </template-parameter-definition>
> </template-parameter-definitions>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="devDataSource" id="248">
> <property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
> <property
> name="odaURL">jdbc:oracle:thin:@devdb.lab.com:1521:DEVDB</property >
> <property name="odaUser">devuser</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">dWJ2YnVpbGQ=</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="accounts" id="249">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">ID</property>
> <property name="displayName">ID</property>
> </structure>
> <structure>
> <property name="columnName">EXTERNALACCOUNTNUMBER</property>
> <property name="displayName">EXTERNALACCOUNTNUMBER</property>
> </structure>
> <structure>
> <property name="columnName">ACCOUNTNAME</property>
> <property name="displayName">ACCOUNTNAME</property>
> </structure>
> <structure>
> <property name="columnName">STATUS</property>
> <property name="displayName">STATUS</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">EXTERNALACCOUNTNUMBER</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">ACCOUNTNAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">STATUS</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="devDataSource">devuser</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ID</property>
> <property name="nativeName">ID</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">EXTERNALACCOUNTNUMBER</property>
> <property name="nativeName">EXTERNALACCOUNTNUMBER</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">ACCOUNTNAME</property>
> <property name="nativeName">ACCOUNTNAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">STATUS</property>
> <property name="nativeName">STATUS</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from APPACCOUNT</property>
> <xml-property name="designerValues"><![CDATA[<?xml version="1.0"
> encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ID</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>19</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>ID</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ID</design:label>
> <design:formattingHints>
> <design:displaySize>22</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>EXTERNALACCOUNTNUMBER</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>32</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>EXTERNALACCOUNTNUMBER</design:displayName >
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>EXTERNALACCOUNTNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>32</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ACCOUNTNAME</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>255</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>ACCOUNTNAME</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>ACCOUNTNAME</design:label>
> <design:formattingHints>
> <design:displaySize>255</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>STATUS</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>2</design:nativeDataTypeCode>
> <design:precision>19</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>STATUS</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>STATUS</design:label>
> <design:formattingHints>
> <design:displaySize>22</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="report" id="110">
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab-cell" id="246">
> <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="247">
> <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">
> <property name="topMargin">0.25in</property>
> <property name="leftMargin">0.25in</property>
> <property name="bottomMargin">0.25in</property>
> <property name="rightMargin">0.25in</property>
> <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>
> <label id="245">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">x-large</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Customer Listing</text-property>
> </label>
> <table id="163">
> <property name="width">100%</property>
> <property name="dataSet">accounts</property>
> <property name="refTemplateParameter">NewTemplateParameterDefinition2
> </property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ACCOUNTNAME</property>
> <property name="displayName">ACCOUNTNAME</property>
> <expression name="expression">dataSetRow["ACCOUNTNAME"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">EXTERNALACCOUNTNUMBER</property>
> <property name="displayName">EXTERNALACCOUNTNUMBER</property>
> <expression
> name="expression">dataSetRow["EXTERNALACCOUNTNUMBER"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">STATUS</property>
> <property name="displayName">STATUS</property>
> <expression name="expression">dataSetRow["STATUS"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">ID</property>
> <property name="displayName">ID</property>
> <expression name="expression">dataSetRow["ID"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <property name="pageBreakInterval">50</property>
> <column id="187"/>
> <column id="188"/>
> <column id="189"/>
> <column id="190"/>
> <header>
> <row id="164">
> <cell id="165">
> <label id="166">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Account Name</text-property>
> </label>
> </cell>
> <cell id="167">
> <label id="168">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Ext Name</text-property>
> </label>
> </cell>
> <cell id="169">
> <label id="170">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Last</text-property>
> </label>
> </cell>
> <cell id="171">
> <label id="172">
> <property name="fontFamily">sans-serif</property>
> <property name="fontWeight">bold</property>
> <text-property name="text">Phone</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="173">
> <cell id="174">
> <data id="250">
> <property name="dataSet">accounts</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ACCOUNTNAME</property>
> <expression name="expression">dataSetRow["ACCOUNTNAME"]</expression >
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">ACCOUNTNAME</property>
> </data>
> </cell>
> <cell id="176">
> <data id="251">
> <property name="dataSet">accounts</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">EXTERNALACCOUNTNUMBER</property>
> <expression
> name="expression">dataSetRow["EXTERNALACCOUNTNUMBER"]</expression >
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">EXTERNALACCOUNTNUMBER</property>
> </data>
> </cell>
> <cell id="178">
> <data id="252">
> <property name="resultSetColumn">STATUS</property>
> </data>
> </cell>
> <cell id="180">
> <data id="253">
> <property name="resultSetColumn">ID</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="182">
> <cell id="183"/>
> <cell id="184"/>
> <cell id="185"/>
> <cell id="186"/>
> </row>
> </footer>
> </table>
> </body>
> </report>
>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555485 is a reply to message #555459] Thu, 26 August 2010 18:05 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

I haven't done that, but why would it make a difference? The report runs properly in the designer.

Thanks,
kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555657 is a reply to message #555485] Fri, 27 August 2010 14:03 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I am wondering if something in the data/datasource may be causing the
issue. The designer does not return all data.

Jason

On 8/26/2010 2:05 PM, dash wrote:
> Jason,
>
> I haven't done that, but why would it make a difference? The report runs
> properly in the designer.
>
> Thanks,
> kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #555682 is a reply to message #555657] Fri, 27 August 2010 15:45 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

I'm not sure that I understand your comment. The report, running in the designer, does return all the data requested by the query. I verify the result against the db table.

Are you saying that the result set might not contain all the data, that should be fetched by the query, all the time in the designer? If yes, what would be the cause for the designer not fetching all the data requested by the query? Is there a fix for that?

On the other hand, do you have any suggestion where I should debug the run-time report issue? I'm kind of stuck at this point...

Thanks,
kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556000 is a reply to message #555682] Mon, 30 August 2010 14:08 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Hi Jason,

Any pointers to debug the missing data issue?

Thanks,
kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556055 is a reply to message #556000] Mon, 30 August 2010 16:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kenny,

I meant that in the designer, there is a preference that determines how
many rows to return. When deployed the engine retrieves all the data.
What I am wondering is if something in the full data is causing the
issue. If you run a report against the sample db we can eliminate so
possible causes.

Jason

On 8/30/2010 10:08 AM, dash wrote:
> Hi Jason,
>
> Any pointers to debug the missing data issue?
>
> Thanks,
> kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556088 is a reply to message #556055] Mon, 30 August 2010 18:22 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

My test table only has 5 rows of data. I can preview all 5 rows of data in the designer. But, there isn't a single row showing at run-time even though all the data shows up in the birt log.
The headings and data and time do get rendered properly in the PDF report. Just the data are missing...

> // birt log
> Aug 25, 2010 4:48:56 PM
> org.eclipse.birt.data.engine.odaconsumer.ResultSet fetch
> FINEST: Fetched next row: 1,TestComp,Testing Company,1 .

I don't think the size of the dataset is the issue if it's what you meant. Can you think of any other area that I can dig around?

Thanks,
kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556097 is a reply to message #556088] Mon, 30 August 2010 18:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kenny,

I checked your report again and noticed your dataset did not have a
datasource property.

Jason

On 8/30/2010 2:22 PM, dash wrote:
> Jason,
>
> My test table only has 5 rows of data. I can preview all 5 rows of data
> in the designer. But, there isn't a single row showing at run-time even
> though all the data shows up in the birt log.
> The headings and data and time do get rendered properly in the PDF
> report. Just the data are missing...
>
>> // birt log
>> Aug 25, 2010 4:48:56 PM
>> org.eclipse.birt.data.engine.odaconsumer.ResultSet fetch
>> FINEST: Fetched next row: 1,TestComp,Testing Company,1 .
>
> I don't think the size of the dataset is the issue if it's what you
> meant. Can you think of any other area that I can dig around?
>
> Thanks,
> kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556115 is a reply to message #554957] Mon, 30 August 2010 20:53 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

The data set has a property element pointing to the data-source element in the template. The birt log indicates that the data are fetched from the test table. I'm not quite sure what you meant...

Thanks,
kenny

<data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="devDataSource" id="248">
> <property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
> <property
> name="odaURL">jdbc:oracle:thin:@devdb.lab.com:1521:DEVDB</property >
> <property name="odaUser">devuser</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">dWJ2YnVpbGQ=</encrypted-property>
> </oda-data-source>
> </data-sources>


</data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="accounts" id="249">
...
<property name="devDataSource">devuser</property>
...

Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556272 is a reply to message #556115] Tue, 31 August 2010 14:38 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

When you look at the xml view do any errors show up? Can you try
rebuilding the report without the template?

On 8/30/2010 4:53 PM, dash wrote:
> Jason,
>
> The data set has a property element pointing to the data-source element
> in the template. The birt log indicates that the data are fetched from
> the test table. I'm not quite sure what you meant...
>
> Thanks,
> kenny
>
> <data-sources>
>> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
>> name="devDataSource" id="248">
>> <property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
>> <property
>> name="odaURL">jdbc:oracle:thin:@devdb.lab.com:1521:DEVDB</property >
>> <property name="odaUser">devuser</property>
>> <encrypted-property name="odaPassword"
>> encryptionID="base64">dWJ2YnVpbGQ=</encrypted-property>
>> </oda-data-source>
>> </data-sources>
>
>
> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="accounts" id="249">
> ...
> <property name="devDataSource">devuser</property>
> ...
>
>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556353 is a reply to message #554957] Tue, 31 August 2010 22:41 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

The xml looks good. I'm trying to build a blank report without any template being used if that is what you meant. However, the designer keeps crashing again. I get java.lang.OutOfMemoryError: PermGen space error after a few operations such as previewing report, switching between layout and xml source views.

I've tried different jvm startup settings for the designer without much luck. Any suggestion?

C:\dev\ganymede\eclipse\ganymede-eclipse.exe -clean -vm C:\dev\jdk1.5.0_22\bin\java.exe vmargs -Xms128m -Xmx512m -XX:PermSize=512m -XX:MaxPermSize=1024m

Thanks,
kenny


Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556355 is a reply to message #556353] Tue, 31 August 2010 23:29 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you try the helios allinone download?

On 8/31/2010 6:41 PM, dash wrote:
> Jason,
>
> The xml looks good. I'm trying to build a blank report without any
> template being used if that is what you meant. However, the designer
> keeps crashing again. I get java.lang.OutOfMemoryError: PermGen space
> error after a few operations such as previewing report, switching
> between layout and xml source views.
>
> I've tried different jvm startup settings for the designer without much
> luck. Any suggestion?
>
> C:\dev\ganymede\eclipse\ganymede-eclipse.exe -clean -vm
> C:\dev\jdk1.5.0_22\bin\java.exe vmargs -Xms128m -Xmx512m
> -XX:PermSize=512m -XX:MaxPermSize=1024m
>
> Thanks,
> kenny
>
>
>
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556558 is a reply to message #556355] Wed, 01 September 2010 18:28 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

I pull down 2.5.2 because I don't have the appetite to try helios, the greatest and latest, yet. The 252 designer works like a champ, so far. However, I get the following error at run-time. Any idea?

I assume the deployment structure between the 231 and 252 is the same, right?

The documentation on the birt site seems to be for the older versions. Does 252 have its own documentation? If yes, can you please send me a pointer?

Thanks,
kenny


Sep 1, 2010 1:15:39 PM org.eclipse.birt.core.internal.plugin.ScriptEngineFactoryMan agerImpl createFactory
SEVERE: Plug-in org.eclipse.birt.report.engine.script.javascript was unable to load class org.eclipse.birt.report.engine.javascript.JavascriptEngineFa ctory.
org.eclipse.core.runtime.CoreException: Plug-in org.eclipse.birt.report.engine.script.javascript was unable to load class org.eclipse.birt.report.engine.javascript.JavascriptEngineFa ctory.
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI .throwException(RegistryStrategyOSGI.java:180)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI .createExecutableExtension(RegistryStrategyOSGI.java:162)
at org.eclipse.core.internal.registry.ExtensionRegistry.createE xecutableExtension(ExtensionRegistry.java:874)
at org.eclipse.core.internal.registry.ConfigurationElement.crea teExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandl e.createExecutableExtension(ConfigurationElementHandle.java: 51)
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556559 is a reply to message #556558] Wed, 01 September 2010 18:34 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kenny,

Can you verify that you do not have js.jar in your cp at runtime. If
you do this could conflict with the version that BIRT uses.

Jason

On 9/1/2010 2:29 PM, dash wrote:
> Jason,
>
> I pull down 2.5.2 because I don't have the appetite to try helios, the
> greatest and latest, yet. The 252 designer works like a champ, so far.
> However, I get the following error at run-time. Any idea?
>
> I assume the deployment structure between the 231 and 252 is the same,
> right?
>
> The documentation on the birt site seems to be for the older versions.
> Does 252 have its own documentation? If yes, can you please send me a
> pointer?
>
> Thanks,
> kenny
>
>
> Sep 1, 2010 1:15:39 PM
> org.eclipse.birt.core.internal.plugin.ScriptEngineFactoryMan agerImpl
> createFactory
> SEVERE: Plug-in org.eclipse.birt.report.engine.script.javascript was
> unable to load class
> org.eclipse.birt.report.engine.javascript.JavascriptEngineFa ctory.
> org.eclipse.core.runtime.CoreException: Plug-in
> org.eclipse.birt.report.engine.script.javascript was unable to load
> class org.eclipse.birt.report.engine.javascript.JavascriptEngineFa ctory.
> at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI
> .throwException(RegistryStrategyOSGI.java:180)
> at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI
> .createExecutableExtension(RegistryStrategyOSGI.java:162)
> at org.eclipse.core.internal.registry.ExtensionRegistry.createE
> xecutableExtension(ExtensionRegistry.java:874)
> at org.eclipse.core.internal.registry.ConfigurationElement.crea
> teExecutableExtension(ConfigurationElement.java:243)
> at org.eclipse.core.internal.registry.ConfigurationElementHandl
> e.createExecutableExtension(ConfigurationElementHandle.java: 51)
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556562 is a reply to message #556559] Wed, 01 September 2010 18:53 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

Thanks for your prompt response. Yes, there is a js.jar, shared by multiple WARs, in myApp.ear/APP-INF/lib/. The birt js.jar is deployed in myReport.war/WEB-INF/lib/. myReport.war is one of many WARs in the myApp.ear. I cannot move the myReport.war out from the ear because myReport.war uses bunch of stuff in the ear.

I didn't run into this issue when deploying 231... What would be your suggestion to resolve this conflict? Remove the js.jar in myReport.war/WEB-INF/lib/, perhaps?

Thanks,
kenny

Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556720 is a reply to message #554957] Thu, 02 September 2010 12:51 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

Thanks for all your help. The run-time is working fine now. The documentation and samples on the birt site seem to be for older versions. I wonder whether there is documentation for the version 252. If yes, can you please send me a pointer?

Thanks,
kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556782 is a reply to message #556720] Thu, 02 September 2010 14:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kenny,

Glad you have it working. What did you need to do?
What specific documentation are you referring to. A lot of the
development examples are older, but should still work. The deployment
instructions should also work. We have a lot on the FAQ for deployment
as well. We need to go through the site and add some content, so
getting your feedback would be much appreciated.

Jason

On 9/2/2010 8:51 AM, dash wrote:
> Jason,
>
> Thanks for all your help. The run-time is working fine now. The
> documentation and samples on the birt site seem to be for older
> versions. I wonder whether there is documentation for the version 252.
> If yes, can you please send me a pointer?
>
> Thanks,
> kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #556884 is a reply to message #556782] Fri, 03 September 2010 03:02 Go to previous messageGo to next message
dash  is currently offline dash Friend
Messages: 20
Registered: August 2010
Junior Member
Jason,

I added <container-descriptor>
<prefer-web-inf-classes>true</prefer-web-inf-classes>
</container-descriptor> to the weblogic.xml in the WEB-INF of our war file. Instead of loading the js.jar from the ear's APP-INF/lib, the js.jar in the WEB-INF/lib gets loaded.

I'm looking for general documentation because I'm still learning different aspects of the BIRT.

I'm more than happy to contribute what I've learned back to the commnuity. Please send me a pointer.

Thanks,
kenny
Re: Could not initialize class org.eclipse.birt.report.engine.api.impl.ReportEngine [message #557003 is a reply to message #556884] Fri, 03 September 2010 15:09 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kenny,

can you look under http://wiki.eclipse.org/BIRT/FAQ and add an entry
under deployment.

Jason

On 9/2/2010 11:02 PM, dash wrote:
> Jason,
>
> I added <container-descriptor>
> <prefer-web-inf-classes>true</prefer-web-inf-classes>
> </container-descriptor> to the weblogic.xml in the WEB-INF of our war
> file. Instead of loading the js.jar from the ear's APP-INF/lib, the
> js.jar in the WEB-INF/lib gets loaded.
>
> I'm looking for general documentation because I'm still learning
> different aspects of the BIRT.
>
> I'm more than happy to contribute what I've learned back to the
> commnuity. Please send me a pointer.
>
> Thanks,
> kenny
Previous Topic:Filling array in BIRT
Next Topic:open "Report design" perspective when open a ".rptDesign" file
Goto Forum:
  


Current Time: Fri Nov 28 16:21:57 GMT 2014

Powered by FUDForum. Page generated in 0.07104 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software