Thursday, January 12, 2006

Deploying BIRT 2.0 RC to JBoss

Currently with BIRT 2.0 RC you need to download extra files to allow the viewer to work. These files are listed in the download section of the BIRT site. This means that if you are using the birt.war file, you will need to extract it and include the required files.

A quick option for deploying BIRT to JBoss is as follows:

1 - Download the Report Engine from Eclipse. Also get the additional required files.

2 – Extract the zip file into a temp location.


3 – Copy the Web Viewer Example directory to your JBoss installation, under the deploy directory for your configuration. Mine happened to be C:\jboss-4.0.3SP1\server\default\deploy.

4 – Rename the Web Viewer Example directory to birt.war, so it will deploy in place.

5 - Copy itext-1.3.jar file to the /birt.war/plugins/org.eclipse.birt.report.engine.pdf/lib

6 – Copy prototype.js to /birt.war/plugins/org.eclipse.birt.report.viewer/birt/ajax/lib directory.

7 – Copy the following six jars to the birt.war/WEB-INF/lib directory.

axis.jar
axis-ant.jar
commons-discovery-0.2.jar
jaxrpc.jar
saaj.jar
wsdl4j-1.5.1.jar

Start up JBoss and enter the URL to BIRT (ie http://localhost:8080/birt) and run the test report.

16 comments:

Anonymous said...

Hi,

I could not get Birt to display records from the DB unless I copy axis.jar and axis-ant.jar to jboss/server/default/lib. I have jboss deployed on Windows and Fedora. For both servers I had to copy the two files.

I am running jboss4.0.1sp1

Jason Weathersby said...

With BIRT 2.0.1 the axis files are included. What version were you using?

Jason

Anonymous said...

Hi Jason,

I am using 2.0.1 but if I don't copy the tow jar files to jboss lib directory, I get only the birt viewer. The data form the database is not displayed.

Alain

Jason Weathersby said...

Alain,

I used 4.0.3 for my example. What error did you get? Is anything being displayed?

Thanks

Jason

Anonymous said...

Hi,

I get no error but the data is not displayed.

Jason Weathersby said...

Could you please log a bugzilla entry on this problem?

Anonymous said...

Hi,

Sure no problem. Could you just give me the web adress? Thanks.

Alain

Anonymous said...

Hi,

I created the bug report:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=142351

Alain

SEIVAbrasilis said...

so, my name´s is Carlos Magno and I want to built design report under jboss, how i do this?

Jason Weathersby said...

Are you saying you do not want to use the Eclipse BIRT design tool?
If that is the case you can use the Design Engine API.
Take a look at
http://wiki.eclipse.org/index.php/BIRT_Design_Engine_API

Jason

Jason Weathersby said...

I meant
BIRT_Design_Engine_API

Rocky said...
This comment has been removed by the author.
Rocky said...

Hi Jason,

I created two reports, one uses a sql query and the other has a stored procedure call. The report with the query displays the data but the report that calls the oracle procedure does not display data. Could you please help me out here. Everything seems to be fine with the report. Should I use any plugin for viewing data from a stored procedure, if yes, which one ?

Thanks for you help. Looking forward to your reply.

-Rocky

Scott Rosenbaum said...

Rocky,

Do you get any error messages with the Stored Procedure report?

How are you running the report, can you set the log level in the engine to FINEST and let us know what you see?

Rocky said...

Thank you for your prompt resply.

I dont see any error messages neither in the viewer nor in the logs. I have changed the log level to "FINEST" and here is the log.

Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.api.impl.ReportEngine &ls; init >
FINE: ReportEngine created. EngineConfig: EngineConfig: PLATFORM_CONTEXT=org.eclipse.birt.core.framework.PlatformServletContext@63198ed3;webapplication.projectclasspath=;logLevel=FINEST;maxRowsPerQuery=-1;org.eclipse.birt.report.engine.api.EngineConfig.emitterConfigs={html=org.eclipse.birt.report.engine.api.HTMLRenderOption@22eff179};org.eclipse.birt.report.engine.api.EngineConfig.scriptObjects={webapplication.projectclasspath=, PARENT_CLASSLOADER=WebappClassLoader^M
delegate: false^M
repositories:^M
----------> Parent Classloader:^M
java.net.FactoryURLClassLoader@35f4a968^M
};BIRT_HOME=;logDest=/opt/shared/apps/asec001_02/deploy/birt.war/logs;
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.reportitemGeneration
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadGenerationExtensionDefns
FINE: Load generation extension: Chart
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.reportitemPresentation
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadPresentationExtensionDefns
FINE: Load prsentation extension: Chart
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.reportitemQuery
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadQueryExtensionDefns
FINE: Load query extension: Chart
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.emitters
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
FINE: Load postscript emitter org.eclipse.birt.report.engine.emitter.postscript
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
FINE: Load doc emitter org.eclipse.birt.report.engine.emitter.word
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
FINE: Load pdf emitter org.eclipse.birt.report.engine.emitter.pdf
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
FINE: Load html emitter org.eclipse.birt.report.engine.emitter.html
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
FINE: Load ppt emitter org.eclipse.birt.report.engine.emitter.ppt
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadEmitterExtensionDefns
FINE: Load xls emitter org.eclipse.birt.report.engine.emitter.prototype.excel
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.reportEventHandler
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.reportItemPreparation
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.dataExtraction
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadDataExtractionExtensions
FINE: Load data extraction extension: org.eclipse.birt.report.engine.dataextraction.csv
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager getExtensions
FINE: Start load extension point: org.eclipse.birt.report.engine.extendedItemFactory
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadExtendedItems
FINE: Load extendedItem extension: Crosstab
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadExtendedItems
FINE: Load extendedItem extension: CrosstabCell
Oct 9, 2008 4:23:16 AM org.eclipse.birt.report.engine.extension.internal.ExtensionManager loadExtendedItems
FINE: Load extendedItem extension: AggregationCell


I tried viewing the report using the "Preview" tab in eclipse and also after deploying in JBOSS 4.0.4 server. The funniest part is that I am able to "Preview the OUTPUT PARAMETERS" in eclipse with correct values fetched from the DB, but when I run the report I find only the header and footer the table does not show up.

Scott Rosenbaum said...

Rocky,

I am not seeing any of the ODA statements in the log. Would you mind moving this discussion to either stackoverflow.com or the BIRT newsgroup?

Tracking something like this in the comments of the blog is not idea.

scott