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

      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                                                    
-------------- -------------                                                    
        33 bZKxXQhkO5lYOc   EypzVXWs6iFzs    BiYNH43FAyC4wNyg                   
xX9ZIRrGpegKxu       bIFUjdPLifaFtWWg     fz fSAJ       891511111               
17359829303996   2SU4ndcal924FUzK8myh      12-MAR-02      14812 BC              
             0        146977                                                    
                                                                                
        37 lLElxdqX         VO5HBKtX7K0zOq   yjDvAHpoMGKj                       
1K3ExLPo3E           ZgVIJowvr3PZp1       sJ xUmEFSGee  460911111               
237342059221     ifRfL7YJ54                12-OCT-01      19049 BC              
             0        236510                                                    
                                                                                
        38 ET02v00A7Y       jjDEJneGADveGIeL 6ALE9Nbi60J9B                      
y4c0O5MWsL7          CTqwfOpP5H           1a NmsEgu     994311111               
375605989168     gcrcW0zDtLU7hAjKubYsVX    29-APR-01      16286 BC              
             0        154949                                                    
                                                                                
        47 TPoLsnqRXPp96yMU 1gdj2D9T1k41dF   hpbwL01CVVLgWMM6                   
48bY7tlQ23fdjOMdKwX  JQ7zJokddK8Hdzm      kC WHGghcr    038911111               
875291489235724  zPtfUk5fBUU41v2X          27-JAN-00       5101 BC              
             0         72149                                                    
 
We chose customer id 47

appserver o/p
-------------
03/08/19 14:20:20 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:20:20 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:20:20 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:20:20 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:20:20 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:20:20 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:20:20 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: 37501
03/08/19 14:20:20 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:20:20 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPriceWithDiscount(Ljava.lang.String;)D(OrderCmp20EJB.java:520): getPriceWithDiscount 
03/08/19 14:20:21 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPercentDiscount(D)D(OrderCmp20EJB.java:592): getPercentDiscount
03/08/19 14:20:21 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.findCustomer()V(OrderCmp20EJB.java:540): findCustomer
03/08/19 14:20:21 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkCustomerCredit()V(OrderCmp20EJB.java:568): checkCustomerCredit 
03/08/19 14:20:21 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPassivate()V(OrderCmp20EJB.java:397): ejbPassivate 
---------------

SQL> select * from o_orders where o_id = 37501;

no rows selected

SQL> select * from o_orderline where ol_o_id = 37501;

no rows selected
