Creating database connections are very expensive
operations. For performance, Sterling Selling and
Fulfillment Foundation takes
advantage of the WebSphere® connection
pool.
To enable connection pooling, you need to:
- Define a data source to Sterling Selling and
Fulfillment Foundation.
- 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 Selling and
Fulfillment Foundation.
- 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.