Configuring data source connection pooling for non-sharded installations

About this task

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


  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 file in the INSTALL\properties folder.
  4. In the, 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 file and run
  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.


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.