Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
jitendrakansal1
Community Manager
Community Manager
0 Kudos


Hello SMP Administrators,

 

Do you want to expose database information into OData services? Integration gateway will help you. It will convert the data coming from the database to OData. As SMP is based on OSGi, you can not directly deployed JDBC driver to SMP server, it has to be OSGi enabled jar package.

 

There are two different ways to convert JDBC JAR to OSGi JAR:

 

1.  Eclipse plug-in development

2. Command line approach >> Limited to Oracle, SQL server & DB2 drivers

 

I will explain only 2nd approach:

 

In this example, i want to create an OSGi enabled bundle which includes Microsoft JDBC driver for SQL server.

 

Steps followed:

 

1. Copy driver jar file to a temporary folder (SMP server should be installed on same machine)

2. Navigate to this path: C:\SAP\MobilePlatform3\Server\tools\dbconfig

3. execute below command

 
F:\SAP\MobilePlatform3\Server\tools\dbconfig>create_jdbc_bundle.bat -sqlserver C:\temp\sqljdbc4.jar

 



 

You will see a new OSGi enabled jar file has been created in the mentioned folder.

 



 

4. Copy this new jar file and paste in PICKUP folder and make sure that you see an "OK" message under .state folder

 



 

As mentioned already,  there are only 3 supported drivers: SQLServer, Oracle & DB2.

 

-sqlserver

-oracle

-db2

 

So for other databases like SAP HANA, SAP ASE, SAP SQL Anywhere, HSQLDB, MYSQL you can not use above command line method to generate OSGi enabled jar file. You have to go with Eclipse plug-in development

 

Inputs taken from SAP Note 2146914 and big thanks to andreas.wegmann for providing extra information.

CC: SAP for Mobile

Regards,

JK