Configuring the web application server for your JDBC driver
Interact requires the correct JAR file to support JDBC connections. You must add the location of the JAR file to the class path of the web application server where you plan to deploy Interact.
Complete the following steps to configure the web application server for your JDBC driver:
1.
Obtain the latest vendor-provided Type 4 JDBC driver that is supported by IBM® EMM, as described in the Recommended Software Environments and Minimum System Requirements guide.
Use the following guidelines after you obtain the JDBC driver:
*
If the driver does not exist on the server where you plan to deploy Interact, obtain it and unpack it on the server. Unpack the drivers in a path that does not include spaces.
*
The following table lists the driver file name or names for the databases that are supported for the IBM® EMM system tables:
DB2®
db2jcc4.jar- required for V10.1
db2jcc_license_cu.jar - not required in V9.5 and higher
Use version 2.0 of the SQL Server driver and above. See the Recommended Software Environments & Minimum System Requirements guide for the exact version of the driver to use.
2.
According to the web application server where you plan to deploy Interact, use the following guidelines:
*
For all supported versions of WebLogic, set the class path 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 class path 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/11.0.0/jdbc/lib/ojdbc6.jar:
${PRE_CLASSPATH}${CLASSPATHSEP}${WEBLOGIC_CLASSPATH}
${CLASSPATHSEP}${POST_CLASSPATH}${CLASSPATHSEP}${WLP_POST_CLASSPATH}"
export CLASSPATH
Windows
set CLASSPATH=c:\oracle\jdbc\lib\ojdbc6.jar;%PRE_CLASSPATH%;
%WEBLOGIC_CLASSPATH%;%POST_CLASSPATH%;%WLP_POST_CLASSPATH%
*
For all supported versions of WebSphere®, set the class path when you set up the JDBC providers for Interact.
3.
Make a note of the database driver class path in the Interact installation worksheet, as you must enter the path when you run the installer.
4.
During startup, monitor the console log to confirm that the class path contains the path to the database driver.