JDBC Adapter Error - SAPClassNotFoundException: oracle.jdbc.driver.OracleDr

[Former Member]

Hi,

I am trying to implement JDBC to File scenario.

Trying to connect to Oracle Database. Oracle drivers are installed on XI server

JDBC Adapter parameters:

JDBC Driver - oracle.jdbc.driver.OracleDriver

Connection - jdbc:oracle:thin:@10.25.228.156:1521:databaseName=XE

Error which I can see in Communication Channel Monitoring is:

Error during database connection to the database URL 'jdbc:oracle:thin:@w4inpusyga6:1521:XE' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@w4inpusyga6:1521:XE': SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver'

All your inputs are welcome!

Thanks

Mugdha Kulkarni

[Former Member · Accepted solution]

Hi,

Befor doing JDBC connection Better ask Basis Guys to install JDBC drivers(OJDBC14.jar) in XI server.

follow this guide:

JDBC Driver Deployment Guide...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Regards,

Mahesh

[Former Member]

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 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\

Regards

Abhishek Agrahari

[former_member192079]

Hi

we are integrating XI with IBM DB2 database.

we have used 2 Jar files ( DB2jcc4.jar & DB2jcc.jar ).

but after deployment the jar file was deployed in different location, not in D:\usr\sap\XR3\DVEBMGS00\j2ee\cluster\server0\bin\ext\

trying many times this deployment, we manually copy/paste

our driver jar file to legitimate directory..

Now the error has change as .UnsupportedClassVersionError: com/ibm/db2/jcc/DB2Driver (Unsupported major.minor version 50.0)

Any one could through some light on it..

Regards,

Ashutosh

Edited by: ashutosh rawat on Dec 5, 2009 4:48 AM

[Former Member]

I am accessing Oracle database 10G

I have installed classes12.zip while installing drivers

[Former Member]

Check you firewall settings.

[Former Member]

Hi Mugdha,

Refer to the folowing threads,

[;

[;

[;

Award points if useful.

Regards,

Yashaswee