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 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”.
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”.
|Name||e.g. SMP3 Derby|
|Driver||Apache Derby Client|
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.