IBM Support

Unable to load JDBC driver for BIRT report

Troubleshooting


Problem

Attempts to run a BIRT report results in error loading JDBC driver when using IBM Rational Team Concert (RTC).

Symptom

The reports will fail, or will report an error loading the JDBC drivers.

Cause

The BIRT reports will attempt to load the JDBC drivers are included on the server side under org.eclipse.birt.report.data.oda.jdbc /drivers folder. If the driver is not in that location, the reports will fail.

Resolving The Problem

The JDBC drivers should be added into the org.eclipse.birt.report.data.oda.jdbc*.jar in order to run the reports.

  1. Stop the Jazz service thats running.

  2. On your server, run a search for org.eclipse.birt.report.data.oda.jdbc*.jar.
    Th
    e search should provide three directories as the result. Be sure to take note of the JAR file owner and permissions.
    Example:
    <install_dir>/server/conf/jts/sites/update-site/plugins
    <install_dir>/server/conf/ccm/sites/update-site/plugins <install_dir>/server/conf/qm/sites/update-site/plugins

  3. Make a backup of the org.eclipse.birt.report.data.oda.jdbc*.jar files

  4. Unzip one of the org.eclipse.birt.report.data.oda.jdbc*.jar files.

  5. If the JAR file that you just unzipped still exists, delete it so you only have the unzipped directory of the JAR file.

  6. In the newly created directory org.eclipse.birt.report.data.oda.jdbc* you will find a subdirectory named "drivers", copy your jdbc drivers and licenses into this directory.
    Example:
    .../org.eclipse.birt.report.data.oda.jdbc*/drivers/db2jcc4.jar
    .../org.eclipse.birt.report.data.oda.jdbc*/drivers/db2jcc.jar
    .../org.eclipse.birt.report.data.oda.jdbc*/drivers/db2jcc_license_cisuz.jar
    .../org.eclipse.birt.report.data.oda.jdbc*/drivers/db2jcc_license_cu.jar

  7. JAR up the org.eclipse.birt.report.data.oda.jdbc* directory, be sure the JAR has the same name of the original JAR (including version number) that you unzipped.

  8. Set the appropriate owner and permissions on the new JAR file to match that of the original.

  9. Replace the remaining org.eclipse.birt.report.data.oda.jdbc*.jar files with the new org.eclipse.birt.report.data.oda.jdbc*.jar.

  10. If using IBM WebSphere application server, clear the temporary directories (../temp and ../wstemp).
    Example:
    /opt/ibm/WebSphere/was7/AppServer/profiles/jazz/temp
    /opt/ibm/WebSphere/was7/AppServer/profiles/jazz/wstemp

  11. Navigate to the ../server directory in your Jazz installation path.
    Example: <install_dir>/server

  12. Execute each of the repotools files using the "-clean -version" options.
    Example:
    ./repotools-ccm.sh -clean -version
    ./repotools-jts.sh -clean -version
    ./repotools-qm.sh -clean -version

  13. Restart Rational Team Concert.


The BIRT JDBC Data Source is not supported out of the box. You will need to patch the server as mentioned above and deploy the JDBC Driver jars to the BIRT drivers folder. If you require assistance in setting up the BIRT client to talk to a particular database, you will probably need to ask the question in the Eclipse BIRT forums.


Leverage the Jazz Community

Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Reports","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"3.0.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
16 June 2018

UID

swg21586908