To Create the JDBC Connection Pools

The following procedures outlines the steps to create a connection pool. The configuration information for each connection pool you need to create is listed after the procedure.

1. Log in to the GlassFish Admin Console.

   You can access the console from the Services window in NetBeans.

2. In the left portion of the Admin Console, expand Resources, expand JDBC, and then select Connection Pools.

3. On the Create Connection Pool page, click New.

4. In the Name field, enter a name for the connection pool.

5. In the Resource Type field, select the Java class for the type of transactions being processed.

   • javax.sql.DataSource – For local transactions only.

   • javax.sql.XADataSource – For transactions that are distributed, either within the application or across applications.

   • javax.sql.ConnectionPoolDataSource – For local transactions only. This class provides possible performance improvements.

6. In the Database Vendor field, select MySQL.

7. Click Next.

8. In the DataSource Classname field, accept the default class or enter a new one to use.

9. Modify the Pool Settings, Connection Validation, and Transaction properties according to your business practices.

10. In the additional properties section, enter the values for the database. Be sure to enter the following information at a minimum (you might need to create some of these properties).

    • URL – The URL that points to the database. The syntax of the URL is jdbc:mysql://server:port/database_name.

    • portNumber – The port number of the database. For MySQL, the default port is 3306.

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

    • user – The login ID for database user.

    • password – The password for the above user.

    • databaseName – The name of the database schema.

    Create the connection pools listed below. The database vendor for all pools is MySQL. The port number and server name depend on your MySQL environment, and the URL you enter depends on these values. The user and password properties are the ones you defined for each database schema in Creating the PIX/PDQ and ATNA Databases.

    ---

    Note –

    You do not have to use the connection pool names given here. These are the default names given by the installer.

    ---

    Connection Pool Name	Resource Type	Database Name	Purpose
    cpPatientXA	The type corresponding to the type of transaction processed by the master index. The default is javax.sql.XADataSource.	midm	Connecting to the Master Index database.
    cpPatientSequenceXA	The same as above.	midm	Connecting to the Master Index sequence table.
    cpPIXDomainLU	javax.sql.DataSource	midm	Connecting to the Domain Lookup tables.
    MyArrdbPool	javax.sql.DataSource	arrdb	Connecting to the ATNA database.
    pixpdqMonitorPool	javax.sql.XADatabase	pixpdqCheckpoint	This is used by the PIX Console.