IBM Support

Using a different port number for the Derby database in IBM Rational DOORS Web Access

Question & Answer


Question

How to use a custom port number for the Derby database in IBM Rational DOORS Web Access?

Cause

IBM Rational DOORS Web Access uses Derby to implement a Tracked Resource Set (TRS) provider so that DOORS data can be indexed by IBM Rational Lifecycle Query Engine (LQE).

By default, Derby is configured to use port 1527. However if that port is already in use, for example by another Derby database server, then you will need to configure IBM Rational DOORS Web Access to use a different port.

Answer

First make a backup copy of the following 4 files (replacing <DWA_HOME> with the installation path for DOORS Web Access on your host machine, for example C:\Program Files (x86)\IBM\Rational\DOORS Web Access\9.6.0.0).


<DWA_HOME>\server\festival\config\festival.xml:
<DWA_HOME>\derby.start.bat:
<DWA_HOME>\derby\derby.properties:
<DWA_HOME>\derby\scripts\init_setting.bat:

To change the default derby port to a free port, in this example 1528, make the following changes:

 

  1. Add the trs.db.port line to <DWA_HOME>\server\festival\config\festival.xml list of system properties as follows :

    <!-- Configurable system properties -->
    <f:properties>
    ...
         <f:property name="trs.db.port" value="1528"/>
    </f:properties>


  2. Add the following line to <DWA_HOME>\derby.start.bat before the %JRE_HOME%\bin\java command is run:
    set DERBY_PORT=1528

  3. Add the following line to the file <DWA_HOME>\derby\derby.properties:
    derby.drda.portNumber=1528

  4. Add the following line to the file <DWA_HOME>\derby\scripts\init_setting.bat:
    set DERBY_PORT=1528

  5. Restart IBM Rational DOORS Web Access

[{"Product":{"code":"SSYQCV","label":"IBM Engineering Requirements Management DOORS Web Access"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5;9.5.0.1;9.5.1;9.5.1.1;9.5.2;9.5.2.1;9.6;9.6.0.1;9.6.1;9.6.1.1;9.6.1.3;9.6.1.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

DWA;Derby;TRS

Document Information

Modified date:
16 June 2018

UID

swg21677524