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 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
In the Admin Console’s tree view (left pane), expand the Resources node.
Under Resources, expand the JDBC node.
Under JDBC, select the Connection Pools node.
On the Connection Pools page, click New.
On the first Create Connection Pool page, specify the following general settings:
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.
On the third and last Create Connection Pool page, perform these tasks:
In the General Settings section, verify that the values are correct.
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.
In the Additional Properties table, add the required properties, such as database name (URL), user name, and password.