Oracle driver and JDBC adapter

[Former Member]

Hi,

I need to use a JDBC adapter to access an Oracle Database.

As I have to specify a "JDBC Driver" information in the communication channel, I wonder which one to choose and whether there is something to install somewhere.

Regards

Yann

[Former Member · Accepted solution]

Hi

For the installation, look at this doc.

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

Hope, you will have more luck than us!

Mickael

[Former Member · Accepted solution]

Hi,

Use the installation doc, to install the drivers(jar files).

For MS-SQL the jar files are

1.msbase.jar

2.mssqlserver.jar

3.msutil.jar

For Oracle

1.ojdbc14.jar

Send me your mail id. I can send you the driver files for MS-SQL.

Regards,

Jai Shankar.

[Former Member · Accepted solution]

Hi,

This link is better. Last version of doc "Installation guide" + tool to be used

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b38...

I hope this help you

Mickael

[Former Member · Accepted solution]

Hi Jai,

Thank you for you offer, but I'm only trying to access Oracle database, so I needn't MS-SQL drivers at the moment. But I'll keep it in mind.

Thanks anyway.

Yann

[Former Member · Accepted solution]

Hi guys,

I've sent the documentation you gave me the links for to my XI administrator for them to check if any driver has been installed.

Until now, I've used classes12.jar with my java programs. Is ojdbc.jar better?

Thanks

Yann

[bhavesh_kantilal · Accepted solution]

Hi,

From note : 831162,

<i>Oracle JDBC Driver (classes12.zip / classes12.jar) Deadlocks

Q: I have deployed the Oracle classes12.zip / classes12.jar JDBC driver as per the instructions in the XI Configuration Guide.

Unfortunately, I frequently notice hanging database connections. A thread dump taken according to the instructions in note 710154 shows one or more blocking JDBC Sender/Reciver threads and optionally that the JVM has detected a deadlock.

A: <b>The Oracle classes12.zip / classes12.jar driver is compatible with JDK 1.2 and 1.3 only, but not with JDK 1.4. Upgrade to a current version of the driver (ojdbc14.jar). For details, refer to note 941317.</b>

Make sure that you remove classes12.zip / classes12.jar from aii_af_jmsproviderlib.sda prior to adding the new driver as per the instructions in the answer to question #1 above as you will get a class name collision otherwise (all JARs from aii_af_jmsproviderlib.sda are loaded into the same class loader and the driver class name of both driver versions is the same).

Before deploying the updated driver, ensure that the new version is still compatible with your Oracle database server release. For details, refer to the release notes provided by Oracle.</i>

Regards,

Bhavesh

[Former Member]

Hi Yann,

the JDBC driver has to be deployed!

Regards Mario

[bhavesh_kantilal]

Hi,

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

To install oracle driver, just check this link,

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

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

The details that have to be entered while adapter configuration,

URL : <b>jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)></b>

Driver: <b>oracle.jdbc.driver.OracleDriver</b>

Regards,

Bhavesh