To Create the XA Connection Pool

1. In the left navigation panel of the Admin Console, expand Resources and JDBC, and then select Connection Pools.

2. Click New.

   The New JDBC Connection Pool page appears.

3. Do the following:

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

   2. In the Resource Type field, select javax.sql.XADataSource.

   3. In the Database Vendor field, select MySQL.

   4. Click Next.

4. Scroll down to the Connection Validation section, and select the Enabled check box that appears to the right of the Allow Non Component Callers label.

5. Scroll down to the Additional Properties table, and enter the following values:

   • port – The port number for the database. By default, MySQL uses 3306.

   • databaseName – The name of the database schema.

   • serverName – The name of the server on which the database is located.

   • user – The login ID of the IEP user (for example, IEPSEDB).

   • password – The password of the IEP user (for example, IEPSEDB).

   • url – The string for connecting to the database (for example, jdbc:mysql://myserver:3306/IEPSEDB).

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, and verify the connectivity parameters, such as the URL string.