Configuring O2R

In this section, we discuss how to map the Object to Source (also known as O2R). In O2R source is a java object and destination is a table.

Nodes Configuration_Figure 40: Configuring O2R node

Click on the O2R node in the Nodes Area and drop it on the Work Area. Now click on the O2R node in the Work Area to invoke a dialog box that lists existing O2R files.

Nodes Configuration_Figure 41:

If the user needs to use the existing O2R file then select the required file from the list and click OK. The following screen appears:

Nodes Configuration_Figure 42:

If the user needs to create a new O2R node then click Cancel to display a Name Popup.

Nodes Configuration_Figure 43:

Enter the name for the node and click OK. If the user does not enter the name or Cancel is clicked then the default name is given to the node. The O2R frame appears.

The O2R Configuration Dialog consists of three panes (the third pane will be displayed later). The left pane is used for building source class tree. The middle pane is used for building destination table structure. The last pane is the screen for configuring destination and for mapping destination columns. This displays the O2R configuring frame. This screen will be visible on adding a new destination node in the destination tree.

Nodes Configuration_Figure 44: O2R Mapping

The following are steps to be followed to configure O2R node:

1. Click on O2R node in the work area. The O2R frame appears.
2. Right-click the Object Source root node. A pop-up menu is displayed containing menu items such as:

• Add Container Class: This option is used to add classes to retrieve data. Refer to the section Adding Container Class.
• Reload: This option reloads the current container class. Reload is used when some changes are made to the class structure after loading the class. After reload, the new class gets loaded at the source.
• Find: Right-click on the select node in the O2R frame and click Find. Tree Find Dialog box is displayed (refer Nodes Configuration_Figure 29) where the value to be searched in the select or cursor tree is entered. The value can be searched either up or down the tree structure.
• Delete Node: Right-click on the select node in O2R frame and click Delete Node. Delete Confirmation dialog box is displayed. Click Yes to delete the node or click No to cancel the action.

Note: If there are two selects or cursors adjacent to each other then the node on which the focus is, gets deleted. If parent select or cursor, with child selects or cursors attached to it, is deleted, all the child selects or cursors are deleted.