Workaround for Integration gateway – Non SAP Backend issue

Some times when we are setting up and testing a Odata service using Integration Gateway we may see the following error “Cannot load JDBC driver class ‘com.microsoft.sqlserver.jdbc.SQLServerDriver'”. Here is a workaround to resolve the issue.

Follow the below steps.

Step 1 : Create a SMPRun.bat file with the following steps

  net stop SAPSMP3Service

  taskkill /IM java.exe

  del C:\SAP\MobilePlatform3\Server\work\org.eclipse.virgo.nano.deployer\staging\com.microsoft.sqlserver.jdbc_1.0.0.jar

  del C:\SAP\MobilePlatform3\Server\pickup\.state\com.microsoft.sqlserver.jdbc_1.0.0.deploy.ok

  net start SAPSMP3Service

  pause

Step 2 : Save the SMPRun.bat file

Step 3: Right click SMPRun.bat file and Run the same. This will delete the existing jar file from staging folder and “com.microsoft.sqlserver.jdbc_1.0.0.deploy.ok” file from the .state folder

Step 4: Now test your web service, That will work.

Note: If you use MySQL or Oracle Database pls remove the respective files instead of sqlserver files mentioned in the above steps.

Cheers