Upgrade Guide › JBoss Version › Report Server Upgrade › Copy the JDBC JAR Files

Copy the JDBC JAR Files

Follow these steps:

1. Navigate to the jdbcdrivers folder where the CA IdentityMinder Admin toolkit is installed. The default location is as follows:
   • Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\lib\jdbcdrivers
   • UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools/lib/jdbcdrivers
2. Copy ojdbc6.jar (for Oracle) or sqljdbc.jar (for SQL Server) to the following location:
   • Windows: CA\SC\CommonReporting3\common\4.0\java\lib
   • UNIX: /opt/CA/SharedComponents/CommonReporting3/bobje/java/lib
3. Open the CRConfig.xml file, found in the following location:
   • Windows: CA\SC\CommonReporting3\common\4.0\java
   • UNIX: /opt/CA/SharedComponents/CommonReporting3/bobje/java
4. Add the location of the JDBC JAR files to the Classpath. For example:
   • Windows: <Classpath>report_server_home\common\4.0\java\lib\sqljdbc.jar; report_server_home\ common\4.0\java\lib\ojdbc14.jar …</Classpath>
   • UNIX: <Classpath>${BOBJEDIR}/java/lib/sqljdbc.jar:${BOBJEDIR}/java/lib/ojdbc14.jar:…</Classpath>
5. Save the file.
6. Restart the Report Server as follows:
   • For Windows, do the following:
     1. Go to Start, Program Files, BusinessObjects XI version, BusinessObjects Enterprise, Central Configuration Manager.

        The Central Configuration Manager opens.

     2. Select all services and click Restart.
   • For UNIX, do the following:

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