Logon Error: oracle.jdbc.OracleDriver

[Former Member]

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.

[Former Member]

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

[vitaly_izmaylov]

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.

[Former Member]

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

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

Ian