WebSphere Commerce EnterpriseWebSphere Commerce Professional

Defining the JDBC driver path

Defining the JDBC driver path is a required step when configuring horizontal clustering.

About this task

This section applies only to clustering with horizontal cluster members.

You must ensure that the JDBC provider is configured properly within your clustered environment. The JDBC provider software is included with the database client software that you have installed on each node. Each WebSphere Commerce node that has servers that are part of the cluster must have the JDBC provider information defined. When WebSphere Commerce creates a new instance this information is defined at the node level. When configuring a cluster, each node that has a new cluster member must be configured to reference the appropriate JDBC provider. To define your JDBC provider information, complete the following steps:

Note: You are not required to complete these steps on the node where you have originally installed WebSphere Commerce.

Procedure

  1. If they are not started, start the node agent on each system managed by WebSphere Application Server Network Deployment.
    SolarisLinuxAIXNote: Ensure that you start each node agent as the WebSphere Commerce non-root user.
  2. If it is not started, start the deployment manager. Refer to:
  3. Open the WebSphere Application Server Deployment Manager Administrative Console. For instructions, refer to Launching the WebSphere Application Server Administrative Console.
  4. In the Navigation area, expand Environment. Select WebSphere Variables.
  5. Select Browse Nodes, and choose the node that you want to configure. You must configure all nodes that run WebSphere Commerce. Click OK.
  6. Click the link for the variable that represents your database type. The defaults are listed below:
    • DB2DB2_JDBC_DRIVER_PATH
    • OracleORACLE_JDBC_DRIVER_PATH
  7. In the Value field enter the path to the appropriate JDBC provider. Do not enter the name of the .jar file in this field. This value requires the directory path only. For example:
    • DB2DB2_installdir/java
    • OracleOracle_installdir/jdbc/lib
  8. Click OK.
  9. Click Review to save your changes.
  10. Select Synchronize changes with Nodes to ensure that the deployment manager profile immediately synchronizes the configuration changes with the other nodes.
  11. Click Save.
  12. Click OK.
  13. Log out of the WebSphere Application Server Deployment Manager Administrative Console.