Connection pool custom properties

You can use the custom properties page to define the following 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

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.

Important:
  • To set this property correctly, follow these navigation details using the administrative console.

    Click Resources > JDBC > 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.