(new related group 1)

PostgreSQL

Voriges Thema

Nächstes Thema

Apache Derby

As with other external databases, we recommend that you create a new database instance for use by the IGEL UMS.

Perform the following steps to create a new database instance and define the instance as a data source in the UMS Administrator:

  1. For security purposes, enable User Authentication in the Derby DB.
  2. Launch the ij Utility (in [derby-installation-dir]/bin).
  3. To create the rmdb instance, execute the following command:

    connect

    'jdbc:derby:rmdb;user=dbm;password=dbmpw;create=true';

  4. Define the UMS database user rmlogin with passwordi rmpassword

    CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.rmlogin', 'rmpassword');

  5. Exit ij and launch the Derby Network Server.
  6. In the UMS Administrator, create a new Derby-type data source with the host name of the Derby Server and the correct server port (default is 1527), user rmlogin and database rmdb.

    For further information regarding installation of the Derby database, see http://db.apache.org/derby.