JDBC ADAPTER ERROR IN SAP XI

[Former Member]

Hi,

I am working in the following scenery: FILE->XI->JDBC.

I already accomplished all of the configurations in Integration Repository, Integration Directory and System Landscape. When it went to turn the scenery described above appears the following screen enclosed. We are using the database Oracle.

Error

-

---

Receiver Adapter v1718 for Party 'DATACENTER', Service 'CCD':

Configured at 10:38:06 2005-08-02

Initialization error: Loading jdbc driver 'oracle.jdbc.driver.OracleDriver' failed: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Found in negative cache

-

---

Loader Info -

---

ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]

Parent loader name: [Frame ClassLoader]

References:

service:com.sap.aii.af.cpa.svc

service:com.sap.aii.af.ms.svc

service:com.sap.aii.af.svc

service:com.sap.aii.adapter.xi.svc

library:com.sap.aii.af.lib

library:com.sap.aii.messaging.runtime

library:com.sap.xi.util.misc

common:service:iiop;service:naming;service:p4;service:ts

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:com.sap.security.core.ume.service;service:connector;service:dbpool;service:keystore;service:security;service:userstore

library:ejb20

library:sapxmltoolkit

library:com.sap.util.monitor.jarm

library:com.sap.guid

library:com.sap.tc.Logging

library:jms

Resources:

/usr/sap/XID/DVEBMGS14/j2ee/cluster/server0/bin/services/com.sap.aii.adapter.jdbc.svc/aii_adapter_jdbc_svc.jar

Loading model: {parent,local,references}

-

---

Available JDBC drivers:

No deployed JDBC Drivers found

-

---

This drive already default in database Oracle or should we download the drive and to install in the servant of the XI?

Does some note exist to be applied?

Which are the necessary steps to do the deployed of the drive?

Which are the steps to solve this problem?

[Former Member]

Hi Sergio,

U have to deploy the drivers for whatever DB u want to connect to.

U have to do the following :

1.Add all jars(drivers like msbase.jar,mssqlserver.jar,msutil.jar for MS SQL or classes12.zip for Oracle etc) to the archive aii_af_jmsproviderlib.sda, modify the provider.xml file and WinZip the .sda file again.

a)Copy the file: aii_af_jmsproviderlib.sda from the path ..\usr\sap\SID\DVEBMGS00\SDM\root\origin\sap.com\com.sap.aii.af.jmsproviderlib\SAP AG\3.0.20040112154003.0000. to any other drive on the server.

b)Unzip it. After Unzipping the archive there are 2 folders created under the provided directory

\META-INF

\server

c) Edit the file provider.xml

Add the vendor specific jar file names to the provider.xml file in between the tags <jars> …</jars> and Save it.

For you it will be

<jars>

<jar-name>msbase.jar</jar-name>

<jar-name>mssqlserver.jar</jar-name>

<jar-name>msutil.jar</jar-name>

<jar-name>classes12.zip</jar-name>

</jars>

d)Copy the specific driver files to the same dirctory where u have unzipped the .sda

e)Now ZIP the following files/folders from the drive/dirctory.

• Vendor driver files

• META-INF folder

• Server folder

The name of the zip file should be the same i.e aii_af_jmsproviderlib.sda

2.Deploy the archive aii_af_jmsproviderlib.sda on to the J2ee Engine using SDM tool.

U can also download the pdf of "How to Install and Configure External Drivers for JDBC and JMS Adapters " from the Popular Documents from th XI Homepage.

This will solve ur problem.

Regards

Sunita

[Former Member]

Hi Sunita,

The basis team accomplished all above of the steps that you put in the document and the same mistake continues. It didn't change anything.

What can be happening?

[Former Member]

hi Sergio,

Have you installed and configured the Oracle JDBC Driver? If not, do the following:

1. https://websmp101.sap-ag.de/nw-howtoguides

2. From the left frame, click on Exchange Infrastructure

3. Click on the 'How To Install and Configure External Drivers for JDBC & JMS' pdf

Additional you can take a look at this message thread for addition information:

Thanks,

Jeff