3 - Editing the Deployment File rpm.xml

  1. Copy the rpm.xml and rpm-web-services.war files to a directory on the same computer as the Tomcat Server. The rpm-web-services.war file can be found in the rpm-web-services.ear. Extract the EAR file with a Zip file extractor to find the WAR file.
  2. Open the rpm.xml file with a text editor.
  3. Edit the Context docBase tag to state the location of the rpm-web-services.war file. It should be set to the directory where you copied the two files. If you are you using Tomcat V5.0, change the path="/rpm" parameter only if required. It defines the actual URL that will be used to call the Web Services API (for example, http://mytomcatserver.mycompany.com:8080/rpm). If you are using Tomcat V5.5, there should not be a path attribute in the Context element.
  4. Edit the jdbc/RPMSESSION to the actual values defined in the section Installing the Session Database. Do not change the Resource name or the ResourceParams name. They also need to have the same value. Do not remove or change the validationQuery parameter. This parameter is a SQL statement that enables Tomcat to know if a connection is still valid.
  5. Edit jdbc/RPMDATASOURCE parameters to the actual value required by your RPM database. If you change the Resource name or the ResourceParams name, make sure they have the exact same value. This name will be used as the DSN name when calling a Web Service.
    Note: Do not remove or change the validationQuery parameter. This parameter is an SQL statement that enables Tomcat to know if a connection is still valid.
  6. Save and close the rpm.xmlfile.

    The following is an example of the rpm.xml file for Tomcat V5.0:

    <?xml version='1.0' encoding='utf-8'?>
    <Context docBase="C:/tmpwars/rpm-web-services.war" path="/rpm" reloadable=
    "true">
        <Resource name="jdbc/RPMSESSION" type="javax.sql.DataSource"/>
        <ResourceParams name="jdbc/RPMSESSION">
          <parameter>
            <name>maxWait</name>
            <value>5000</value>
          </parameter>
          <parameter>
            <name>maxActive</name>
            <value>4</value>
          </parameter>
          <parameter>
            <name>password</name>
            <value>RPMSESSION</value>
          </parameter>
          <parameter>
            <name>url</name>
            <value>jdbc:derby:C:\RPMSESSION</value>
          </parameter>
          <parameter>
            <name>driverClassName</name>
            <value>org.apache.derby.jdbc.EmbeddedDriver</value>
          </parameter>
          <parameter>
            <name>maxIdle</name>
            <value>2</value>
          </parameter>
          <parameter>
            <name>username</name>
            <value>RPMSESSION</value>
          </parameter>
          <parameter>
            <name>validationQuery</name>
            <value>values(1)</value>
          </parameter>
        </ResourceParams>
        <Resource name="jdbc/RPMDATASOURCE" type="javax.sql.DataSource"/>
        <ResourceParams name="jdbc/RPMDATASOURCE">
          <parameter>
            <name>validationQuery</name>
            <value>values(1)</value>
          </parameter>
          <parameter>
            <name>maxWait</name>
            <value>5000</value>
          </parameter>
          <parameter>
            <name>maxActive</name>
            <value>4</value>
          </parameter>
          <parameter>
            <name>password</name>
            <value>database-server-password</value>
          </parameter>
          <parameter>
            <name>url</name>
            <value>jdbc:db2://database-server-url.com:50000/RPM</value>
          </parameter>
          <parameter>
            <name>driverClassName</name>
            <value>com.ibm.db2.jcc.DB2Driver</value>
          </parameter>
          <parameter>
            <name>maxIdle</name>
            <value>2</value>
          </parameter>
          <parameter>
            <name>username</name>
            <value>database-user-name</value>
          </parameter>
        </ResourceParams>
    </Context>

The following is an example of the rpm.xml file for Tomcat V5.5:

<?xml version='1.0' encoding='utf-8'?>
<Context docBase="c:\tmpwars\rpm-web-services-x.x.x.x.war" reloadable="true">
          <Resource
            auth="Container"
            description=""
            name="jdbc/RPMSESSION"
            type="javax.sql.DataSource"
            password="RPMSESSION"
            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
            maxIdle="2"
            maxWait="5000"
            username="RPMSESSION"
            url="jdbc:derby:C:\RPMSESSION"
            maxActive="4" 
            validationQuery="values(1)"/>
    	<Resource
            auth="Container"
            description=""
            name="jdbc/RPMDATASOURCE"
            type="javax.sql.DataSource"
            password="database-server-password"
            driverClassName="com.ibm.db2.jcc.DB2Driver"
            maxIdle="2"
            maxWait="5000"
            username="database-user-name"
            url="jdbc:db2://database-server-url.com:50000/RPM"
            maxActive="4"/>
</Context>