Use Database UI Specification

The motivation is described in Resource Reference Binding document.
Briefly, we would like a user to provide a data source reference name in addition to a data source itself. This reference name is used in the source code and in standard deployment descriptor (DD). The reference name is bound to a data source in a server-specific DD. For this purpose, we introduce a new dialog allowing to select the reference name. User may also create a new reference name.

Use Case

User wants to work with database.

Basic Flow

1. User executes "Use Database" action.
2. User selects one from the existing reference names. (A2)
3. User hits 'OK' button. The reference name is used in the generated Java code and in the standard DD.

+-----------------------------------------------------------------------------+
| Choose Database                                                             |
+-----------------------------------------------------------------------------+
|                                                                             |
| Reference:     |_SampleReference__[<JDBC connection URL>]___|_v_| | Add...| |
|                                                                             |
| + Service Locator Strategy------------------------------------------------+ |
| |   (o) Generate Inline Lookup Code                                       | |
| |   ( ) Existing Class |_______________________________________| |Browse| | |
| +-------------------------------------------------------------------------+ |
|                                                                             |
|                                                  | OK | | Cancel | | Help | |
+-----------------------------------------------------------------------------+

Alternative Flow A2

• A2. If there is no suitable reference name, user may create a new one.
  • A2.1. User hits 'Add...' button besides the 'Reference' combobox. The 'Add Data Source Reference' dialog pops up.
  • A2.2. User provides a new unique reference name.
  • A2.3. User selects one from the existing data sources or creates a new one (user may require to copy the server data source to the project).
  • A2.4. User hits 'OK' button. The flow returns to the step 2, the created reference is selected.

+----------------------------------------------------------------------+
| Add Data Source Reference                                                        |
+----------------------------------------------------------------------+
|                                                                      |
| Reference Name:           |______________________________|           |
|                                                                      |
| (o) Project Data Sources: |_jdbc/SampleProjectDS_____|_v_| | Add...| |
|                                                                      |
| ( ) Server Data Sources:  |_jdbc/SampleServerDS______|_v_|           |
|                                                                      |
|        [ ] Copy Selected Data Source To Project                      |
|                                                                      |
|                                           | OK | | Cancel | | Help | |
+----------------------------------------------------------------------+

The rest of the flow is left as it currently is...

If there is no suitable data source...

If there is no suitable database connection...

If there is no suitable database driver...

Attachments

new_conn.PNG		17856 bytes
new_conn.png		17856 bytes
new_driver.PNG		14962 bytes
new_driver.png		14962 bytes
new_ds.PNG		12479 bytes
new_ds.png		12479 bytes