Legacy platform

Configuring data source connection pooling for non-sharded installations

About this task

To configure a datasource and connection pool for an instance of Sterling™ Call Center

Procedure

  1. Create the connection pool and datasource on your application server. See your application server documentation for specific configuration and operating instructions.
  2. Install Sterling Call Center
  3. In a text editor, open (or create) the customer_overrides.properties file in the INSTALL\properties folder.
  4. In the customer_overrides.properties, add the line for your database from the following list:
    • For Db2®, add jdbcService.db2Pool.datasource=datasourceName
    • For Oracle, add jdbcService.oraclePool.datasource=datasourceName

      where datasourceName is the logical name of the external datasource.

  5. Save the customer_overrides.properties file and run setupfiles.sh/cmd.
  6. Build and deploy the EAR.
  7. Update the application server configuration to use -Dvendor=appserver

    – where the value of appserver is weblogic or websphere.

  8. Start the application server.

Results

For more information about -Dvendor and other properties in the application server startup scripts, see Configuring an Oracle WebLogic application server - overview or Configuring a WebSphere application server - overview.