Skip to Content
Author's profile photo Marvin Hoffmann

How to open the SMP3 (Developer Edition) internal database (Apache Derby)

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

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”.


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


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.


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.


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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      I have tried this. its working.

      fantastic stuff. Appreciate your work.

      Author's profile photo Former Member
      Former Member

      Clearly written and no extra blah.


      Author's profile photo Former Member
      Former Member

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


      Author's profile photo Former Member
      Former Member

      Thanks Marvin

      It's really simple to follow & understand! Thanks for sharing.



      Author's profile photo paul thompson
      paul thompson

      With later versions of SMP you may have difficulty with the Apache Derby driver - goto Apache Derby Release and download - unzip and use the jar file: derbyclient.jar - select the relevant (first) class - this should then work