Defining a Database Connection Pool Through the Application Server

If you are using a database Adapter, you configure the database connection pool in the database external system in the Environment and do not need to perform this step. If the application is running on GlassFish Application Server and is not using a database Adapter to connect to the database, you need to create two JDBC connection pools and resources using the Admin Console.

To set up the connection pools, you create the connection pools and then define a JDBC resource for each pool. This section provides general instructions for setting up the connection pools. For more information about the procedures in this section, see the online help provided with the GlassFish Admin Console.

Perform the following steps to define database connectivity through the application server:

• Step 1: Add the Oracle Driver to the Application Server

• Step 2: Create the JDBC Connection Pools

• Step 3: Create the JDBC Resources

Step 1: Add the Oracle Driver to the Application Server

If you are using an Oracle database, you need to manually install or copy the database driver to the application server environment. If you are using a SQL Server database, you can skip this step.

You can either install the Oracle driver on the application server or copy the ojdbc14.jar file from your Oracle client installation (Oracle_client\jdbc\lib) to app_server_home\lib. To install the driver, see the documentation for the GlassFish Application Server.

Once the driver is installed or copied, continue to Step 2: Create the JDBC Connection Pools.

Step 2: Create the JDBC Connection Pools

The JDBC connection pools provide connections for the master index database. Before proceeding, make sure you have the relevant information about the master index database (such as the database name, URL, and administrator login credentials).

To Create the JDBC Connection Pools

Before You Begin

If you are using an Oracle database, be sure to add the database driver to the application server environment, as described in Step 1: Add the Oracle Driver to the Application Server.

1. Log in to the GlassFish Application Server 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 appropriate Java class.

   ---

   Note - You can use either javax.sql.DataSource or javax.sql.ConnectionPoolDataSource.

   ---

6. In the Database Vendor field, select the database platform of the master index database.
7. Click Next.
8. In the DataSource Classname field, enter the Java class for the data source, or accept the default value if it is provided.
9. Modify the Pool Settings properties according to your business practices.
10. Modify the Connection Validation properties according to your business practices.
11. Modify the Transaction properties if necessary.
12. In the additional properties section, enter the values for the master index 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:

      • For Oracle, jdbc:oracle:thin:@host:port:database_name.

      • For SQL Server, jdbc:sqlserver://server:port;databaseName=database

    • user – The login ID for the user you created in Step 2: Create a Master Index Database and User.

    • password – The password for the above user.

    • ImplicitCachingEnabled – An indicator of whether implicit statement caching is enabled. Set this property to true.

    • MaxStatements – The maximum number of statements in the cache. Set this property to 1000.

13. Repeat the above steps to create a connection pool with a different name for the sequence manager.
14. Continue to Step 3: Create the JDBC Resources.

Step 3: Create the JDBC Resources

A JDBC resource (also known as a data source) gives the master index application the ability to connect to the database. You need to create one for each connection pool created earlier.

To Create a JDBC Resource

Before You Begin

Create the JDBC connection pool, as described in Step 2: Create the JDBC Connection Pools.

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.

   The name must be in the form jdbc/application_nameDataSource, where application_name is the name of the master index application. For example, jdbc/PersonDataSource.

4. In the Pool Name field, enter the name of the first JDBC connection pool you created in Step 2: Create the JDBC Connection Pools.
5. (Optional) In the Description field, enter a brief description of the resource.
6. In the Status field, select the Enabled check box.
7. Click OK.
8. Repeat the above steps to create another JDBC resource for the sequence manager using these guidelines:

   • For the connection pool, select the second connection pool you created in Step 2: Create the JDBC Connection Pools.

   • The name of the resource must be in the form jdbc/application_nameSequenceDataSource, where application_name is the name of the master index application. For example, jdbc/PersonSequenceDataSource.