Create 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. You may select cell scope. Refer to WebSphere's official 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 ALBPM.
5. Press Next to enter the JDBC Classpath information. You must list the following .jar files:
   
   • BEA_HOME/albpm6.0/j2eews/libraries/b1oracle.jar (Oracle only)
   • BEA_HOME/albpm6.0/j2eews/libraries/b1db2.jar (DB2 only)
   • BEA_HOME/albpm6.0/j2eews/libraries/b1sqlserver.jar (SQL Server only)
   • BEA_HOME/albpm6.0/j2eews/libraries/b1util.jar
   • BEA_HOME/albpm6.0/j2eews/libraries/b1resource.jar
   • BEA_HOME/albpm6.0/j2eews/libraries/b1base.jar
   • BEA_HOME/albpm6.0/j2eews/ext/fuego.database.websphere.helper.jar

   These files are installed with ALBPM 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.BEA_JDBC_DRIVERS_PATH) containing the path to this directory. You can then, specify the classpath as follows:
   

   • ${BEA_JDBC_DRIVERS_PATH}/b1oracle.jar
   • ${BEA_JDBC_DRIVERS_PATH}/b1util.jar
   • ${BEA_JDBC_DRIVERS_PATH}/b1resource.jar
   • ${BEA_JDBC_DRIVERS_PATH}/b1base.jar
   • ${BEA_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.