Skip to Content
author's profile photo Former Member
Former Member

JDBC ADAPTER ERROR IN SAP XI

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2005 at 06:56 PM

    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:

    jdbc-adapter-conect-to-oracle-database

    Thanks,

    Jeff

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2005 at 05:13 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.