Creating a JDBC Datasource for the Engine Database

After creating a JDBC datasource for the directory database, you another JDBC resource to provide database connectivity to Oracle BPM applications for the Oracle BPM engine database.
Before creating the JDBC Datasources you must have defined:
To configure a JDBC datasource for the engine database:
  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 BEA 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 Engine database. Enter the following configuration information for the new data source:
    Option Value
    Data source name Oracle BPM Engine Datasource
    JNDI name XAEngineDS
    Component-managed Authentication Alias

    Select the Authentication entry you defined previously for Oracle BPM Engine database. Example:

    <node>/Oracle BPM Engine DB Auth
  5. Click Next and enter the following Data store helper class name: albpm.jdbc.websphere.ALBPMDataStoreHelper.
  6. Click Next again, and Finish after reviewing all selected options.
  7. Select your newly created Data source.
  8. Click Custom properties located under the Additional properties section.
  9. 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 BEA products, see JDBC Drivers.
  10. Click on Save to persist your WebSphere configuration changes.
The JDBC Datasource for Oracle BPM Engine database is configured.
Parent topic: Configuring WebSphere Application Server
Previous topic: Creating a JDBC Datasource for Directory Database
Next topic: Creating a WebSphere JMS Bus