
Atomicity Test Two
------------------

We select a customer with good credit.

1> select c_id from c_customer where c_credit = 'GC' and c_id < 20;
2> go
c_id
 -----------
           1
           2
           3
           4
           5
           6
           8
           9
          10
          11
          12
          13
          14
          15
          16
          17
          18

(17 rows affected)
1>


For this test, we have chosen a c_id of 18. Using the web interface, we execute a newOrder transaction of 
item 0001MITEM00002 in quantity of 100. The order completes succesfully and the application server output shows:

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
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: 2735752g.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
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkForLargeOrders([Lorg.s
: checkForLargeOrders helper.ItemQuantity;)V(OrderCmp20EJB.java:622)
org.spec.jappserver.orders.orderent.ejb.OrderEnt_nrczp2__WebLogic_CMP_RDBMS at o
rg.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbStore()V(OrderCmp20EJB.j
: ejbStore


Order number is 2735752 is verified via the o_orders and o_orderline tables.

1> select * from o_orders where o_id = 2735752;
2> go

o_id        o_c_id      o_ol_cnt    o_discount o_total     o_status
        o_entry_date            o_ship_date
 ----------- ----------- ----------- ---------- ----------- -----------
        ----------------------- -----------------------
     2735752          18           1        .20     2695.21           1
        2004-07-19 16:14:41.420                    NULL

(1 row affected)

1> select * from o_orderline where ol_o_id = 2735752;
2> go

ol_id       ol_o_id     ol_i_id         ol_qty      ol_status
        ol_ship_date
 ----------- ----------- --------------- ----------- -----------
        -----------------------
           1     2735752 00001MITEM00002         100        NULL
                           NULL

(1 row affected)
1>
