
SQL> select c_id from c_customer where c_credit = 'GC' and c_id < 25 ;

      C_ID
----------
         2
         3
         4
         5
         6
         7
         8
        10
        11
        12
        13

      C_ID
----------
        14
        15
        17
        18
        20
        21
        23
        24

19 rows selected.

Customer 20 is selected as the customer with good credit.

We now enter an order through the web interface for customer 20. The web transaction
completed without an exception and returns an order id of 7502. Debug output from the
WebLogic console is:

org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: found SequenceSesHome interface
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: found CustomerEntHome interface
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: found LargeOrderSesHome interface
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: found ItemEntHomeLocal interface
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: found OrderLineEntHomeLocal interface
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: ejbCreate 
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: Atomicity Test (1,2,3): Order Id: 7502
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: Atomicity Test 3: OrderLineId: 1
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: getPriceWithDiscount 
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: getPercentDiscount
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: findCustomer
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: checkCustomerCredit 
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: checkForLargeOrders 
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS java.lang.Exception: ejbStore 

The debug output confirms the orderid of 7502:

SQL> select * from o_orders where o_id = 7502 ;

      O_ID     O_C_ID   O_OL_CNT O_DISCOUNT    O_TOTAL   O_STATUS O_ENTRY_D
---------- ---------- ---------- ---------- ---------- ---------- ---------
O_SHIP_DA
---------
      7502         20          1         .4    1017.63          1 21-OCT-03



SQL> select * from o_orderline where ol_o_id = 7502 ;

     OL_ID    OL_O_ID OL_I_ID             OL_QTY  OL_STATUS OL_SHIP_D
---------- ---------- --------------- ---------- ---------- ---------
         1       7502 00001MITEM00001          2

SQL> 
