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:
- Install JDBC drivers on each WebSphere Application
Server node where Content Platform Engine is deployed.
- 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.
- 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.
- 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).
- Navigate to .
- Select Cell scope from the All scopes list.
- 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.)
- 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.
- 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 variablesDatabase |
JDBC Environment Variable |
SQL Server |
MICROSOFT_JDBC
_DRIVER_PATH
|
Oracle |
ORACLE_JDBC
_DRIVER_PATH
|
- Set the value of the name_JDBC_DRIVER_PATH item to
the JDBC driver path you specified (/opt/jars or
C:\jars).
- 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.
- 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.
- Set the value of the name_JDBC_DRIVER_PATH item to
the JDBC driver path you specified (/opt/jars or
C:\jars).
- Save your changes to the master configuration.
- Repeat this procedure as needed for any object store that uses a different database type.