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

      C_ID C_FIRST          C_LAST           C_STREET1                          
---------- ---------------- ---------------- --------------------               
C_STREET2            C_CITY               C_ C_COUNTRY  C_ZIP                   
-------------------- -------------------- -- ---------- ---------               
C_PHONE          C_CONTACT                 C_SINCE    C_BALANCE C_              
---------------- ------------------------- --------- ---------- --              
C_CREDIT_LIMIT C_YTD_PAYMENT                                                    
-------------- -------------                                                    
         1 vmnUSdDQRs2      IrNLr07Fu1I2diO8 V6Sz0qCvxV2                        
XLJvt4cRA9Q86UpyK4IL X0EdRVgTgpFRH6       Rc vDc        119711111               
63101809058866   VriVdTEZPzISFr7j4E        18-JUL-97      22214 GC              
     946028.77           387                                                    
                                                                                
         2 CSgee8RkkWwYcenn ZdhpaxyM6I4      aIDkzW1HilAlNFZt                   
BncVdNE5DuF3X7       kGP5G6Ye3LysZ        ZO JOMBKxC    722911111               
2001105706400    SqeCVWDiV9ieJt6WZ0w       22-NOV-00      10376 GC              
    1053431.31        267752                                                    
                                                                                
         3 PJcdYJsNOq       jYD8kC8dEBkIB    aIDkzW1HilAlNFZt                   
BncVdNE5DuF3X7       kGP5G6Ye3LysZ        ZO JOMBKxC    722911111               
2001105706400    oohI65qgIlUvwaIXzLQ       31-OCT-01      14456 GC              
    1559991.41          4193                                                    
                                                                                
         4 Nr72XUG64Xs7QqQP xYmE1xO3qs1oZs4L RaxLztf8DF9PdRB7                   
wZQlKDZ7tHC          PTu9lfN1IdM01SSe5UUv PB 7uYfi      951911111               
26885694946944   NxqNr09KEF6ygG            07-FEB-99      12429 GC              
    2010290.91        307676                                                    
 
We chose customer id 1

Appserver output
----------------

03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:472): found SequenceSesHome interface
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:480): found CustomerEntHome interface
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:488): found LargeOrderSesHome interface
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:493): found ItemEntHomeLocal interface
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:498): found OrderLineEntHomeLocal interface
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbCreate(I[Lorg.spec.jappserver.orders.helper.ItemQuantity;)Ljava.lang.Integer;(OrderCmp20EJB.java:107): ejbCreate 
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbCreate(I[Lorg.spec.jappserver.orders.helper.ItemQuantity;)Ljava.lang.Integer;(OrderCmp20EJB.java:115): Atomicity Test (1,2,3): Order Id: 47501
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPostCreate(I[Lorg.spec.jappserver.orders.helper.ItemQuantity;)V(OrderCmp20EJB.java:149): Atomicity Test 3: OrderLineId: 1
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPriceWithDiscount(Ljava.lang.String;)D(OrderCmp20EJB.java:520): getPriceWithDiscount 
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPercentDiscount(D)D(OrderCmp20EJB.java:592): getPercentDiscount
03/08/19 14:24:01 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.findCustomer()V(OrderCmp20EJB.java:540): findCustomer
03/08/19 14:24:02 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkCustomerCredit()V(OrderCmp20EJB.java:568): checkCustomerCredit 
03/08/19 14:24:02 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkForLargeOrders([Lorg.spec.jappserver.orders.helper.ItemQuantity;)V(OrderCmp20EJB.java:622): checkForLargeOrders 
03/08/19 14:24:02 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbStore()V(OrderCmp20EJB.java:417): ejbStore 
03/08/19 14:24:02 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPassivate()V(OrderCmp20EJB.java:397): ejbPassivate 

SQL> select * from o_orders where o_id = 47501;

      O_ID     O_C_ID   O_OL_CNT O_DISCOUNT    O_TOTAL   O_STATUS O_ENTRY_D     
---------- ---------- ---------- ---------- ---------- ---------- ---------     
O_SHIP_DA                                                                       
---------                                                                       
     47501          1          1         .1     1496.8          1 19-AUG-03     
                                                                                
                                                                                

SQL> select * from o_orderline where ol_o_id = 47501;

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

