Step: Configure the web application servers for your JDBC drivers

Use the following procedure to obtain the correct JDBC drivers for your IBM® Unica Marketing installation, and to configure your web application server to use it.

Perform this procedure for every web application server where you plan to deploy your IBM® Unica Marketing products.

1.	Obtain the latest vendor-provided Type 4 JDBC drivers supported by IBM® Unica Marketing. See the reference table or tables in this section for details.

If the drivers do not exist on the machine where the product is installed, obtain them and copy them to the machine or machines where you plan to deploy IBM® Unica Marketing web applications. You may copy them to any location on the machine where you plan to deploy the IBM® Unica Marketing product. To avoid potential path issues, unpack the drivers in a path that does not include spaces.

If you obtain the drivers from a machine where the data source client is installed, verify that the version is the latest supported by IBM® Unica Marketing.

The following table lists the driver file name or names for database types supported for IBM® Unica Marketing system tables.

Database type	File(s)
Oracle 9g and 10g	ojdbc14.jar
Oracle 11	ojdbc5.jar For WebLogic 10g R3, Weblogic 11gR1, and WebSphere® 7.0 with JDK 1.6 - use ojdbc6.jar
DB2®	db2jcc.jar db2jcc_license_cu.jar - not present in V9.5 or V9.7
SQL Server	You must use version 1.2 or above of the SQL Server driver sqljdbc.jar WebLogic 10g R3, WebLogic 11gR1, and WebSphere® 7.0 with JDK 1.6 - use sqljdbc4.jar For SQL Server 2005 on Windows™ 2008, you must use version 2.0 of the SQL Server driver sqljdbc.jar. For all other platforms, you must use version 1.2 of the SQL Server driver sqljdbc.jar.

2.	Include the full path to the drivers in the classpath of the web application servers where you plan to deploy IBM® Unica Marketing products, as follows.

For all supported versions of WebLogic, set the classpath in the setDomainEnv script in the WebLogic_domain_directory/bin directory where environment variables are configured. Your driver entry must be the first entry in the CLASSPATH list of values, before any existing values, to ensure that the web application server uses the correct driver. For example:

UNIX™

CLASSPATH="/home/oracle/product/10.2.0/jdbc/lib/ojdbc14.jar:
${PRE_CLASSPATH}${CLASSPATHSEP}${WEBLOGIC_CLASSPATH}
${CLASSPATHSEP}${POST_CLASSPATH}${CLASSPATHSEP}${WLP_POST_CLASSPATH}"
export CLASSPATH

Windows™

set CLASSPATH=c:\oracle\jdbc\lib\ojdbc14.jar;%PRE_CLASSPATH%;
%WEBLOGIC_CLASSPATH%;%POST_CLASSPATH%;%WLP_POST_CLASSPATH%

For all supported versions of WebSphere®, set the classpath in the Administration console while you are setting up the JDBC providers for the IBM® Unica Marketing products.

3.	Restart the web application server so your changes take effect.

During startup, monitor the console log to confirm that the classpath contains the path to the database driver.