Creating a JDBC Connection Pool and JDBC Resource Using the Admin Console

1. Copy the JDBC driver for database connectivity to as-install/domains/domain_name/lib/ext. Alternatively, add the path to the JDBC driver to classpath-prefix and restart the server.

2. In the Admin Console, click Create JDBC Connection Pool in the Common Tasks page.

3. Provide a name for the connection pool, select the resource type, select the database vendor. Click Next.

4. The Admin Console lists the default pool settings and the properties of datasource class provided by the vendor.

5. Click the Ping button to test the JDBC connection pool.

6. In the left-hand pane of the Admin Console, click Resources > JDBC Resources.

7. Click New.

8. In the New JDBC Resource page, provide the JNDI name for the resource and the JDBC comnnection pool with which the JDBC resource needs to be associated.

9. Click OK.