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

XI Error in configuiring external JDBC drivers for Sql server

Hi,

We tried configuring external JDBC driver as per the configuration guide

11.1.1.2 For the JDBC Driver and the JMS Driver Add the driver to archive aii_af_jmsproviderlib.sda with the help of a zip program.

Proceed as follows: ...

1. Modify the file provider.xml from aii_af_jmsproviderlib.sda. To do this, extract provider.xml using a zip program and edit it as follows:

a. Add the line <jar-name>driver-jar</jar-name> to each jar in the <jars> section.

If you want to install the SAP DB JDBC driver and the SonicMQ JMS driver,

this section looks like this:

<jars> <jar-name>sapdbc.jar</jar-name>

<jar-name>client.jar</jar-name> </jars>

b. Return the changed provider.xml to the archive. Make sure that the original directory server\ is retained under Path in the zip archive (check for the last Path entry).

2. Add all jars (without path information) that you have defined in provider.xml to aii_af_jmsproviderlib.sda.

3. Use the SDM to deploy aii_af_jmsproviderlib.sda in standalone (offline) mode. If the empty archive was already deployed during installation, then in step 1 of the deployment choose Update deployed SDAs/SCAs that have any version. Otherwise the subsequent deployment will be terminated with the message Already been deployed. (For more information about the deployment procedure, see the SDM documentation.)

4. Restart the J2EE Server. The drivers are now known to the JMS adapter or JDBC adapter, and can be used as described.

But it doesnt seems to be working, we are getting a error as shown in the screen shot...

In adapter monitor

the error is as follows

"

<b>NAME TEXT

CC_JDBC_SND Sender Adapter V0915 fro party '', service 'BSR_JDBC':

Configured at 13:04;25 2006-07-31

processing error: accessing database connection 'jdbc:microsoft:sqlserver://

additional information : JDBC driver 'com.microsoft.jdbc.sqlserver.SQLserverDr

Available JDBC drivers

No deployed JDBC drivers found "</b>

Also the status is in red color

Kindly help us

Thanks

Gopalakrishnan M

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Aug 01, 2006 at 07:18 AM

    Hai Caritor,

    Have followed this Installation guide...

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

    Go through each sep once and definitely it should work...

    Look at this Thread which will be helpfull to u...

    JDBC Adapter - Driver Problem

    Problem at JDBC driver installation

    Thanks and regards,

    Sridhar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 10:24 AM

    Hi,

    Thanks for your replies..

    I followed the document and deployed the .sda with the mentioned jar files .

    but this time it shows the following error

    Sender Adapter v0915 for Party '', Service 'BSR_JDBC':

    Configured at 15:33:35 2006-08-01

    Processing Error: Loading jdbc driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

    -


    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.guid

    library:com.sap.tc.Logging

    library:jms

    Resources:

    D:\usr\sap\XID\DVEBMGS00\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

    Can you please help us

    Thanks

    Gopalakrishnan M

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sudheer,

      I have seen that you did some sonicmq integration in the past, i am facing some problems getting it up and working.

      Followed the next steps,

      retrieved jar,file from sonic sonic_Client.jar followed the procedure netweaver 2004's using drivertool.bat deployed the jar's.

      At this moment in the RWB communication channel monitor i receive..

      Error during channel initialization; exception trace: javax.jms.JMSException: Unexpected exception during connect

      at progress.message.jimpl.JMSExceptionUtil.createJMSException(Unknown Source)

      at progress.message.jimpl.Connection.(Unknown Source)

      at progress.message.jimpl.QueueConnection.(Unknown Source)

      ...

      [154] progress.message.client.ENetworkFailure: Unexpected exception during connect

      at progress.message.zclient.Connection.connectWithRecoveryOpt(Unknown Source)

      at progress.message.zclient.ReconnectHelper.connectAndChaseSingleFailoverRedirect(Unknown Source)

      ...

  • Posted on Aug 01, 2006 at 07:20 AM

    Hi,

    The driver deployment has some mistake in it and that is why the error.

    JDBC Adapter will display a list of all deployed JDBC drivers in the Drivers Available in the log of the JDBC adapter if the deplyment is succesful.

    Suggest to redeploy by following every step of this document,

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

    Regards,

    Bhavesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You can check in the following path if the drivers are installed correctly:

      \usr\sap\<SID>\DVEBMGS<Instance Number>\j2ee\cluster\server0\bin\ext\com.sap.aii.af.jmsproviderlib

      Regards

      vijaya

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 10:39 AM

    HI All...

    Thats a wonderfull support...it worked as per all your guidance

    Thanks

    Gopalakrishnan M

    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.