Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

B2B XML Application: Step by Step , 25 of 32

## 8 Retailer Application Updates the Ord Table and Displays the New Order Status to Retailer

1. Retailer application updates the Retailer database "Pending " status with the new "shipped" order status information. The Ord table is updated.

2. This information is viewed by the Retailer from any device. The status is seen as "Shipped". See Figure 13-28.

#### Scripts:

`UpdateMaster.java`. This receives the message and parses it.

#### Figure 13-28 [Retailer]: retailer.bat, broker.bat, and supplier.bat Consoles - Updates Status to Shipped

That's it!

### To Stop the B2B XML Application

To stop the B2B XML application (demo), run Java Example 3: stopQ.bat.

#### Java Example 3: stopQ.bat

    @echo off
    @echo stopping all Qs
    D:\jdev31\java\bin\java -mx50m -classpath
    "D:\xml817\references\Ora817DevGuide;
    D:\jdev31\lib\jdev-rt.zip;
    D:\jdev31\jdbc\lib\oracle8.1.6\classes111.zip;
    D:\jdev31\lib\connectionmanager.zip;
    D:\jdev31\lib;D:\jdev31\lib\oraclexsql.jar;
    D:\jdev31\lib\oraclexmlsql.jar;
    D:\jdev31\lib\xmlparserv2_2027.jar;
    D:\jdev31\jfc\lib\swingall.jar;
    D:\jdev31\jswdk-1.0.1\lib\servlet.jar;
    D:\Ora8i\rdbms\jlib\aqapi11.jar;
    D:\Ora8i\rdbms\jlib\aqapi.jar;
    D:\XMLWorkshop\xmlcomp.jar;
    D:\jdev31\java\lib\classes.zip"  B2BDemo.AQUtil.StopAllQueues

### Check Your Order Status Directly Using vieworder.sql

To view your order status directly from the database run this SQL script.

    set ver off
    select O.ID as "Order#",
       O.OrderDate as "Order Date",
       O.Status as "Status"
       From ORD O,
         CUSTOMER C
       Where O.CUSTOMER_ID = C.ID and
         Upper(C.NAME) = Upper('&CustName');

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index