To create a JDBC connection pool

A JDBC connection pool is a group of reusable connections for a particular database. When creating the pool with the Admin Console, the Administrator is actually defining the aspects of a connection to a specific database.

Before You Begin

Before creating the pool, you must first install and integrate the JDBC driver. See To integrate a JDBC driver.

When building the Create Connection Pool pages, certain data specific to the JDBC driver and the database vendor must be entered. Before proceeding, gather the following information:

• Database vendor name

• Resource type, such as javax.sql.DataSource (local transactions only) javax.sql.XADataSource (global transactions)

• Data source class name

• Required properties, such as the database name (URL), user name, and password

1. In the Admin Console’s tree view (left pane), expand the Resources node.

2. Under Resources, expand the JDBC node.

3. Under JDBC, select the Connection Pools node.

4. On the Connection Pools page, click New.

5. On the first Create Connection Pool page, specify the following general settings:

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

      Specify this name when creating a JDBC resource.

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

   3. Select an entry from the Database Vendor combo box.

6. Click Next.

7. On the second Create Connection Pool page, specify the value for the DataSource Class Name field.

   If the JDBC driver has a DataSource class for the resource type and database vendor specified in the previous page, then the value of the DataSource Class Name field is provided.

8. Click Next.

9. On the third and last Create 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, Connection Validation, and Transaction Isolation sections, retain the default values.

      It is most convenient to change these settings at a later time. See To edit a JDBC connection pool.

   3. In the Additional Properties table, add the required properties, such as database name (URL), user name, and password.

10. Click Finish.

Equivalent asadmin command

create-jdbc-connection-pool