1. Developing SOA Applications with Oracle SOA Suite
  2. Sharing Functionality Across Service Components
  3. Working with Cross References
  4. Creating and Running Cross Reference for 1M Functions
  5. How to Create the Use Case
  6. Task 4: How to Create a Database Adapter Service

Task 4: How to Create a Database Adapter Service

To create a database adapter service:

  1. In the Components window, select SOA.
  2. Select Database Adapter and drag it to the Exposed Services swimlane.

    The Adapter Configuration wizard Welcome page is displayed.

  3. Click Next.

    The Service Name page is displayed.

  4. In the Service Name field, enter SAP.
  5. Click Next.

    The Service Connection page is displayed.

  6. In the Connection field, select DBConnection1.
  7. In the JNDI Name field, enter eis/DB/DBConnection1.
  8. Click Next.

    The Operation Type page is displayed.

  9. Select Poll for New or Changed Records in a Table and click Next.

    The Select Table page is displayed.

  10. Click Import Tables.

    The Import Tables dialog is displayed.

  11. Select Scott from the Schema.
  12. In the Name Filter field, enter %SAP% and click Query.

    The Available field is populated with the SAP_05 table name.

  13. Double-click SAP_05.

    The selected field is populated with SAP_05.

  14. Click OK.

    The Select Table page now contains the SAP_05 table.

  15. Select SAP_05 and click Next.

    The Define Primary Key page is displayed.

  16. Select ID as the primary key and click Next.

    The Relationships page is displayed.

  17. Click Next.

    The Attribute Filtering page is displayed.

  18. Click Next.

    The After Read page is displayed.

  19. Select Update a Field in the [SAP_05] Table (Logical Delete) and click Next.

    The Logical Delete page is displayed.

  20. In the Logical Delete field, select LOGICAL_DEL.
  21. In the Read Value field, enter Y.
  22. In the Unread Value field, enter N.

    Figure 44-16 shows the Logical Delete page of the Adapter Configuration wizard.

  23. Click Next.

    The Polling Options page is displayed.

  24. Click Next.

    The Define Selection Criteria page is displayed.

  25. Click Next.

    The Advanced Options page is displayed.

  26. Click Next.

    The Finish page is displayed.

  27. Click Finish.

    A database adapter service named SAP is created, as shown in Figure 44-48.

    Figure 44-48 SAP Database Adapter Service in SOA Composite Editor

    Description of Figure 44-48 follows
    Description of "Figure 44-48 SAP Database Adapter Service in SOA Composite Editor"
  28. From the File menu, select Save All.