Skip to Content
avatar image
Former Member

Logon Error: oracle.jdbc.OracleDriver

Hi,

I am using Crystal Report for Enterprise.

When I create a connection to oracle database, I had the following error :

Logon Error: oracle.jdbc.OracleDriver

May be the oracle database is not correctly configured.

How can I configure the oracle driver for Crystal Report for Enterprise.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 29, 2017 at 10:38 AM

    Hi all,

    Excuse me for the late response.

    In the client side I have only installed SAP Crystal Reports for Enterprise 4.1

    How can I configure it to make it work.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • May 26, 2017 at 11:26 AM
    -1

    Any particular reason why you want to use oracle.jdbc.OracleDriver

    I find that Crystal works best with either Oracle Native or OLEDB

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • May 26, 2017 at 07:57 PM

    Have you seen this:

    https://apps.support.sap.com/sap/support/knowledge/public/en/2169341

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

    Symptom

    • Error: Java Class not found in classpath : oracle.jdbc.OracleDriver
    • Error when attempting to create a report off a Universe.
    • When attempting to connect to a Universe based off an Oracle data source using a JDBC connection, Crystal Reports for Enterprise fails with the error:
      "Java Class not found in classpath : oracle.jdbc.OracleDriver"


    Environment

    • SAP Crystal Reports for Enterprise 4.1
    • SAP Crystal Reports for Enteprrise 4.2
    • SAP BusinessObjects Business Intelligence Platform 4.1
    • SAP BusinessObjects Business Intelligence Platform 4.2
    • Oracle
    • 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. Copy the driver in the following folder:

        <SAP BI Installation Directrory>\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc
      3. Open the file: jdbc.sbo, from the directory

        <SAP BI Installation Directrory>\sap_bobj\enterprise_xi40\dataAccess\connectionServer\jdbc
      4. Add the required .jar file details to the ClassPath area.

        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_PATHfor 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 the SAP BusinessObjects BI servers to load these environment variables.
    Add comment
    10|10000 characters needed characters exceeded