To Create the Non-XA Connection Pool

1. Log in to the GlassFish Admin Console.

2. In the left navigation panel, expand Resources and JDBC, and then select Connection Pools.

3. Click New.

   The New JDBC Connection Pool page appears.

4. Do the following:

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

   2. In the Resource Type field, select javax.sql.DataSource or javax.sql.ConnectionPoolDataSource.

   3. In the Database Vendor field, select MySQL.

   4. Click Next.

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 database connectivity properties, such as the URL string.