Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Run the ij tool located in the <DERBY_HOME>/bin/ directory as illustrated below:
    Image Removed Image Added
  2. Create the database and connect to it using the following command inside the ij prompt:
    connect 'jdbc:derby:repository/database/WSO2CARBON_DB;create=true';
    Info

    Replace the database file path in the above command with the full path to your database.

  3. Exit from the ij tool by typing the exit command.
    exit;
  4. Log in to the ij tool with the username and password that you set in registry.xml and user-mgt.xml:
    connect 'jdbc:derby:repository/database/WSO2CARBON_DB' user 'regadmin' password 'regadmin';
  5. Use the scripts given in the following locations to create the database tables:

    • To create tables for the registry and user manager database (WSO2CARBON_DB), run the below command:

      Code Block
      languagepowershell
      run '<PRODUCT_HOME>/dbscripts/derby.sql';
      Info

      Now the product is running using the embedded Apache Derby database.

  6. Restart the server.

...