Configuring the web application server for your JDBC driver
The web application server where you plan to deploy Unica Centralized Offer Management 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 WebLogic, you can skip the steps in this procedure about setting the class path.
If you are using WebLogic, you must perform this entire procedure.
Procedure
-
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 Unica Centralized Offer Management will be installed, obtain it, and copy it to any location on the Unica Centralized Offer Management 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 consultant for a list of supported JDBC drivers.
-
Include the full path to the driver in the CLASSPATH of
the web application server where you plan to deploy Unica Centralized Offer Management, 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.
- 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.