command line also helps you in converting JDBC JAR to OSGi JAR to use with Integration Gateway in SMP
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:
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.
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.
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
CC: SAP for Mobile