The IBM® Content
Navigator Configuration
and Deployment Tool adds your JDBC drivers to the WebSphere® Application
Server environment variables so
that IBM Content
Navigator can access
its configuration database. However, you must ensure that a copy of
the JDBC drivers is on the web application server before you run the IBM Content
Navigator Configuration and Deployment Tool
Before you begin
Tip: Before you run the task to add the JDBC drivers
to the WebSphere Application
Server environment
variables, ensure that the drivers do not exist in the environment
variables.
If you plan to access an IBM Content
Manager system on a highly available
Oracle RAC database, you must configure IBM Content
Navigator and IBM Content
Manager to use JDBC Type 2 drivers.
By default, IBM Content
Navigator uses
JDBC Type 4 drivers to connect to IBM Content
Manager. However, Oracle RAC supports transparent
application failover only on JDBC Type 2 drivers.
To configure
JDBC Type 2 drivers:
- Configure IBM Content
Manager to
support JDBC Type 2.
- Install the Oracle client on the IBM Content
Navigator server.
- Configure the Oracle tnsname.ora file for
your IBM Content
Manager connection.
- Update the cmbicmsrvs.ini file to use JDBC
Type 2.
- Ensure that the system variable contains the Oracle paths. For
example:
- ORACLE_HOME=C:\app\Administrator\product\11.2.0\client_1
- Path=C:\app\Administrator\product\11.2.0\client_1\bin;C:\app\Administrator\product\11.2.0\client_1;..
About this task
The version of the JDBC driver file that you use must
match the JDBC driver version on the system where WebSphere Application
Server is installed. See Prerequisites for installing IBM Content Navigator for
information about the software that is supported for your database
type.
Procedure
To copy the JDBC drivers for your database to the IBM Content
Navigator server:
- Obtain the JDBC drivers for your database type:
| Database type |
How to obtain the JDBC drivers |
|---|
| DB2® |
Access the IBM Support website
and find the version of the Redistributable DB2 JDBC Driver that matches the version of the
JDK on the system where WebSphere Application
Server is installed. |
| Microsoft SQL
Server |
Access the Microsoft Support website and find
the version of the Microsoft SQL
Server JDBC Driver that matches the version of the JDK on the system
where WebSphere Application
Server is installed. |
| Oracle |
Access the Oracle Software Downloads web page and find
the JDBC driver file that matches the version of the JDK on the system
where WebSphere Application
Server is installed. |
- Extract the JDBC driver file to a directory on the IBM Content
Navigator server. For example:
Table 1. Suggested
location of the JDBC driver file on the IBM Content
Navigator server| Operating system |
Recommended directory |
|---|
| AIX® |
/opt/jars |
| Linux |
/opt/jars |
| Linux for System z® |
/opt/jars |
| Windows |
C:\jars |
Important: Do not copy the file to the following WebSphere Application
Server subdirectory: \WebSphere\AppServer\lib\ext
- If you are using an Oracle database with IBM Content
Manager Enterprise Edition, you must also copy the
JDBC driver to the following directory of your IBM Content
Navigator installation directory:
| Operating system |
Directory |
|---|
| AIX |
Installation_directory/configure/explodedformat/navigagor/WEB-INF/lib/ On AIX, the default directory is /opt/IBM/ECMClient/configure/explodedformat/navigagor/WEB-INF/lib/
|
| Linux |
Installation_directory/configure/explodedformat/navigagor/WEB-INF/lib/ On Linux, the default directory is /opt/IBM/ECMClient/configure/explodedformat/navigagor/WEB-INF/lib/
|
| Linux for System z |
Installation_directory/configure/explodedformat/navigagor/WEB-INF/lib/ On Linux for System z, the default directory is /opt/IBM/ECMClient/configure/explodedformat/navigagor/WEB-INF/lib/
|
| Windows |
Installation_directory\configure\explodedformat\navigator\WEB-INF\lib\ On Windows, the default directory
is C:\Program Files (x86)\IBM\ECMClient\configure\explodedformat\navigator\WEB-INF\lib\
|