Enabling the ClearQuest Reporting Driver

The CRConfig.xml file contains configuration information that is used by Crystal Reports. You must update this file to enable the ClearQuest Reporting Driver.

Before you begin

The following environment variable is used in path names in this topic:
%RATIONAL_COMMON%
Directory where Rational common files are installed
Before performing the steps in this topic, create a backup copy of the CRConfig.xml file. In Crystal Reports version 11 release 2, CRConfig.xml is located in the following directory:
C:\Program Files\Business Objects\Common\3.5\java

Procedure

To enable the ClearQuest Reporting Driver:

  1. Using a text editor, open the CRConfig.xml file. In the DataDriverCommon element, update the ClassPath element to include the fully qualified path for each .jar file that is required by the ClearQuest Reporting Driver. A separate entry is required for each .jar file.
    drive:\CQReportsDriver\stpwvcm.jar;drive:\CQReportsDriver\stpcq.jar;drive:\CQReportsDriver\stpcmmn.jar;drive:\CQReportsDriver\cqjdbc.jar;
  2. Because ClearQuest requires Java 5.0, which is included as part of the product installation, you must replace the following line:
    <JavaDir>C:\Program Files\Business Objects\j2sdk1.4.2_08\bin</JavaDir>
    with this line:
    <JavaDir>drive:\%RATIONAL_COMMON%\Java5.0\jre\bin</JavaDir>
  3. (Optional) In the JDBC element, customize the settings to describe the ClearQuest JDBC driver. This step is useful if you want the ClearQuest Reporting Driver settings to be saved as the default JDBC driver.
    <JDBC>
    		<CacheRowSetSize>100</CacheRowSetSize>
    		<JDBCURL>jdbc:cq:dataSet/database</JDBCURL>
    		<JDBCClassName>com.ibm.rational.clearquest.jdbc.CQDriver</JDBCClassName>
    		<JDBCUserName>user</JDBCUserName>
    		<JNDIURL><JDBCIURL>
    		<JNDIConnectionFactory></JNDIConnectionFactory>
    		<JNDIInitContext></JNDIInitContext>
     		<JNDIUserName>weblogic<JNDIUserName>
     		<GenericJDBCDriver>
    			<Option>Yes</Option>
     			<DatabaseStructure>catalogs,tables</DatabaseStructure>
    			<StoredProcType>Standard</StoredProcType>
    			<LogonStyle>Standard</LogonStyle>
    		</GenericJDBCDriver>
    </JDBC>

Results

After you save the modifications to CRConfig.xml, the ClearQuest Reporting Driver is accessible as a Crystal Reports data source.

Feedback