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:

Depending on which database you are using, you will copy particular files:

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

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

2. If you are using an Oracle database, use the applicable step:
   1. If you are using an Oracle 11g database, add the path for the location of the 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>
      

   2. If you are using an Oracle 12c database, add the path for the location of the jar file under the section for Oracle 12c. It only is available for CABI 3.3 SP2.

      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/ojdbc5.jar</Path>
            	</ClassPath>
             <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
             <Parameter Name="URL Format">jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
      </JDBCDriver>
      

3. 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>
   

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

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

6. Add the location of the JDBC JAR files to the Classpath.
   • PostgreSQL - ${BOBJEDIR}/java/lib/external/postgresql-9.3-1101.jdbc3.jar
   • Oracle 11g - ${BOBJEDIR}/java/lib/external/ojdbc14.jar
   • Oracle 12c - ${BOBJEDIR}/java/lib/external/ojdbc5.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>
   

7. Save the file.
8. Restart the Report Server as follows:

   cd /opt/CA/SharedComponents/CommonReporting3/bobje
   ./stopservers
   source setup/env.sh
   ./startservers