Creating a JDBC Datasource for Directory Database

After creating a JDBC Provider, you must create a JDBC datasource to provide database connectivity to Oracle BPM applications. The following procedures show you how to create a JDBC datasource for the Oracle BPM directory database.
Before creating the JDBC Datasources you must have defined:
To create a JDBC datasource for the directory DB:
  1. Login to WebSphere's Administration Console. By default, it runs on http://host:9060/ibm/console.
  2. Go to Resources > JDBC > JDBC Providers and click on the Oracle JDBC Provider you created previously.
  3. Click on Data sources, located in the Additional properties section.
  4. Click New to create a new Data source for Oracle BPM Directory database.
  5. Enter the following configuration information for your new data source:
    Option Value
    Data Source Name Oracle BPM Directory Data Source
    JNDI Name FDIDS
    Component-managed Authentication Alias Select the Authentication entry you defined previously for Oracle BPM Directory database.

    For example: node/Oracle BPM Directory DB Auth
  6. Click Next and enter the following Data store helper class name: albpm.jdbc.websphere.ALBPMDataStoreHelper .
  7. Click Next, then Finish after reviewing all selected options.
  8. Select the data source you just created.
  9. Click Custom properties located under the Additional properties section in the right pane.

    You should see a complete list of all driver properties. If you do not see this list, there is an error with your configuration.

  10. Configure the connectivity properties for your database vendor. See Engine and Directory Database Connectivity for more information. For general information on using the JDBC drivers provided with Oracle products, see JDBC Drivers.
  11. Click Save to persist your WebSphere configuration changes.
  12. Test your datasource configuration.
    1. Expand JDBC > JDBC Providers
    2. Select the JDBC datasource you just configured
    3. Click Data sources
    4. Select the checkbox next to the datasource you want to test
    5. Click Test Connection
The JDBC datasources for the Oracle BPM Directory database is configured.
Parent topic: Configuring WebSphere Application Server
Previous topic: Creating a New JDBC Provider
Next topic: Creating a JDBC Datasource for the Engine Database