3 - Create and associate a new Data Source for the RPM Web Services application

The RPM WS API uses the jdbc/RPMDATASOURCE location to access the database. We will configure a connection to an Oracle database.

Make sure you have this information ready:

To create the RPM database Data Source

  1. Click on the Cluster Topology link which is located in the upper left corner of the Application Server Control application screen, then click on the name of the application we have deployed. Make sure you expand the Home tree. That is where the name of our application will appear.

  2. Using the tabs at the top of the page, first click on Administration, then from under Services choose JDBC Resources

    Application properties screen

  3. Click on Create from under Data Sources

    Data Sources creation step
  4. From the Application dropdown, choose the name of the application we have just deployed in the previous steps. Choose Native Data Source for the Data Source Type, then click on Continue
  5. Data source setting, second step.
  6. Fill in the following fields, as follows, then make sure you click on the Finish button.
    • Name: is the alias for this Data Source. We use RPMDATASOURCE.
    • JNDI Location: needs to match jdbc/RPMDATASOURCE
    • Data Source Class: should be oracle.jdbc.pool.OracleDataSource
    • Login Timeout should be set to a sensible value, like 5
    • Choose Generate URL from Connection Information
      • Driver Type: Thin
      • DB Host Name: your database server's host name
      • DB Listener Port: The port on which the database listens
      • DB Identifier Type: Service Name
      • SID/Service Name: The name of your database instance
    • Under the Credentials section :
      • In the Username field, type in your database username
      • Choose Use Cleartext Password and type in your database password

    Data Source Creation final step
  7. You will go back to the JDBC Resources screen and a successful message will be displayed on the top of the page

    Data Source Creation confirmation screen