It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,542

question asked: Sep 30 '11, 1:05 p.m.
question was seen: 3,856 times
last updated: Sep 30 '11, 1:05 p.m.

Related questions

FAQ - How this Forum works

RTC report with data from external source

0
Jorge Diaz (866●42●34) | 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

Most liked answers|Newest answers ↓|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | 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.
0
permanent link
Ben Fortuna (50●3●5) | 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
0
permanent link
Ben Fortuna (50●3●5) | 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

Your answer

Register or to post your answer.