To Create the Non-XA Connection Pool

1. Log in to the Sun Java System Application Server Admin Console.

2. Expand the Resources node and the JDBC node, and select the Connection Pools node.

3. Click New.

   The New JDBC Connection Pool wizard appears.

4. In step 1 of the wizard, do the following:

   1. In the Name field, specify a name for the non-XA connection pool (for example, iepseOraclePoolNonXA).

   2. In the Resource Type drop-down menu, select javax.sql.DataSource.

   3. In the Database Vendor drop-down menu, select Oracle.

   4. Click Next.

5. In step 2 of the wizard, do the following:

   1. Scroll down to the Additional Properties table.

   2. In the User row, enter the user name of the IEP user (for example, IEPSEDB).

   3. In the Password row, enter the password of the IEP user (for example, IEPSEDB).

   4. In the URL row, enter the string for connecting to the database (for example, jdbc:oracle:thin:@myserver:1521:orcl).

6. Click Finish.

   The connection pool is created.

7. Click the connection pool that you just created.

   The Edit Connection Pool page appears.

8. Click Ping.

   The Admin Console attempts to connect to the database.

   If the connection does not succeed, check to see whether the database is running. Another possible cause is that the URL string is incorrect.