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
thank you.
Thanks for sharing this!
Looking forward to more such workarounds