This topic describes how to configure a JDBC provider and data source for the business process container using the administrative console.
Steps for this task
${INFORMIX_JDBC_DRIVER_PATH}/ifxjdbc.jar ${INFORMIX_JDBC_DRIVER_PATH}/ifxjdbcx.jar
${WAS_LIBS_DIR}/sqlserver.jar ${WAS_LIBS_DIR}/base.jar ${WAS_LIBS_DIR}/util.jar ${WAS_LIBS_DIR}/spy.jar
${WAS_LIBS_DIR}/sljc.jar ${WAS_LIBS_DIR}/spy-sl53.jar
Note: Click Environment> Manage WebSphere Variables, and check that the variable for the JDBC driver path is set to an appropriate value. For example, on Windows systems to c:/sqllib/java. For Microsoft SQL Server, the variable WAS_LIBS_DIR must point to the WebSphere lib directory
Field | Value for non-XA Oracle data source |
---|---|
JDBC provider name | Oracle JDBC Driver |
JDBC driver name | BPEJdbcDriverOracleNonXA |
Classpath | ${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar |
Implementation class name | oracle.jdbc.pool.OracleConnectionPoolDataSource |
Data source name | BPEDataSourceOracleNonXA |
Data source helper class name | OracleDataStoreHelper |
Results
The JDBC provider and data source for your database have been configured for the business process container. The new data source is now listed in the data source panel.What to do next
Configure the queue resources.