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:
- 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>
- Add the following line to
<DWA_HOME>\derby.start.bat
before the%JRE_HOME%\bin\java command is run:
set DERBY_PORT=1528
- Add the following line to the file
<DWA_HOME>\derby\derby.properties
:
derby.drda.portNumber=1528
- Add the following line to the file
<DWA_HOME>\derby\scripts\init_setting.bat
:
set DERBY_PORT=1528
- Restart IBM Rational DOORS Web Access
Product Synonym
DWA;Derby;TRS
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21677524