Skip to Content
Author's profile photo Nakul Patel

How to connect to Apache Derby database that comes with SMP?

This article provides step by step instructions to connect to Apache Derby database, using command line interface, that comes with SAP Mobile Platform 3.0. The syntax provided is for Windows platform but the concept is same for Linux environment.

  1. Download Derby release: (We should only download this version to match version with that shipped in SMP)
  2. Unzip the zip file
  3. Copy the following files into new folder (for example, C:\Users\Administrator\Desktop\derby)
    • derbyclient.jar
    • derby.jar
    • derbynet.jar
    • derbyrun.jar
    • derbytools.jar
  4. Set the following environment variables
    SETX JAVA_HOME C:\SAP\MobilePlatform3\sapjvm_8
    SETX DERBY_HOME C:\Users\Administrator\Desktop\derby
  5. Close and re-open command line for new environment variables to be available
  6. Stop SMP server to stop the already started derby. In SMP, Derby is not started in server mode. That means that once SMP is started, the CLI would refuse to connect. It can only connect if SMP has been shut down.
  7. In command line type below command to run ij, the interactive SQL scripting tool
  8. To connect to the SMP derby database use the below command. “C:/SAP/MobilePlatform3/Server/db/derby/smp3” is the full path to SMP 3 Derby database.
    connect 'jdbc:derby:C:/SAP/MobilePlatform3/Server/db/derby/smp3;create=false;user=gomobile;password=secret';

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.