FileNet P8 Rendition Engine, Version 5.2       Application server:  WebSphere Application Server   Operating systems:  Windows

Installing database drivers on WebSphere Application Server

If Content Platform Engine is deployed on WebSphere® Application Server and uses a different database than Rendition Engine, you must install drivers for the Rendition Engine database on the Content Platform Engine server.

Rendition Engine might be configured to use a different database than the Content Platform Engine object store. For example, Rendition Engine might use Microsoft SQL Server and Content Platform Engine might use DB2®. In this case, you must configure Content Platform Engine with the corresponding JDBC driver for the Rendition Engine database to allow the Rendition Engine client software that is running on the Content Platform Engine application server to access the Rendition Engine database.

To install database drivers on WebSphere Application Server:

  1. Install JDBC drivers on each WebSphere Application Server node where Content Platform Engine is deployed.
    1. Obtain the JDBC drivers for your database type.
      Microsoft SQL Server
      Access the Microsoft Support website and find the version of the SQL Server JDBC Driver that matches the version of the JDK on the system where WebSphere Application Server is installed.
      Oracle
      Access the http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html website and find the JDBC driver file that matches the version of the JDK on the system where WebSphere Application Server is installed.
    2. Extract and copy the JDBC driver file to the following suggested location:
      AIX®, HPUX, HPUXi, Linux, Solaris
      /opt/jars

      Do not copy the file to ...WebSphere/AppServer/lib/ext.

      Windows
      C:\jars

      Do not copy the file to ...WebSphere\AppServer\lib\ext.

  2. Start the WebSphere Application Server administrative console and log on to your Content Platform Engine profile as appserver_console_user, the Administrator Console User and complete the following substeps to configure the Content Platform Engine nodes or cluster (if applicable).
    1. Navigate to Environment > WebSphere Variables.
    2. Select Cell scope from the All scopes list.
    3. Set the value of the variable to the JDBC driver path that you specified when you installed the JDBC drivers on the IBM® WebSphere Application Server machine. (If the variable does not exist, create it and then set its value.)
    4. Select Node scope from the All scopes list. In a cluster configuration, select Node scope for all the nodes in the Content Platform Engine cluster.
    5. In the table of substitution variables, click the item name in the Name column that corresponds to the JDBC environment variable for your database type in the Database environment variables table below.
      Table 1. Database environment variables
      Database JDBC Environment Variable
      SQL Server
      MICROSOFT_JDBC
      _DRIVER_PATH
      Oracle
      ORACLE_JDBC
      _DRIVER_PATH 
    6. Set the value of the name_JDBC_DRIVER_PATH item to the JDBC driver path you specified (/opt/jars or C:\jars).
    7. Optional: Select Server scope from the All scopes list. This step is not required unless you defined the JDBC_DRIVER_PATH variable at the server scope level.
    8. In the table of substitution variables, click the item name in the Name column that corresponds to the JDBC environment variable for your database type in the Database environment variables table.
    9. Set the value of the name_JDBC_DRIVER_PATH item to the JDBC driver path you specified (/opt/jars or C:\jars).
    10. Save your changes to the master configuration.
  3. Repeat this procedure as needed for any object store that uses a different database type.


Last updated: October 2015
p8pis063.htm

© Copyright IBM Corporation 2015.