Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Administration Guide

- Previous: About Connectors
- Next: Admin Console Tasks for Connector Resources

# Admin Console Tasks for Connector Connection Pools

- To Set Up EIS Access

- To create a connector connection pool

- To edit a connector connection pool

- To delete a connector connection pool

## To Set Up EIS Access

1. Deploy (install) a connector. See To deploy a connector module.

2. Create a connection pool for the connector. See To create a connector connection pool.

3. Create a connector resource that is associated with the connection pool. See To create a connector resource.

## To create a connector connection pool

##### Before You Begin

Before creating the pool, deploy the connector module (resource adapter) associated with the pool. The values that are specified for the new pool depend on the connector module that is deployed.

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

2. Select the Connector Connection Pools node.

3. On the Connector Connection Pools page, click New.

4. On the first Create Connector Connection Pool page, specify the following settings:

   1. In the Name field, enter a logical name for the pool.

      Specify this name when creating a connector resource.

   2. Select an entry from the Resource Adapter combo box.

      The combo box displays a list of deployed resource adapters (connector modules).

5. Click Next.

6. On the second Create Connector Connection Pool page, select a value from the Connection Definition combo box.

   The choices in the combo box depend on the resource adapter. Typically, a type of `ConnectionFactory` is specified, a factory instance to get a connection to the EIS.

7. Click Next.

8. On the third and last Create Connector Connection Pool page, perform these tasks:

   1. In the General Settings section verify that the values are correct.

   2. For the fields in the Pool Settings section, the default values can be retained.

      These settings can be changed at a later time. See Editing a Connector Connection Pool.

   3. In the Additional Properties table, add any required properties.

      In the previous Create Connector Connection Pool page, you selected a class in the Connection Definition combo box. If this class is in the server’s classpath, then the Additional Properties table displays default properties.

9. Click Finish.

##### Equivalent asadmin command

`create-connector-connection-pool`

## 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 node for the pool you want to edit.

4. On the Edit Connector Connection Pool page, you can change settings that control the number of connections in the 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. 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 `XAResource` interfaces. 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.

5. In the Additional Properties table, 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.

6. On the Security Maps tabbed pane, create or modify a security map for the connection pool.

   See About Security Maps for information on how to create a security map.

7. Click Save.

## To delete a connector connection pool

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

2. Select the Connector Connection Pools node.

3. On the Connector Connection Pools page, select the checkbox for the pool to be deleted.

4. Click Delete.

##### Equivalent asadmin command

`delete-connector-connection-pool`

- Previous: About Connectors
- Next: Admin Console Tasks for Connector Resources

- © 2010, Oracle Corporation and/or its affiliates