JDBC Receiver Adapter Error with SAPClassNotFoundException

[Former Member]

HI Friends,

I have configured the JDBC Receiver Adapter with parameters as

Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@10.15.96.29:1525:RMOSDB

XI 700, Oracle DB 10.2

I have installed JDBC driver for Oracle as guide “How Install and Configure External Drivers for the JDBC & JMS Adapters.pdf”. I can see file ojdbc14.jar at D:\usr\sap\<SID>\DVEBMGSNN\j2ee\cluster\server0\bin\ext\com.sap.aii.af.jmsproviderlib.

But I’m still getting an error SAPClassNotFoundException as following:

#XI AF com.sap.aii.adapter.jdbc.XI2JDBC@1497c21##0#0#Error#1#com.sap.aii.adapter.jdbc.XI2JDBC#Plain###Accessing database connection 'jdbc:oracle:thin:@10.15.96.29:1525:RMOSDB' failed: com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@10.15.96.29:1525:RMOSDB': SAPClassNotFoundException: oracle.jdbc.driver.Oracledriver#

#XI AF com.sap.aii.adapter.jdbc.XI2JDBC@1497c21##0#0#Error#1#com.sap.aii.adapter.jdbc.XI2JDBC#Plain###JDBC_ERR_207#

#Error#1#com.sap.aii.adapter.jdbc.XI2JDBC#Plain###Accessing database connection 'jdbc:oracle:thin:@10.15.96.29:1525:RMOSDB' failed: com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@10.15.96.29:1525:RMOSDB': SAPClassNotFoundException: oracle.jdbc.driver.Oracledriver#

I tried to install JDBC driver again but it was not solve this problem.

Please suggest!

Regards,

Cuong

[Former Member · Accepted solution]

Hi

Check whether you have installed the correct drivers .

Also whether the drivers have been installed correctly.

The files are finally deployed in the file system path: D:\usr\sap\XR3\DVEBMGS00\j2ee\cluster\server0\bin\ext\

Thanks

[Former Member]

HI Cuong,

It seems something wrong with the installation of JDBC driver or in the config parameters for Adapter.

Not sure if driver is case sensitive.

But from the log it shows "oracle.jdbc.driver.Oracledriver".

Try putting "oracle.jdbc.driver.OracleDriver".

regards,

Pinkle

[Former Member]

Hi Pinkle.

You are right. Driver is case sensitive

I put 'oracle.jdbc.driver.Oracle<u>D</u>river' then it's work.

Thank you everybody!.

Cuong

[former_member614185]

Hi,

The Following JAR files are required to use the DB2 JDBC Universal driver

1. Db2jcc.jar

2. Db2jcc_license_c.jar

Check whether you have deployed these drivers.