Configuring the web application server for your JDBC driver

The web application server where you plan to deploy Marketing Operations must contain the correct JAR file to support JDBC connections. This enables your web application to connect to the system tables. The location of the JAR file must be included in the class path of the web application server.

About this task

If you are using WebSphere, and if you allow the installer to create the data source when you install the product, you can skip the step in this procedure about setting the classpath. To enable automatic data source creation during installation, on the Datasource Creation panel, select the Create Marketing Operations Datasource check box and supply information about your WebSphere profile. If you do not want to allow the installer to create the data source, then perform this entire procedure.

If you are using WebLogic, you must perform this entire procedure.

Note: If you are installing Marketing Operations on the same machine where you installed Marketing Platform, this task is already complete. Continue to Creating the JDBC connections in the web application server.

Procedure

  1. Obtain the latest Type 4 JDBC drivers and any required associated files (for example, Oracle requires several associated files) for the database you plan to use. See the Recommended Software Environments and Minimum System Requirements guide for details.

    You should always use the latest vendor-provided Type 4 driver.

    • If the driver does not exist on the machine where Marketing Operations will be installed, obtain it and copy it to any location on the Marketing Operations machine.
    • If you obtain the driver from a machine where the database client is installed, verify that the version is the latest supplied by the database vendor. See your HCL consultant for a list of supported JDBC drivers.
  2. Include the full path to the driver in the CLASSPATH of the web application server where you plan to deploy Marketing Operations, as follows.
    • For all supported versions of WebLogic, add the jar files to the CLASSPATH variable in DOMAIN_DIR\bin\setDomainEnv.cmd. Yours must be the first entry of the CLASSPATH values to ensure that the web application server uses the correct driver. For example, if you are using SQL Server you might set the path as follows.

      set CLASSPATH=c:\SQLDRIVER\sqljdbc.jar;%PRE_CLASSPATH%;%WEBLOGIC_CLASSPATH%; %POST_CLASSPATH%;%WLP_POST_CLASSPATH%

    • For all supported versions of WebSphere®, set the CLASSPATH in the Administration Console.