It's all about the answers!

Ask a question

RTC report with data from external source


Jorge Diaz (8664434) | asked Sep 30 '11, 1:05 p.m.
JAZZ DEVELOPER
Hello,

we have been creating a BIRT report that get cross information of RTC repostiory info and an external DB repository info. It works OK in BIRT but when we try to upload the template and create a report with it we get an error that it can't connect to the DB:


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:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
Cannot load JDBC Driver class: com.ibm.db2.jcc.DB2Driver.
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1215)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1179)
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:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)


Has anybody knows how to make BIRT embeded engine locate the DB2 driver files?

Thanks!

Regards,

Jorge.

3 answers



permanent link
Ben Fortuna (5035) | answered May 06 '12, 8:46 p.m.
I got this to work by copying the BIRT plugin folder from my team concert (eclipse) client. Note that I had to manually edit the eclipse config.ini to add the bundle, and delete the cached bundles from the Websphere temp directory.

Feels like a particularly hacky approach to add the functionality, but I haven't seen any instructions as to a better way..


Is this supported in RTC 2? Where should the drivers be added (I don't see the BIRT plugin folder under eclipse/plugins)?

Many thanks.

regards,
ben

You need to add your JDBC drivers to the drivers/ folder in the org.eclipse.birt.report.data.oda.jdbc plug-in directory on the server. This may exist in multiple locations, so be sure to add it to all of them for completeness. Also if you're using tomcat you'll probably need to delete the work directory before starting the server again.

james
RTC Reports Team Lead

permanent link
Ben Fortuna (5035) | answered May 03 '12, 8:21 p.m.
Is this supported in RTC 2? Where should the drivers be added (I don't see the BIRT plugin folder under eclipse/plugins)?

Many thanks.

regards,
ben

You need to add your JDBC drivers to the drivers/ folder in the org.eclipse.birt.report.data.oda.jdbc plug-in directory on the server. This may exist in multiple locations, so be sure to add it to all of them for completeness. Also if you're using tomcat you'll probably need to delete the work directory before starting the server again.

james
RTC Reports Team Lead

permanent link
James Moody (3.3k24) | answered Oct 04 '11, 3:46 p.m.
JAZZ DEVELOPER
You need to add your JDBC drivers to the drivers/ folder in the org.eclipse.birt.report.data.oda.jdbc plug-in directory on the server. This may exist in multiple locations, so be sure to add it to all of them for completeness. Also if you're using tomcat you'll probably need to delete the work directory before starting the server again.

james
RTC Reports Team Lead

Hello,

we have been creating a BIRT report that get cross information of RTC repostiory info and an external DB repository info. It works OK in BIRT but when we try to upload the template and create a report with it we get an error that it can't connect to the DB:


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:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
Cannot load JDBC Driver class: com.ibm.db2.jcc.DB2Driver.
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1215)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1179)
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:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)


Has anybody knows how to make BIRT embeded engine locate the DB2 driver files?

Thanks!

Regards,

Jorge.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.