Testing the Example

After starting the adapter configuration successfully, you can test the example.

Procedure

  1. In the Project Explorer view, select Jms_Sales_Order_Demo.bwp from the SalesOrderOracle processes and double-click the process name.
  2. In the process editor, right-click each activity, and from the pop-up menu, click Breakpoint > Set Before/After to set breakpoints for the process.
    Using breakpoints to work through the process helps check what happens when each activity is performed.

  3. In the Project Explorer view, right-click Jms_Sales_Order_Demo.bwp. From the pop-up menu, click Debug As > Launch BusinessWorks Debugger.
  4. On a command line, use the following script to insert a row into the source table:
    > sqlplus userid/pswd@dbService @insertSalesOrder_ora.sql
    The script creates the items and displays the status. For example: 
    SQL*Plus: Release 11.2.0.1.0 - Production on Fri Apr 26 15:39:22
2013
Copyright <c> 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
Production
With the Partitioning, OLAP, Data Mining and Real Application
Testing options

1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application
Testing options

Result

After running the example, the sales order is changed to contain only the valid sales items. The priority assigned to each valid sales item is also changed.

A query of the original sales order shows the following entries: 

select HEADER_NUMBER, PRIORITY, SHIP_NOTE from SO_HEADER;
         1-1ABXYZ        2       Regular Shipping

select HEADER_NUMBER, LINE_NUMBER, SHIPPING_NOTE from SO_LINE;
         1-1ABXYZ      L-1ABXYZ     Regular
         1-1ABXYZ      L-2ABXYZ     Regular
         1-1ABXYZ      L-3ABXYZ     Regular

After running the example, a query of the changed sales order shows the
following results:

select HEADER_NUMBER, PRIORITY, SHIP_NOTE from NEW_SO_HEADER;
         1-1ABXYZ        1       Express Shipping

select HEADER_NUMBER, LINE_NUMBER, SHIPPING_NOTE from NEW_SO_LINE;
         1-1ABXYZ      L-1ABXYZ     Urgent
         1-1ABXYZ      L-2ABXYZ     Urgent
Contents
Search Results