Extracting the Java runtime files for the ClearQuest Reporting Driver

The Java archive files that comprise the ClearQuest Reporting Driver are included as part of an Eclipse plug-in archive named com.ibm.rational.clearquest.jdbc_7.1000.0.timestamp.jar. This topic describes how to extract the .jar files for the ClearQuest Reporting Driver into a directory that is accessible by Crystal Reports.

About this task

Attention: You must have the Rational ClearQuest Client installed on your system to complete the tasks in this topic.
The following variables are used in path names in this topic:
CQReportDriver-dir
Directory where the ClearQuest Reporting Driver runtime files are extracted
timestamp
Time stamp associated with the build of the .jar file
%RATIONAL_COMMON%
Directory where Rational common files are installed
%CLEARQUEST_HOME%
Directory where Rational ClearQuest is installed

Procedure

To extract the .jar files for the ClearQuest Reporting Driver:

  1. Open a command prompt window.
  2. Create a directory in which to store the ClearQuest Reporting Driver runtime files:
    mkdir CQReportDriver-dir
  3. Navigate to the new directory:
    cd CQReportDriver-dir
  4. Extract the ClearQuest Reporting Driver archive files into the new directory.
    unzip "%CLEARQUEST_HOME%\cqecUpdateSite\plugins\com.ibm.rational.clearquest.jdbc_7.1000.0.timestamp.jar" cqjdbc.jar
    copy "%CLEARQUEST_HOME%\cqjni.jar" .
    copy "%CLEARQUEST_HOME%\stpcq.jar" .
    copy "%RATIONAL_COMMON%\*.jar" .
    You should see command output similar to the following:
    C:\CQReportDriver-dir>unzip "C:\Program Files\IBM\RationalSDLC\ClearQuest\cqecUpdateSite\plugins\com.ibm.rational.clearquest.jdbc_7.1000.0.v200810012104.jar" cqjdbc
    .jar
    Archive: C:/Program Files/IBM/RationalSDLC/ClearQuest/cqecUpdateSite/plugins/com.ibm.rational.clearquest.jdbc_7.1000.0.v200810012104.jar
    inflating: cqjdbc.jar
    
    C:\CQReportDriver-dir>copy "c:\Program Files\ibm\RationalSDLC\ClearQuest\cqjni.jar"
    .
    1 file(s) copied.
    
    C:\CQReportDriver-dir>copy "c:\Program Files\ibm\RationalSDLC\ClearQuest\stpcq.jar"
    .
    1 file(s) copied.
    
    C:\CQReportDriver-dir>copy "c:\Program Files\ibm\RationalSDLC\common\*.jar" .
    c:\Program Files\ibm\RationalSDLC\common\improdinfojni.jar
    c:\Program Files\ibm\RationalSDLC\common\stpcmmn.jar
    c:\Program Files\ibm\RationalSDLC\common\stpwvcm.jar
    3 file(s) copied.
    
    C:\CQReportDriver-dir> 

Feedback