Installation Guide › Server Installation › Report Server › High-Availability: Identity Management Server 2 › Copy the JDBC JAR Files

Copy the JDBC JAR Files

Follow these steps:

1. Navigate to the jdbcdrivers folder where the Identity Management Server Admin toolkit is installed. The default location is as follows:

   /opt/ca/IdentityManager/IAM_Suite/Identity Manager/tools/lib/jdbcdrivers
   

2. Copy ojdbc14.jar (for Oracle) or sqljdbc.jar (for SQL Server) or postgresql-9.3-1101.jdbc3.jar (for PostgreSQL) to the following location:

   /opt/CA/SharedComponents/CommonReporting3/bobje/java/lib/external
   

   The ojdbc14.jar and the sqljdbc.jar files are in the following location:

   /opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/ReportServerTools/
   

   The postgresql-9.3-1101.jdbc3.jar is available at the following location:

   /opt/reports
   

3. Open the jdbc.sbo file in this directory:

   $CABI_HOME/bobje/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer/jdbc
   

4. If you are using an Oracle Database, add the path for the location of jar file under the section for Oracle 11.

   Replace this section:

   <JDBCDriver>
      <!--  Uncomment and edit the following lines
        to define java classes required by JDBC driver
   &lt;ClassPath&gt;
       &lt;Path&gt;your jar or class files directory&lt;/Path&gt;
   &lt;/ClassPath&gt;
    -->
           <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
          <Parameter Name="URL Format">jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
   </JDBCDriver>
   With this section
   <JDBCDriver>
           <ClassPath>
         <Path>/opt/CA/SharedComponents/CommonReporting3/bobje/java/lib/external/ojdbc14.jar</Path>
         	</ClassPath>
          <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
          <Parameter Name="URL Format">jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
   </JDBCDriver>
   

5. If you are using a PostgreSQL database, add the path for location of jar file under the section for PostgreSQL 8.

   Replace this section:

   <JDBCDriver>
     <!--  Uncomment and edit the following lines
        to define java classes required by JDBC driver
   &lt;ClassPath&gt;
       &lt;Path&gt;your jar or class files directory&lt;/Path&gt;
   &lt;/ClassPath&gt;
    -->
           <Parameter Name="JDBC Class">org.postgresql.Driver</Parameter>
           <Parameter Name="URL Format">jdbc:postgresql://$DATASOURCE$/$DATABASE$</Parameter>
   </JDBCDriver>
   With this section:
   <JDBCDriver>
           <ClassPath>
     	      <Path>/opt/CA/SharedComponents/CommonReporting3/bobje/java/lib/external/postgresql-9.3-1101.jdbc3.jar</Path>
           </ClassPath>
           <Parameter Name="JDBC Class">org.postgresql.Driver</Parameter>
           <Parameter Name="URL Format">jdbc:postgresql://$DATASOURCE$/$DATABASE$</Parameter>
         </JDBCDriver>
   

6. Save and close jdbc.sbo file.
7. Open the CRConfig.xml file, found in the following location:

   /opt/CA/SharedComponents/CommonReporting3/bobje/java
   

8. Add the location of the JDBC JAR files to the Classpath.
   • PostgreSQL - ${BOBJEDIR}/java/lib/external/postgresql-9.3-1101.jdbc3.jar
   • Oracle - ${BOBJEDIR}/java/lib/external/ojdbc14.jar

   For example:

   <Classpath>${BOBJEDIR}/java/lib/external/postgresql-9.3-1101.jdbc3.jar:${BOBJEDIR}/java/lib/sqljdbc.jar:${BOBJEDIR}/java/lib/ojdbc14.jar:…</Classpath>
   

9. Save the file.
10. Restart the Report Server as follows:

    cd /opt/CA/SharedComponents/CommonReporting3/bobje
    ./stopservers
    ./startservers