
Atomicity Test One
------------------

Select a customer that has bad credit.

c:\spec02\sql_remote>osql -U spec -P spec
1> select c_id from c_customer where c_credit = 'BC' and c_id < 100;
2> go
 c_id
 -----------
           7
          19
          35
          47
          62
          64
          65
          68
          75
          76
          79
          93
          98

(13 rows affected)
1>


We choose customer id = 75 and placed an order via the web interface.

org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb
: found SequenceSesHome interfaceava:472)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb
: found CustomerEntHome interfaceava:480)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb
: found LargeOrderSesHome interfacea:488)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb
: found ItemEntHomeLocal interfaceva:493)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb
: found OrderLineEntHomeLocal interface8)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbCreate(I[Lorg.spec.japps
: ejbCreate .helper.ItemQuantity;)Ljava.lang.Integer;(OrderCmp20EJB.java:107)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbCreate(I[Lorg.spec.japps
: Atomicity Test (1,2,3): Order Id: 2735751g.Integer;(OrderCmp20EJB.java:115)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPostCreate(I[Lorg.spec.j
: Atomicity Test 3: OrderLineId: 1ty;)V(OrderCmp20EJB.java:149)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPriceWithDiscount(Ljava.
: getPriceWithDiscount 20EJB.java:520)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPercentDiscount(D)D(Orde
: getPercentDiscount
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.findCustomer()V(OrderCmp20E
: findCustomer
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkCustomerCredit()V(Orde
: checkCustomerCredit



The Order Id derived from the above output is 2735751;

1> select * from o_orders where o_id = 2735751;
2> go
 o_id        o_c_id      o_ol_cnt    o_discount o_total     o_status
        o_entry_date            o_ship_date
 ----------- ----------- ----------- ---------- ----------- -----------
        ----------------------- -----------------------

(0 rows affected)
1> select * from o_orderline where ol_o_id = 2735751;
2> go
 ol_id       ol_o_id     ol_i_id         ol_qty      ol_status
        ol_ship_date
 ----------- ----------- --------------- ----------- -----------
        -----------------------

(0 rows affected)
1>
