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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |