Creating a New JDBC Provider

You must create and configure a new JDBC provider to use the JDBC drivers provided by BEA.
  1. Login to WebSphere's administration console. By default, the administration console runs at: http://host:9060/ibm/console.
  2. Select Resources > JDBC > JDBC Providers
  3. Click New to add a new JDBC Provider.
    Note: You must select a WebSphere configuration scope for your new resources.

    In a single-node configuration, you must select the server node. In a clustered configuration, you must select the cluster cell as the target.

    Refer your WebSphere documentation for more details about its configuration scoping rules.

  4. Enter the following configuration values for the new provider:
    Option Value
    Database type User-Defined
    Implementation class name
    Enter one of the following class names depending on which database provider you are using:
    • Oracle: albpm.jdbcx.oracle.OracleDataSource
    • SQL Server: albpm.jdbcx.sqlserver.SQLServerDataSource
    • DB2: albpm.jdbcx.db2.DB2DataSource
    Name BEA JDBC Provider
    Note: Ensure that you select User-defined for each of the supported database types. You must select this option in order to configure the JDBC drivers supplied by Oracle BPM.
  5. Press Next to enter the JDBC Classpath information. You must list the following .jar files:
    • <ORABPM_HOME>/libraries/b1oracle.jar (Oracle only)
    • <ORABPM_HOME>/libraries/b1db2.jar (DB2 only)
    • <ORABPM_HOME>/libraries/b1sqlserver.jar (SQL Server only)
    • <ORABPM_HOME>/libraries/b1util.jar
    • <ORABPM_HOME>/libraries/b1resource.jar
    • <ORABPM_HOME>/libraries/b1base.jar
    • <ORABPM_HOME>/ext/fuego.database.websphere.helper.jar

    These files are installed with Oracle BPM Enterprise. You must specify the full path to each of these jar files. Each must be defined on its own line.

    To avoid hard-coding the full paths, you can copy the .jar files to a common directory, then define a new WebSphere environment variable (e.g.ORACLE_JDBC_DRIVERS_PATH) containing the path to this directory. You can then, specify the classpath as follows:
    • ${ORACLE_JDBC_DRIVERS_PATH}/b1oracle.jar
    • ${ORACLE_JDBC_DRIVERS_PATH}/b1util.jar
    • ${ORACLE_JDBC_DRIVERS_PATH}/b1resource.jar
    • ${ORACLE_JDBC_DRIVERS_PATH}/b1base.jar
    • ${ORACLE_JDBC_DRIVERS_PATH}/fuego.database.websphere.helper.jar
  6. Click Next again, and Finish after reviewing all selected options.
  7. Click on Save to persist your WebSphere configuration changes.
The new JDBC provider using BEA's drivers is now configured.
Parent topic: Configuring WebSphere Application Server
Previous topic: Adding Authentication Data for JDBC
Next topic: Creating a JDBC Datasource for Directory Database