#### To edit a connector connection pool

1. In the tree component, expand the Resources node and then the Connectors node.

2. Expand the Connector Connection Pools node.

3. Select the connector connection pool you want to edit.

4. On the Edit Connector Connection Pool page, you can change the settings of this connection pool. See the following table.

   Parameter | Description
   Initial and Minimum Pool Size | The minimum number of connections in the pool. This value also determines the number of connections placed in the pool when the pool is first created or when application server starts.
   Maximum Pool Size | The maximum number of connections in the pool.
   Pool Resize Quantity | When the pool shrinks toward the minimum pool size it is resized in batches. This value determines the number of connections in the batch. Making this value too large will delay connection recycling; making it too small will be less efficient.
   Idle Timeout | The maximum time in seconds that a connection can remain idle in the pool. After this time expires, the connection will be removed from the pool.
   Max Wait Time | The amount of time the application that has requested a connection will wait before getting a connection timeout. Because the default wait time is long, the application might appear to hang indefinitely.
   On Any Failure | If you select the checkbox labelled Close All Connections, if a single connection fails, then the application server will close all connections in the pool and then reestablish them. If you do not select the checkbox, then individual connections will be reestablished only when they are used.

   Transaction Support

   Use the Transaction Support list to select the type of transaction support for the connection pool. The chosen transaction support overrides the transaction support attribute in the resource adapter associated with this connection pool in a downward compatible way. In other words, it can support a lower transaction level than that specified in the resource adapter or the same transaction level as that specified in resource adapter, but it cannot specify a higher level.The transaction support options include the following. The None selection from the Transaction Support menu indicates that the resource adapter does not support resource manager local or JTA transactions and does not implement XAResource or LocalTransaction interfaces. For JAXR resource adapters, you need to choose None from the Transaction Support menu. JAXR resource adapters do not support local or JTA transactions. Local transaction support means that the resource adapter supports local transactions by implementing the LocalTransaction interface. Local transactions are managed internal to a resource manager and involve no external transaction managers. XA transaction support means that the resource adapter supports resource manager local and JTA transactions by implementing the LocalTransaction and XAResourceinterfaces. XA transactions are controlled and coordinated by a transaction manager external to a resource manager. Local transactions are managed internal to a resource manager and involve no external transaction managers.

   Connection Validation |

5. Click the Advanced tab to configure the advanced settings of the connection pool. See the following table:

   Parameter | Description

   Validate Atmost Once

   The validate-atmost-once-period-in-seconds attribute defines the limit that is considered as acceptable time period in which connection validation is not required. A connection is validated only if it has not been validated before in the last specified validate-atmost-once-period-in-seconds seconds. If a free connection is returned from pool to application. The isconnectvalidatereq attribute enforces connection validation, before the connection is returned to the application. The validation is a costly operation to perform for each connection requested by the applications in the pool. This attribute enables you to reduce the frequency of connection validation without having to completely switch off connection validations. A recently validated connection can safely be given to requesting application without validation. By default, this attribute is set to 0.

   Leak Timeout

   The connection leak tracing feature is enabled using the connection-leak-timeout-in-seconds attribute. By default, this attribute is set to zero and connection leak tracing is switched off by default. When this attribute is set to a positive non-zero value, connection leak tracing is enabled. If this attribute is enabled, the connection pool provides data about application, which is leaking the connections. An application is a leaking connection if it acquires a connection and does not close it within the specified time period. All leak tracing logs are present in server logs. You can search through the logs and identify the connection leak traces for a pool.

   Leak Reclaim | The connection-leak-reclaim attribute reclaims a leaking connection. By default, this attribute is set to false, which implies no connection reclaim. If this attribute is enabled, connection is reusable (put back to pool) after connection-leak-timeout-in-seconds occurs.

   Creation Retry Attempts

   The connection-creation-retry-attempts attribute enables the connection retry feature can be enabled at the connection pool level. By default, this attribute is set to zero and connection retry is turned off. When set to a positive non-zero value, the connection creation does not abort if the first attempt fails. The connection creation is retried for finite number of times, as defined by this attribute. If all these attempts fail, an exception notifies the application about connection creation failure.

   Retry Interval | The connection-creation-retry-interval-in-seconds attribute specifies the interval of connection creation retrial. By default, this attribute is set to 10 seconds.
   Lazy Connection Enlistment | The default value of this attribute is false. Use this attribute instead of the LazyConnectionEnlistment property
   Lazy Association | The default value of this attribute is false. Use this attribute instead of the LazyConnection Association property
   Associate with Thread | The default value of this attribute is false. Use this attribute instead of the AssociateWithThread property
   Match Connections | The default value of this attribute is false. Use this attribute instead of the MatchConnections property

6. In the Properties tabbed pane, specify name-value pairs.

   The properties specified depend on the resource adapter used by this pool. The name-value pairs specified by the deployer using this table can be used to override the default values for the properties defined by the resource-adapter vendor.

7. On the Security Maps tabbed pane, create, modify, or delete a security map for the connection pool. For more details on managing security maps, see Connector Connection Pool Security Maps

8. Click Save.

##### See Also

- To create a connector connection pool

- To delete a connector connection pool

#### Managing Security Maps

You can create, edit, and delete security maps associated with connector connection pools.