Skip to Content
1

Logon Error: oracle.jdbc.OracleDriver

May 26, 2017 at 10:17 AM

127

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ibrahima Baradji Jun 29, 2017 at 10:38 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman 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

Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
May 26, 2017 at 07:57 PM
0

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.
    Share
    10 |10000 characters needed characters left characters exceeded