SMP Integration Gatway with 3.0 OData

[Former Member]

HI

i try to get oData Service yesterday i got the data using oData service.

but today it give me

http://192.168.59.192:8080/gateway/odata/sap/intgwtest;v=1/CUSTOMER

Cannot load JDBC driver class 'org.hsqldb.jdbcDriver'

Kindly guide me how to resolve.

Regard

Ali

[Jitendra_Kansal]

Hi Ali,

there could be many reason for above issue:

1. Make sure to add hsqldb.jar file in CLASSPATH as below:

          CLASSPATH: D:\hsqldb-2.3.2\lib\hsqldb.jar;%JAVA_HOME%\bin

2. Check if you have deployed HSQLDB.jar file in pickup folder (E:\SAP\MobilePlatform3\Server\pickup) and check its status in ".state" folder.

3. make sure you have added correct details in "destination" tab and map it with deployed OData service under "services"tab.

4. DB should be up and running while opening service document.

5. Have a look at server logs.

Please share steps & screenshots of above steps if in case you still see the same error.

Regards,

JK