WebSphere Adapter for JDBC

Selecting business objects and services

You will run a query to find the database objects, Address and Customer. You will associate a stored procedure with the Address business object. Finally, you will select these objects to import.

  1. In the Find and Discovery Enterprise Services window, click Edit Query.

    You can use Edit Query to add business object application-specific information. You could use Edit Query to narrow the list of schemas, nodes, or objects displayed in the tree structure. For this scenario, you do not need to use filtering.

    Figure 1. Find and Discover Enterprise Services windowThis screen capture is described in the surrounding text.
  2. In the Query Filter Properties window, check the Add business object ASI check box and click OK.

    Then whenever you add an object when you run the metadata query, a window is displayed for entering application-specific information (ASI).

    Figure 2. Query Filter Properties window
    This screen capture is described in the surround text.
  3. In the Find and Discover Enterprise Services window, run the metadata query by clicking Run Query.

    The objects discovered by the query are displayed in the top pane. The tables, views, stored procedures, and synonyms/nicknames are sorted by schema name.

  4. Search for objects in the list by expanding the ADDCUSER schema name and expanding the Tables type.
  5. Click the Address and Customer tables, and then click >>Add to select the objects for import.
    Figure 3. Selecting the objects discovered by the queryThis screen capture is described in the surrounding text.

    The next window is displayed because you chose to add business object ASI in step 2.

  6. In the Configuration Parameters for ADDRESS window, click Add.

    The Status Column Name is used only for logical deletes, and Status Value specifies what values to update in the column corresponding to the attribute chosen for Status Column Name. Leave these two parameters as is, because logical deletes are not being performed in this scenario.

    Figure 4. Configuration Parameters for ADDRESS windowThis screen capture is described in the surrounding text.

    A list of stored procedures is displayed.

  7. Select CreateSP and click OK. This associates the CreateSP stored procedure application-specific information with the ADDRESS table. When a Create operation is called on the business object, the stored procedure specified in CreateSP is called, and performs the insert operation.
    Figure 5. List of stored procedures to add to the Verb ASI
    This screen capture is described in the surrounding text.
  8. In the Configuration Parameters for ADDRESS window, under CreateSP, type in values for the Schema and Stored Procedure fields.
    Use the following values:
    • Schema: ADDCUSER
    • Stored Procedure: CREATEADDRESS
  9. When you enter the Stored Procedure name, the Stored Procedure Parameters fields are displayed. Click OK.
    Figure 6. Values for CreateSP
    This screen capture is described in the surrounding text.

    The Configuration Parameters for CUSTOMER window is displayed.

    When you select more than one business object to add, the window to add business object ASI for the first object is displayed. After you entered the application-specific information, the same window for the second business object is displayed.

  10. No stored procedure will be associated with the Customer business object, so no verb application-specific information needs to be added. Click OK.
  11. The Find and Discover Enterprise Services window shows ADDRESS and CUSTOMER in the Objects to be imported pane. Click Next.

Result

The selected objects have been imported for use with the adapter.

Terms of use |

Last updated: Tue 12 Dec 2006 03:32:39

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)