Configuring the database pool and security realm for the connection manager and the manager on WebSphere Application Server Community Edition

The database pool for the connection manager and the manager must be created in a supported database. The database pool must be in a different schema than the schema used by any Optim™ directory.

The version of WebSphere® Application Server Community Edition that is delivered with InfoSphere Optim web applications is available only in English. You must configure this version of WebSphere Application Server Community Edition by using an English user interface. However, when you use the connection manager or the manager, the language setting of the browser determines the language of the user interface.

Use the Administrative Console of WebSphere Application Server Community Edition to configure the database pool. The default location of the Administrative Console is http://hostname:8080/console, where hostname is the host name of the computer on which WebSphere Application Server Community Edition is installed.

To configure the database pool and security realm for the connection manager and the manager on WebSphere Application Server Community Edition:

  1. Open the file shared_installation_directory/ocm/app/nex.configure.ocm.build.properties in a text editor, where shared_installation_directory is the installation directory that you specified for the IBM Optim Shared package group. For example, the default location for the file on Microsoft Windows is C:\IBM\InfoSphere\Optim\shared\ocm\app\nex.configure.ocm.build.properties.
  2. Edit the nex.configure.ocm.build.properties file as indicated by the comments in the file.
  3. Create the configuration files by running the appropriate batch file or shell script:
    • On Microsoft Windows computers, run shared_installation_directory/ocm/app/createOCMFiles.bat.
    • On Linux or UNIX computers, run shared_installation_directory/ocm/app/createOCMFiles.sh.
    The batch file or shell script creates the following configuration files in the shared_installation_directory/ocm/app/ folder, where group is the group that was specified in the properties file.
    • group-ocm-database-pool.xml
    • group-ocm-security-realm.xml
  4. In the Administrative Console, under Applications, click Deployer.
  5. Enter the location of the appropriate tranql connector into Archive, or use Browse to browse to the tranql connector. Tranql connectors are located in folders under the shared_installation_directory/WebSphere/AppServerCommunityEdition/repository/org/tranql folder.
    • For Oracle databases or Microsoft SQL Server databases, specify /tranql-connector-ra/1.7/tranql-connector-ra-1.7.rar.
    • For DB2® databases, specify /tranql-connector-db2-xa/1.7/tranql-connector-db2-xa-1.7.rar.
  6. Enter the location of the group-ocm-database-pool.xml file into Plan, or use Browse to browse to the configuration file, and then click Install.
  7. Enter the location of the group-ocm-security-realm.xml file into Plan, or use Browse to browse to the configuration file, and then click Install.


Feedback