FileNet P8 Content Engine, Version 5.0.+              

Creating the initial object store data sources by using the graphical user interface

You must create the JDBC data sources for each object store that Content Engine uses. Content Engine uses the data source information to connect to and update the object store database. By default, each profile includes a task for creating the data sources for a single object store.

Be sure that you have available the Installation and Upgrade Worksheet that was completed during your planning activities.

Tip: For more information on the properties and values you set in Configuration Manager, roll your mouse over the property name to view the hover help for the property.
  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 for this task, filter by CM: Configure Object Store JDBC Data Sources (object store 1) in the Installation or Configuration Program column.
  2. Start or stop the application server, 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.
    Oracle WebLogic Server Start the application server if it is not already running.
  3. If your configuration profile is not open in Configuration Manager, open it by selecting File > Open and navigating to your profilename.cfgp file.
  4. Right-click Configure Object Store JDBC Data Sources in the profile pane, and select Edit Selected Task.
  5. Enter the property values for your data sources by using the values in your installation worksheet.
  6. High availability In highly available environments, provide the following additional information for the object store data sources:
    Database server name
    If you are using a highly available database cluster, use the virtual name of the cluster.
    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))))
  7. Select File > Save to save your changes.
  8. 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.
  9. Ensure that the task is enabled. When the task is disabled, the task name includes the text (disabled). To enable the task, right-click Configure Object Store JDBC Data Sources (disabled) in the profile pane, and choose Enable Selected Task from the context menu.
  10. Apply the JDBC property settings by right-clicking Configure Object Store 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 bootstrap properties.
  11. (JBoss only) Start the application server.


Feedback

Last updated: November 2010


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