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 Sun Java System 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 (Repository).

    • 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.