Configuring data source connection pooling for non-sharded installations

Edit online

About this task

To configure a datasource and connection pool for an instance of Sterling Order Management System Software

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 Order Management System Software
  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, jboss, 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, Configuring a WebSphere application server - overview, or Configuring a JBoss application server.
Note: For more information on JBoss deprecation, see Deprecated components in Sterling Order Management System Software.