Each cell in the i2b2 hive has a DB_LOOKUP table that contains the information it needs to connect to the appropriate database for that cell and project. Currently, there is no easy way to view or edit the information in these tables. This enhancement will allow administrators to view and edit the database settings defined for each cell.

As part of this enhancement, 3 new pages have been created. These pages will contain the following fields:

1. Name
2. DB Schema
3. JNDI Data Source
4. DB Server
5. Project Path
6. Owner ID
7. Tooltip
8. Comment

The fields on the pages are equivalent to the following columns in the DB_LOOKUP tables:

1. Name = C_DB_NICENAME
2. DB Schema = C_DB_FULLSCHEMA
3. JNDI Data Source = C_DB_DATASOURCE
4. DB Server = C_DB_SERVERTYPE
5. Project Path = C_PROJECT_PATH
6. Owner ID = C_OWNER_ID
7. Tooltip = C_DB_TOOLTIP
8. Comment = C_COMMENT


3 New Pages and Expected Behavior

1. DB Lookup List
     * This page displays the settings for all the databases setup for that cell.
     * This is a view only page. Information cannot be edited
     * Button: Add New DB Lookup
             Behavior: displays the DB Lookup Add New page


2. DB Lookup Add New
     * This page is used to add a new entry into the DB_LOOKUP table for that cell.
     * It is accessed by clicking on the Add New DBLookup button.
     * Button: Save
             Behavior:
                             - Saves the information into the appropriate DB_LOOKUP table.
                             - Closes the page and returns to the DB Lookup List.
     * Button: Cancel
              Behavior:
                             - Does NOT save the information into the DB_LOOKUP table.
                             - Closes the page and returns to the DB Lookup List.


2. DB Lookup Details
     * This page displays the details for a single database connection.
     * The data on this page can be edited for all pages EXCEPT for the Project Path.
     * All edits will be saved to the appropriate db_lookup table.
     * Button: Save
             Behavior:
                             - Saves the edits into the appropriate DB_LOOKUP table.
                             - Closes the page and returns to the DB Lookup List.
     * Button: Cancel
              Behavior:
                             - Does NOT save the information into the DB_LOOKUP table.
                             - Closes the page and returns to the DB Lookup List.
     * Button: Delete
              Behavior:
                             - Clicking on it will display a new dialog window asking if your are sure you want to delete the DB Lookup.
                                           ~ Cancel will close the dialog window and return to the DB Lookup Details page
                                           ~ Ok will continue with the deletion process in which the database connection will be removed from the database lookup table
                             - The page will close and return to the DB Lookup List page.

WARNING: The Delete button will remove the database connection settings from the DB_LOOKUP table so you need to make sure you are deleting the correct one.
 

New Services
Several new services were developed in order to accommodate this new feature.

     * getALLDBLookup: retrieves all the database configurations for that cell
     * setDBLookup: saves new database entries into the appropriate DB_LOOKUP table
     * getDBLookup: retrieves the configuration of a single database connection
     * deleteDBLookup: deletes the database configuration from the appropriate DB_LOOKUP table

Information about these new services can be found in CORE-218.