Legacy platform

WebSphere connection pool

Creating database connections are very expensive operations.

To enable connection pooling, you need to:

  • Define a data source to Sterling™ Order Management System Software.
  • The J2c settings for the deployed application must be set to "Component Managed Auth" to allow the Sterling Application access to these settings.
  • Define a connection pool in WebSphere® and then associate the connection pool to the datasource name in Sterling Order Management System Software.
  • IBM® recommends that data sources do not participate in container managed persistence (CMP). For configuration, go to the data sources setup in WebSphere and clear the Use this data source in container managed persistence (CMP) field while creating the data source.