Creating the JDBC Connection Pools and Resources

The PIX/PDQ Manager maintains connections to several databases to comply with IHE requirements for monitoring, audit logging, and master data management. If you did not have the installer create the connection pools and resources, you can create them manually or rerun the installer as mentioned earlier.

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.

To Create the JDBC Resources

The following procedures outlines the steps to create a JDBC resource. The configuration information for each resource you need to create is located after the procedure.

1. In the left portion of the Admin Console, expand Resources, expand JDBC, and then select JDBC Resources.

2. On the Create JDBC Resource page, click New.

3. In the JNDI Name field, enter a unique name for the JDBC resource.

4. In the Pool Name field, select the name of a JDBC connection pool.

5. In the Status field select the Enabled check box.

6. Click OK.

   Create the JDBC Resources listed below, which correspond to the connection pools you created earlier. Note that several of the JNDI names are case-sensitive.

   JNDI Name	Pool Name
   jdbc/PatientDataSource	cpPatientXA
   jdbc/PatientSequenceDataSource	cpPatientSequenceXA
   jdbc/PIXDomainLUDataSource	cpPIXDomainLU
   jdbc/arrdb	MyArrdbPool
   jdbc/SHCPMonitorDB	pixpdqMonitorPool