cancel
Showing results for 
Search instead for 
Did you mean: 

How do I deploy the SQLServer 2000 JDBC Driver?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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!

Former Member
0 Kudos

There is a document, "How to configure and install JDBC and JMS drivers" on the SDN XI web site. Just search the doucments for it. If you can't find it, leave your email address. We used this doc and haad no problems!

Chris

Former Member
0 Kudos

Thanks guys!

I found the howto guide and it worked great.

Regards,

--jtb

Former Member
0 Kudos

Don't forget the points

Former Member
0 Kudos

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)

Answers (0)