
SQL> select c_id from c_customer where c_credit = 'BC' and c_id < 100 ;

      C_ID
----------
         1
         9
        16
        19
        22
        28
        30
        42
        46
        54
        60

      C_ID
----------
        62
        71
        77
        85
        89
        91

17 rows selected.


We selected customer ID 19 as the customer with bad credit.

Using the web interface, an order is placed with a customerid of 19. The transaction
fails with an InsufficientCreditException.

The WebLogic console contains:

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: 7501
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 

The orderid returned in the debug messages is 7501:

SQL> select * from o_orders where o_id = 7501 ;

no rows selected

SQL> select * from o_orderline where ol_o_id = 7501 ;

no rows selected

SQL> 
