DriverManagerException:SAPClassNotFoundException: oracle.jdbc.driver.Oracle

[Former Member]

Hi there,

I have a scenario Oracle 9i to File. I have the following configurations for Sender JDBC Adapter:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@efidw.efi.com:1521:student

I have the following JDBC adapter error:

ender Adapter v2108 for Party '', Service 'System_X_DEV':

Configured at 2006-03-24 12:47:38 PST

History:

- 2006-03-24 12:47:38 PST: Retry interval started. Length: 60.000 s

- 2006-03-24 12:47:38 PST: Error: Accessing database connection 'jdbc:oracle:thin:@efidw.efi.com:1521:student' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@efidw.efi.com:1521:student': SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

- 2006-03-24 12:47:38 PST: Processing started

Any help is appreciated.

Thanks.

Karma

[Former Member]

Karma, were you able to fix this issue?

[thorsten_nordholmsbirk]

Hi Karma,

It looks like the Oracle JDBC driver class is not accessible to the Adapter Framework. Are you certain the driver has been packaged correctly in the aii_af_jmsproviderlib.sda file and deployed to the server?

Regards,

Thorsten

[bhavesh_kantilal]

Hi,

To access any database fromm XI, using the JDBC adapter, the corresponding drivers have to be installed on the XI server.

To download drivers for Oracle DB,

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

If you want to install Oracle 9i,. OJDBC14.jar should be used. Just check this note 831162.

Also, check this PDF to install Drivers in XI,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Bhavesh