SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

[pr_srinivas]

Hi...Experts....

Requirement:

From our PI 7.1 System we have to connect to MS-SQL Server 2000 using JDBC.

Execution :

We have downloaded

Microsoft SQL Server JDBC Driver 3.0 ...and...Microsoft SQL Server JDBC Driver 2.0 ( We mean we tried both drivers)and deployed using JSPM in PI system

To deploy this ..We used & reviewed the following notes

Note 0000831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Note 0001138877 - PI 7.1 : How to Deploy External Drivers JDBC/JMS Adapters

Note 0000850116 - XI 3.0 / PI 7.0 JDBC Adapter: Type 2 JDBC Driver Deployment

Note 0001123333 - Redeploying same component with JSPM

Issue Observation Path :

in JSPM ...The deployment is successfull

But in

>Runtime Workbench NetWeaver Administrator

>>Component Monitoring

>>>Compnenet with status ..ALL...[DISPLAY]

>>>Adapter Engine

>>>>Communication Channel

We continuioulsy see the following error

ERROR :

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://101.197.135.118:1433;databaseName=LWV' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://101.197.135.118:1433;databaseName=LWV': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'

ERROR:

In this Juncture...We have 2 queires.

01. How to make the Deployed JDBC Driver avaialbiliy in the system.

02. Any other alternate way to make sure our self deployed JDBC well installed in system and can be used from PI Console.

Regards

PR

[Former Member]

Hello Srinivas,

Could you please make sure we have the right drivers installed as per the OSS note 639702.

We should deploy right sqljdbc.jar file.

Also check if you have the right version of JVM.

Also check the last part of the OSS note 639702 for importing new driver.

Regards,

Imran

[pr_srinivas]

Imran ...Thank U Very much...

We could able to move forward.

as in Java Instance :

In directory : DRIVE:\usr\sap\<SID>\DVEBMGS<NN>j2ee\cluster

We can see : instance.properties

We copied the 3 files (01) sqljdbc4.jar, (02) msutil.jar, (03) msbase.jar into a directory like

DRIVE:\usr\sap\<SID>\DVEBMGS<NN>j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\

In the "configtool" we configured these 3 jar files in class path like :

DRIVE:\usr\sap\<SID>\DVEBMGS<NN>j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\sqljdbc4.jar;

DRIVE:\usr\sap\<SID>\DVEBMGS<NN>j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\msutil.jar;

DRIVE:\usr\sap\<SID>\DVEBMGS<NN>j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\msbase.jar

and restarted the Instance, which in turn updated the instance.properties

and we could see the errors stopped coming in the "XI Runtime WorkBench - Component Monitoring"

We could see as

>>>Processing started

>>>Processing finished successfully

>>>Polling interval started. Length: 60.0 seconds

So we understood, the connection could db server and we conformed we moved a head on the issue

Summarized Notes List :

Note 0000831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Note 0001138877 - PI 7.1 : How to Deploy External Drivers JDBC/JMS Adapters

Note 0000850116 - XI 3.0 / PI 7.0 JDBC Adapter: Type 2 JDBC Driver Deployment

Note 0001123333 - Redeploying same component with JSPM

Note 0000639702 - JDBC Driver for Microsoft SQL Server

Rgds

PR

[Former Member]

Hi Srini,

Glad that you are able to move forward. I believe driver (sda file) was not properly deployed through JSPM. Whenever an external driver is deployed for Jdbc/Jms adapter it is advisable to check your updated/installed jars at /usr/sap/<SID>/DVEBMGS<SYSNO>//j2ee/cluster/server0/bin/ext/com.sap.aii.adapter.lib.

Thanks

Shekhar

[Former Member]

Hi,

AFAIK, the jdbc drivers need to be in the kernel dir in usr\sap\<SID>\SYS\exe\run\drivers folder. Place the jdbc file in this folder and restart your system.

Hope it helps..

Rgds,

Soujanya