Skip to Content

As you might know you can install SMP3 with different options. If you are choosing the Developer Edition SMP3 will install its own database which is used to store SMP3 related information. The database is an Apache Derby database and can be accessed using open source utilities.

In this post I will use the open-source Java SQL Client SQuirreL to connect to the Apache Derby database.

1. Download the SQL Client SQuirreL http://squirrel-sql.sourceforge.net/

2. There is an install file called squirrel-sql-3.5.0-install.jar or similar. Execute it to install SQuirreL.

3. After installation you can execute it by calling the batch script C:\tools\Squirrel\squirrel-sql.bat (there should be also a desktop icon)

4. inside SQuirreL click on tab “Drivers”, select “Apache Derby Client” and switch to tab “Extra Class Path”. Click on “Add”, navigate to path “C:\SAP\MobilePlatform3\Server\plugins\org.apache.derby_10.8.2.2” and choose “derbyclient.jar”.

5. After confirmation you should see a small blue check mark in front of “Apache Derby Client”.

SMP3_Apache_Derby_(SQuirreL)_Setup.png

5. Switch to tab “Aliases” and click on the “+” button to add a new alias.

6. Define an alias name, e.g. “SMP3 Derby”, choose “Apache Derby Client” as Driver and type the following path inside URL input field: “jdbc:derby://localhost:1527/C:\SAP\MobilePlatform3\Server\db\derby\smp3”. By default the database is running on port 1527. The default user name is “gomobile” and the corresponding password is “secret”.

Property Value
Name e.g. SMP3 Derby
Driver Apache Derby Client
URL jdbc:derby://localhost:1527/C:\SAP\MobilePlatform3\Server\db\derby\smp3
User Name gomobile
Password secret

SMP3_Apache_Derby_(SQuirreL).png

7.After that SQuirreL will connect to the Derby database.

8. For SMP3 related settings navigate to schema “GOMOBILE” and expand “TABLE” to see all tables which are used by SMP3.

SMP3_Apache_Derby_(gomobile)_00.png

9. So as example, if you want to see your Endpoint Configuration open table “SMP_ENDPOINT_CONFIGURATION”. Switch on the right side to tab “Content”. There you can see the table rows with ENDPOINTNAME, ENDPOINTADDRESS and so on.

SMP3_Apache_Derby_(gomobile).png

Now you should be able to open the Apache Derby database, e.g. for reviewing SMP3 related setting information.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Paul Horan

    FYI: for those installing onto Mac OS/X, the alias URL is:

    jdbc:derby://localhost:1527//users/<user>/SAP/MobilePlatform3/db/derby/smp3

    (0) 

Leave a Reply