FileNet P8 Content Engine, Version 5.0.+              

Configuring the Global Configuration Data JDBC data source settings

You must provide property information about the JDBC data sources for the Global Configuration Data (GCD) database. Content Engine uses the data source information to connect to and update the GCD database.

Ensure that the application server is running or stopped, depending on its type:
Table 1. Required application server state
Option Description
WebSphere® Application Server Start the application server if it is not already running.
JBoss Application Server Stop the application server.
WebLogic Server Start the application server if it is not already running.

To configure the JDBC settings:

  1. Open your completed Installation and Upgrade Worksheet file.
    Tip: In the worksheet file, verify that the Data > Filter > AutoFilter command is enabled. To view only Configuration Manager values, filter by CM: Configure GCD JDBC Data Sources in the Installation or Configuration Program column.
  2. If your configuration profile is not open in Configuration Manager, open the profile.
  3. Right-click Configure GCD JDBC Data Sources in the profile pane and select Edit Selected Task.
  4. Enter the property values for your database by using the values in your worksheet.
  5. High availability In a high availability environment, enter the following additional information for the Configure GCD JDBC Data Sources task:
    Database server name
    If you are using a highly available database for the Global Configuration Data (GCD), use the virtual server name.
    Database server name RAC node n
    If you are using Oracle RAC, then you must enter the database information for two nodes in the RAC cluster.
    Configuration Manager uses the values that you provided to create the JDBC URL in the format shown in the following table:
    Table 2. JDBC URL format for Oracle RAC
    Server Description Example
    WebSphere
    jdbc:oracle:@
    (DESCRIPTION = (load_balance=yes)
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = rac node 1)
    (PORT = 1521))(ADDRESS = 
    (PROTOCOL = TCP)(HOST = rac node 2)
    (PORT = 1521)))
    (CONNECT_DATA =(SERVICE_NAME = 
    DB service name)
    (failover_mode = (type=select)
    (method=basic)
    (retries=retry number)(delay=
    delay value))))
    jdbc:oracle:
    @(DESCRIPTION =(load_balance=yes)
    (ADDRESS_LIST=(ADDRESS = 
    (PROTOCOL = TCP)(HOST = testrac1)
    (PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = testrac2)(PORT = 1521)))
    (CONNECT_DATA =(SERVICE_NAME = 
    testracdb)(failover_mode = 
    (type=select)(method=basic)
    (retries=32)(delay=4))))
    Oracle WebLogic Server

    See the Oracle Technology Network Web site, http://www.oracle.com/technology/documentation/index.html

    Search for Configuring JDBC Multi Data sources.

     
    JBoss Application Server
    jdbc:oracle:@
    (DESCRIPTION =(load_balance=yes)
    (ADDRESS_LIST= (ADDRESS = 
    (PROTOCOL = TCP)
    (HOST = rac node 1)
    (PORT = 1521))(ADDRESS = 
    (PROTOCOL = TCP)
    (HOST = rac node 2)
    (PORT = 1521)))
    (CONNECT_DATA =(SERVICE_NAME = 
    DB service name)
    (failover_mode = (type=select)
    (method=basic)
    (retries=retry number)
    (delay=delay value))))
    jdbc:oracle:@
    (DESCRIPTION =(load_balance=yes)
    (ADDRESS_LIST=
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = testrac1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = testrac2)(PORT = 1521)))
    (CONNECT_DATA =(SERVICE_NAME = 
    testracdb)(failover_mode = 
    (type=select)(method=basic)
    (retries=32)(delay=4))))
  6. Optional: (WebSphere and WebLogic only) Click Test Database Connection to test the connection to the database by using the database user name, database server name, database name, port number, and password that you provided. The test does not create the data sources.

    (WebLogic only) If the test fails, complete the following substeps to reset the data source parameters before attempting the database connection test again:

    1. Start the WebLogic Server administrative console.
    2. Click Lock & Edit > Services > JDBC Data Sources.
    3. Select the check box for the data source and then click Delete.
    4. Click Release.
  7. Select File > Save to save your changes.
  8. Ensure that the task is enabled. When the task is disabled, the task name includes the text (disabled). To enable the task, select Configure GCD JDBC Data Sources (disabled) in the profile pane, and then either right-click and choose Enable Selected Task from the context menu, or click the Enable the Selected Task icon in the task toolbar.
  9. Apply the JDBC property settings by right-clicking Configure GCD JDBC Data Sources in the profile pane, and selecting Run Task. Running the configuration task can take several minutes. The task execution status messages are displayed in the console pane below the JDBC properties.
  10. Close the Configure GCD JDBC Data Sources task pane. In this step, you created the GCD data sources. You create the initial object store data sources later in the configuration process.


Feedback

Last updated: November 2010


© Copyright IBM Corporation 2010.
This information center is powered by Eclipse technology. (http://www.eclipse.org)