SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver issue

[former_member188885]

Hi Experts,

I am facing an problem with the connetivity between XI 3.0 server and Oracle DB.

XI 3.0 is having a Oracle driver version 10.2.0.4. The Oracle Database Version that the third party is using is of version 11.2.0.3.

When i tried to create the JDBC CC, it is giving the following error:

SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

There are no other JDBC channels used in the XI server at present, but it is connected to other SAP systems which have a DB version of 10.

Is it possible to upgrade the Driver version of XI from 10 to 11? Will it cause any issues and problems?

After upgradation of the driver will it be compatible with the DB version 10 also?

Please suggest!

Thanks and Regards,

Lavanya

[baskar_gopalakrishnan2 · Accepted solution]

>The Oracle Database Version that the third party is using is of version 11.2.0.3.

Please refer below link. The jdbc drivers that support  database version 11.2.0.3  will need JDK 1.5 and above to run.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

whereas your XI 3.0 uses jdk 1.4. So I'm thinking you might get version incompatible error if you upgrade the jdbc driver for the db version 11.2.0.3.

Is it possible to upgrade the Driver version of XI from 10 to 11?

Yes

Will it cause any issues and problems?

Yes.

After upgradation of the driver will it be compatible with the DB version 10 also?

IMO, this might cause problem.  Please install and let us know.

Suggestion: The below link is for the database version 10.2.0.4

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html

You might want to choose jdbc driver jar that supports both 1.4 and 1.5 and see if that helps.

[former_member188885]

Thank you for the reply.

We have deployed Jar files that are compatible with the current JDK version and the problem is solved now.

[MichalKrawczyk]

Hi,

>>>>Is it possible to upgrade the Driver version of XI from 10 to 11? Will it cause any issues and problems?

yes, no

yes - you can upgrade the driver

no - it will not cause any issues

>>>After upgradation of the driver will it be compatible with the DB version 10 also?

yes

>>>SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

that probably means that the driver was not deployed correctly on PI anyway

so just deploy the latest version as per OSS note and guides on SDN for driver deployment on PI

Regards,

Michal Krawczyk

[former_member188885]

Thank you for the reply Michal

[MichalKrawczyk]

Hi,

do you need any more info ?

Regards,

Michal Krawczyk

[MichalKrawczyk]

Hi,

Baskar might be right for 3.0 version (didn't notice you're running the oldest one)

so you might expect some issues with jdk as he mentioned,

good notice Baskar,

Regards,

Michal Krawczyk

[baskar_gopalakrishnan2]

Thanks Master!!!