Sun Adapter for Oracle Tutorials

Creating the bpDelete Business Rules

The bpDelete business process describes how to delete a record in the Oracle database using the Business Process Designer.

ProcedureCreate the bpDelete Business Rules

  1. Double-click bpDelete in the Projects window to open the Business Process Designer to the bpDelete Business Process.

  2. Create the bpDelete FileClient.receive -> FileClient.write rule.

    1. Right-click the link between FileClient.receive and FileClient.write and select Add Business Rule from the popup menu.

      A Business Rule icon is add to the link.

    2. Double-click the Business Rule icon.

      The Business Rule Designer opens to the new Business Rule.

    3. From the Business Rule Designer toolbar String menu, select string literal.

      A string literal method box is added to the Business Rule Designer canvas.

    4. Double-click the string literal method box value field, and enter Deleting record... as the value.

    5. Map the Deleting record... output node of the string literal method box, to text under FileClient.write.Input in the Input pane (right pane) of the Business Rule Designer. To do this, click on the Deleting record... output node of the string literal method box, and drag your cursor to the text node under FileClient.write.Input in the Input pane of the Business Rule Designer.

    Image shows the bpDelete FileClient.receive  -> FileClient.write
rule in the Business Rule Designer.
  3. Create the bpDelete FileClient.write -> otdOracle.DB_EMPLOYEEDelete rule.

    1. Add a Business Rule to the link between FileClient.write and otdOracle.DB_EMPLOYEEDelete and double-click the new Business Rule icon.

      The Business Rule Designer opens to the new Business Rule.

    2. Map text under FileClient.receive.Output in the Output pane of the Business Rule Designer, to whereClause under otdOracle.DB_EMPLOYEEDelete.Input -> input in the Input pane of the Business Rule Designer.

      A visible link now connects the two nodes in the Business Rule Designer.

      Image shows the FileClient.write  -> otdOracle.DB_EMPLOYEEDelete
rule in the Business Rule Designer.
  4. Create the otdOracle.DB_EMPLOYEEDelete -> bpDelete FileClient.write rule.

    1. Add a Business Rule to the link between otdOracle.DB_EMPLOYEEDelete and bpDelete FileClient.write and double-click the new Business Rule icon.

      The Business Rule Designer opens to the new Business Rule.

    2. From the Business Rule Designer toolbar String menu, select string literal.

      A string literal method box is added to the Business Rule Designer canvas.

    3. Double-click the string literal method box value field, and enter Delete done.. as the value.

    4. Map the Delete done.. output node of the string literal method box, to text under FileClient.write.Input1 in the Input pane of the Business Rule Designer.

  5. Save your project.