BIRT Report Engine w/ClearQuest reports - JDBC issue

I downloaded the BIRT runtime and I'm trying to use it to run some ClearQuest BIRT reports, but I'm getting JDBC Errors. The docs for the BIRT runtime state:

Configuring JDBC Drivers 
 
You must configure the engine to include any JDBC drivers that you need. 
 
To do this, copy the driver jar file to the ReportEngineInstall/birt-runtime-version/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_version/drivers Directory.

I've copied every JAR file that looks like it could be a JDBC driver to this directory, but clearly I haven't gotten the right file or combination of files in that directory yet. Here's the command I'm running and the error message:

C:WorkBIRTbirt-runtime-2_3_1ReportEngine>genReport.bat -f PDF -o C:WorkBIRTreport2.pdf C:WorkBIRTDefectAssignee.rptdesign 
 
C:WorkBIRTbirt-runtime-2_3_1ReportEngine>ECHO off 
 
Jan 25, 2009 11:07:24 PM org.eclipse.birt.data.engine.odaconsumer.Driver doGetDriverManifest 
 
SEVERE: Cannot process data source extension configuration. 
 
java.lang.IllegalArgumentException: com.ibm.rational.clearquest.oda.jdbc.dataSource 
 
at org.eclipse.datatools.connectivity.oda.util.manifest.ManifestExplorer.getExtensionManifest(ManifestExplorer.java:200) 
 
at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(Driver.java:147) 
 
at org.eclipse.birt.data.engine.odaconsumer.Driver.findDataSourceExtensionConfig(Driver.java:123) 
 
at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverExtensionConfig(Driver.java:78) 
 
at org.eclipse.birt.data.engine.odaconsumer.Driver.getExtensionConfig(Driver.java:60) 
 
at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverHelper(Driver.java:93) 
 
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:97) 
 
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:144) 
 
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:210) 
 
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:197) 
 
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209) 
 
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:386) 
 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:305) 
 
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498) 
 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189) 
 
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177) 
 
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143) 
 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:479) 
 
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:114) 
 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:248) 
 
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1736) 
 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77) 
 
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:42) 
 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45) 
 
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33) 
 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63) 
 
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:101) 
 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151) 
 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72) 
 
at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(ReportRunner.java:225) 
 
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:165) 
 
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:120) 
 
C:WorkBIRTbirt-runtime-2_3_1ReportEngine>

It's not stated anywhere in the docs, but given that the error involves Manifest files, is there a file I need to update to allow the BIRT engine to see the JDBC driver? 
 
Anyone out there seen this? 
 
Thanks in advance.... 
 
Fran Kemp 
<a href='mailto:' title='E-mail Link' class='bbc_email'>fdkemp@PraxisEng.com</a>

Find more posts tagged with

Comments

Virgil Dodson

Hi Fran, 
 
Are you using ClearQuest 7.1? If so, there is a ClearQuest ODA driver that provides access to the ClearQuest data. I've started creating a page with instructions for ClearQuest users who want to use the Actuate BIRT products. That page is a work in progress but lists the JAR files that are needed in order to access ClearQuest 7.1 data. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/wiki/Using_BIRT_and_Actuate_with_IBM_ClearQuest/'>Using BIRT and Actuate with IBM ClearQuest - BIRT Wiki - BIRT Exchange</a>

LizM

I'm reporting from a RequisitePro repository using BIRT via the Eclipse report builder and experienced similar issues when first setting up the datasource

I needed to install the JDBC driver for the particular database version that the ReqPro repository was using (SQL Server 2005 in this case)