Skip to Content
author's profile photo
Former Member

How do I deploy the SQLServer 2000 JDBC Driver?

Hi all,

I created a datasource through the visual admin, added the three jar files associated with the MS SQLServer 2000 jdbc driver to the datasource, saved, and then bounce the J2EE server.

In the Integration Directory I configured the driver to

be <b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>.

When calling the JDBC Adapter, I get the following error:

com.sap.aii.af.ra.ms.api.DeliveryException: JDBC Adapter Receiver Channel jdbcSCADA: Configuration not initialized due to Loading jdbc <b>driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver'</b> failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver 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.guid library:com.sap.tc.Logging library:jms Resources: /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

As you can see in the error, the jdbc driver is trying to load the SQLServerDriver class but can't find it. Is there anything besides adding a datasource I need to do for the JDBC driver to find the SQLServerDriver class?

Regards,

--jtb

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Dec 17, 2004 at 09:20 AM

    Hi,

    Did you deploy the driver classes to the J2EE Engine prior to defining the datasource? Refer to this page in the J2EE Engine 6.40 documentation to see can you can do this: http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

    Then you define and configure the datasource in the visual admin as described here: http://help.sap.com/saphelp_nw04/helpdata/en/ab/082484173ae045ab8dad8a41d33da3/frameset.htm

    (just giving this link as a reference if you have problems in configuring the datasource).

    Hope that helps!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi James,

      You liked the answer, but did you forget to give points?

      See: /people/mark.finnern/blog/2004/08/10/spread-the-love for directions.

      Click on the Yellow Star icon in each reply.

      You can give:

      1 - 10 pointer (solves problem, marks as answered)

      2 - 6 pointers (very helpful)

      Lots of 2 pointers (helpful)

      This time I gave some points out for you, but you can increase them.

      Cheers,

      Linda (and Mark Finnern)