Creating a data source and connection pool

Create a connection pool and a data source in WebSphere® Application Server to enable Rule Execution Server.

Procedure

  1. In the Integrated Solutions Console, open Resources  > JDBC and Data sources.
  2. Under Scope, select the scope that you selected for the JDBC provider in Creating a JDBC provider and click New.
  3. In Step 1, enter Rule Execution Server datasource as the name for the data source and jdbc/resdatasource in the JNDI name field, and click Next.
    Important: You can enter any name for the data source, but the JNDI name must be jdbc/resdatasource.
  4. In Step 2, choose Select an existing JDBC provider, select the JDBC provider that you created in Creating a JDBC provider, and click Next.
  5. In Step 3, enter the specific database properties for the data source.
  6. Deselect Use this data source in container managed persistence (CMP).
  7. Click Next.
  8. In Step 4, set up any required security aliases and click Next when done.

    In Step 5, a summary of the data source is provided.

  9. Click Finish and then Save to save the changes to the master configuration.