Connection pool custom properties
defaultConnectionTypeOverride
You can use the defaultConnectionTypeOverride connection pool custom property for a particular connection factory or data source to control connection sharing.
The defaultConnectionTypeOverride property changes the default sharing value for a connection pool. This property enables you to control connection sharing for direct look-ups. If resource references are configured for a data source or connection factory they take precedence over this property and the resource reference settings are used. For example, if an application is doing direct look-ups, and you do not want shared connections, set this property to unshared.
Information | Value |
---|---|
Data Type | String |
Value | unshared, shared |
failureNotificationActionCode
Information | Value |
---|---|
Data Type | Integer |
Value | 1, 2, 3 |
- 1 = A BBOJ0130I message that is output to hardcopy indicates that this resource became unavailable. When the resource becomes available, a BBOJ0131I message is output to hardcopy indicating that the resource is once again available. No further automated action is taken. Action code 1 is designed to provide a notification to WebSphere® Application Server administrators so that manual or automated mitigation actions can be configured outside of the application server.
- 2 = A pause listeners command is issued to the server, preventing the server from receiving new incoming work. When the resource becomes available, a resume listeners command is issued to allow the server to once again receive incoming work. When combined with a front end router that supports high availability, such as a proxy server or an on-demand router, work for this server is routed to other servers in the cluster.
- 3 = All applications with locally installed modules that use this resource are stopped on this server. When the resource becomes available, these applications are restarted. The application is stopped only on the server that experienced the resource failure, therefore, if the application is installed in a cluster it remains started on other servers in the cluster.
failureThreshold
Information | Value |
---|---|
Data Type | Integer |
Value | > 0 |
globalConnectionTypeOverride
You can use the globalConnectionTypeOverride connection pool custom property to globally control connection sharing for a particular connection factory or data source.
The value specified for the globalConnectionTypeOverride custom property takes precedence over all of the other connection sharing settings. For example, if you set this property to unshared, all connection requests are unshared for both direct look-ups and resource reference lookups.
This property provides you with a quick way to test the consequences of moving all connections for a particular data source or connection factory to unshared or shared without changing the resource reference settings.
- To set this property correctly, follow these navigation details using the administrative
console.
Click Data sources > Select the data source > Under Additional Properties, click Connection pool properties > Under Additional Properties, click Connection pool custom properties > click New to add globalConnectionTypeOverride > OR click > globalConnectionTypeOverride to update its current value as appropriate.
> - This property must be set in the Connection pool custom properties and NOT the general Custom properties on the data source.
- If you specify values for both the defaultConnectionTypeOverride and the globalConnectionTypeOverride properties, only the value that is specified for the globalConnectionTypeOverride property is used to determine the connection sharing type.
Information | Value |
---|---|
Data Type | String |
Value | unshared, shared |
maxNumberOfMCsAllowableInThread
The maxNumberOfMCsAllowableInThread property assists in detecting higher than expected usage of a number of managed connections on a thread.
Information | Value |
---|---|
Data Type | Integer |
Value | 1-30 |
For more information on how these properties are used, see the topic, Tuning connection pools.