Installation Guides › WebSphere 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.
   • 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:
   • Windows: report_server_home/common/3.5/java/lib
   • UNIX: /opt/CA/SharedComponents/CommonReporting/bobje/java/lib
3. Open the CRConfig.xml file, which is in the following location:
   • Windows: report_server_home/common/3.5/java
   • UNIX: /opt/CA/SharedComponents/CommonReporting/bobje/java/
4. Add the location of the jdbc JAR files to the Classpath. For example, if you are using an MS SQL database, your Classpath would appear as follows:
   • Windows: <Classpath>report_server_home\common\3.5\java\lib\sqljdbc.jar;…</Classpath>
   • UNIX: <Classpath>${BOBJEDIR}/java/lib/sqljdbc.jar:${BOBJEDIR}/java/lib/ojdbc14.jar:…</Classpath>
5. Save the file.
6. On Windows, restart the Report Server as follows:
   1. Go to Start, Program Files, CA, Report Server, Central Configuration Manager.

      The Central Configuration Manager opens.

   2. Select all services and click Restart.
7. On UNIX, restart the Report Server by using these commands:

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