Installation Guides › JBoss Version › Report Server Installation › How to Install the Report Server › Copy the JDBC JAR Files

Copy the JDBC JAR Files

To copy the JDBC JAR files

1. Navigate to the jdbcdrivers folder on the CA Identity Manager media, as follows:
   • Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\lib\jdbcdrivers
   • UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/lib/jdbcdrivers
2. Copy ojdbc14.jar (for Oracle) or sqljdbc.jar (for SQL Server) to the following location:
   • For BusinessObjects XI R2 SP4
     • Windows: report_server_home/common/3.5/java/lib
     • UNIX: /opt/CA/SharedComponents/CommonReporting/bobje/java/lib
   • For BusinessObjects XI 3.0
     • Windows: CA\SC\CommonReporting3\common\4.0\java\lib
3. Open the CRConfig.xml file, found in the following location:
   • For BusinessObjects XI R2 SP4
     • Windows: report_server_home/common/3.5/java
     • UNIX: /opt/CA/SharedComponents/CommonReporting/bobje/java/
   • For BusinessObjects XI 3.0
     • Windows: CA\SC\CommonReporting3\common\4.0\java
4. Add the location of the JDBC JAR files to the Classpath. For example:
   • Windows:
     • BusinessObjects XI R2 SP4: <Classpath>report_server_home\common\3.5\java\lib\sqljdbc.jar; report_server_home\common\3.5\java\lib\ojdbc14.jar…</Classpath>
     • BusinessObjects XI 3.0: <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, CA, Report Server, Central Configuration Manager.

        The Central Configuration Manager opens.

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

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