2169341 - Error: Java Class not found in classpath : oracle.jdbc.OracleDriver in Crystal Reports for Enterprise when creating a universe connection using Oracle JDBC driver

Symptom

Error: Java Class not found in classpath : oracle.jdbc.OracleDriver  in Crystal Reports for Enterprise when creating a universe connection using Oracle JDBC driver.

Environment

• SAP BusinessObjects Business Intelligence Platform 4.x
• Crystal Reports for Enterprise 4.x
• Oracle JDBC connection
• Linux Operating System

Reproducing the Issue

1. Obtain the necessary JDBC driver software from the database vendor. (For Orcale: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html)
2. Put the Driver in the SAP BO Directory <Installation Directrory>\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc
3. Open jdbc.sbo file under  Directory <Installation Directrory>\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc.
4. Add the required .jar file details to the ClassPath area. 
5. The example below was entered in the jdbc.sbo file.

            <DataBase Active="Yes" Name="Oracle 12">
            <JDBCDriver>
                <Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
                <Parameter Name="URL Format">jdbc:oracle:thin:@//$DATASOURCE$/$DATABASE$</Parameter>
            </JDBCDriver>
            <Parameter Name="Extensions">oracle12,oracle,jdbc</Parameter>
            <Parameter Name="Escape Character">/</Parameter>
            <Parameter Name="Force Execute">Always</Parameter>
            <Parameter Name="Catalog Separator">.</Parameter>
                <Parameter Name="Driver Capabilities">Query,Procedures,Cancel</Parameter>
           </DataBase> 

  

    6.  Save and close the .sbo file.

    7.  Go to Crystal Reports for Enterprise and create a New Connection and refresh the report.

Cause

The LD_LIBRARY_PATH for Oracle is not defined in system environment variable.

Resolution

1. Execute below command to set the related environment variables
             export PATH=$PATH:<oracle jbdc folder path>/ojdbc6.jar
             export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<oracle jbdc folder path>/ojdbc6.jar
2. Restart BI servers to load these environment variables.

Keywords

Crystal Report for Enterprise, SAP Business Intelligence Platform 4.x, CR4E, LI_LIBRARY_PATH, PATH, oracle, JDBC

Header Data

Released On	19.05.2015 02:44:34
Release Status	Released to Customer
Component	BI-RA-CRE Crystal Reports for Enterprise
Priority	Normal
Category	Problem