Cannot load JDBC driver class while Odata Service

[Former Member]

Dear All , I am trying to run Odata Service with MS SQL Server database as backend with customer table . But I am getting error like Cannot load JDBC driver class ' com.microsoft.sqlserver.jdbc.SQLServerDriver' . Can you please suggest how to over come with this situation . For information i have attached all step by step screen steps . Thanks & Regards ,   Kunal Varaiya

[Jitendra_Kansal]

Hi Kunal,

I will look at

1. ".state" folder OK status for deployed jar file (make sure it should be OSGi enabled jar file)

     E:\SAP\MobilePlatform3\Server\pickup\.state

Can you also look at this blog http://scn.sap.com/community/developer-center/mobility-platform/blog/2014/08/08/workaround-for-integ...

Rgrds,

JK

[Former Member]

Dear Jitendra , I have tried both ways but still i am getting below error . Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' I could not figure it out how to solve this one . So , still i could not explore Backend data from Odata . Can you suggest me ? Thanks & Regards , Kunal Varaiya

[Former Member]

Dear Jitendra , I have mention error logs below : ___________________________________________________________________________ | 2014 08 12 11:46:16#+0400#ERROR#com.sap.gateway.core.ip.runtime.GatewayIPODataProcessor##anonymous#http-bio-8081-exec-6###readEntitySet() failed: service = sap/ODataModel, entity set = Customers, content type = application/xml;charset=utf-8, message = org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' | 2014 08 12 11:46:16#+0400#ERROR#com.sap.gateway.core.ip.odata.ODataErrorCallbackImpl##anonymous#http-bio-8081-exec-6###handleError(): failed to serve request for URI http://Kunal -jit:8081/gateway/odata/sap/ODataModel;v=1/Customers, message = Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' | __________________________________________________________________________ Can you put your suggestion on it ? Thanks & Regards , Kunal Varaiya

[Jitendra_Kansal]

Maybe can assist you on this.

[bjoernw]

Dear Kunal,

did you try to follow this blog?

Also, if you cannot even open your DB in SquirrelSQL, maybe something is wrong with your DB or the login data?

Kind regards

Björn

[Former Member]

Dear Bjoern Woppmann , I followed all steps provided by you many times .at the same time i can open my DB in SquirrelSQL . for information i have attached screen shot . But when try with browser then i am getting error like ____________________________________________________________________________ | 2014 08 12 11:46:16#+0400#ERROR#com.sap.gateway.core.ip.runtime.GatewayIPODataProcessor##anonymous#http-bio-8081-exec-6###readEntitySet() failed: service = sap/ODataModel, entity set = Customers, content type = application/xml;charset=utf-8, message = org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' | 2014 08 12 11:46:16#+0400#ERROR#com.sap.gateway.core.ip.odata.ODataErrorCallbackImpl##anonymous#http-bio-8081-exec-6###handleError(): failed to serve request for URI http://Kunal -jit:8081/gateway/odata/sap/ODataModel;v=1/Customers, message = Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' | _________________________________________________________________________ Thanks & Regards, Kunal Varaiya

[Former Member]

Dear All , I troubleshooted with Sql Squirrel client and found attached image error. Can you please do let me how to solve it ? Thanks & Regards, Kunal Varaiya

[Jitendra_Kansal]

You are not even able to open MS SQL DB? can you also if port 1433 can be accessible from smp server machine?

Rgrds,

JK

[Former Member]

Dear Jitendra , I can able to open MS Sql Server because already my agentry application is running with it . Thanks & Regards , Kunal Varaiya