Editing the Configure JDBC Driver task

You can use Configuration Manager to add your database JDBC driver to your web application server environment variables so that Content Platform Engine can access its configuration database table.

Before you begin

Before you configure your database JDBC driver, you must copy the JDBC driver for your database to the Content Platform Engine server.

Attention: If you plan to deploy Content Platform Engine in a highly available cluster, you must copy the driver to the same directory on each node in the cluster.

This task assumes that you have a configuration profile open in Configuration Manager.

About this task

To configure your database JDBC driver:

Procedure

  1. From the configuration profile, open the Configure the JDBC Driver for Your Database task.
  2. Provide the property values for your database JDBC driver.
    Table 1. JDBC driver configuration properties
    Property Description
    Deployment type The type of environment where the web application is deployed (Cluster, Network Deployment, or Standard)
    JDBC driver The JDBC driver that corresponds to your database type (DB2,DB2 HADR, DB2 pureScale, Oracle, Oracle RAC, Microsoft SQL Server, or PostgreSQL)
    JDBC directory The directory where you installed the JDBC driver files on your server
    Application server node The node where the web application is deployed (Standard and Network Deployment only)
    Application server name The server where the web application is deployed (Standard and Network Deployment only)
    Application server cluster name The cluster where the web application is deployed (Cluster deployments only)
    JDBC configuration script The fully qualified path of the JDBC configuration script (setWSJDBCjars.tcl for WebSphere Application Server). Default locations:
    • AIX or Linux: /opt/IBM/ECMClient/configure/scripts/setWSJDBCjars.tcl
    • Windows: C:\Program Files\IBM\ECMClient\configure\scripts\setWSJDBCjars.tcl
    Temporary directory The fully qualified path to a temporary directory that Configuration Manager can use to run the task. The default directory is the \configure\tmp subdirectory of the Content Platform Engine installation directory. It is recommended that you use the default value.
  3. Select File > Save to save your changes.
    Saving your changes to disk does not apply the settings to the application server.
  4. Click Next to run the task.

What to do next

After configuring the JDBC driver, configure the JDBC data sources as described in Editing the Configure JDBC Data Sources tasks.