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 Jh7tVglOwW       2JNskucnQ3KB1    trareU4AH0
eV81DvXz4coX         ReKEFRY7CB7mMW       Zn YJzLGRWEWx 280111111
5771226125556004 qW2KbgqGcmUGojLw          09-SEP-99       4461 GC
    2800672.01        200383


      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
-------------- -------------
         2 JfZ55LiRFy5u     WSyq109dR4crwoaN wr4wd0ZcifVW
iHVQvObfBV8          qVtTP1ytPkd          Pg qOIn9      969511111
5556390761457899 ef8SwuoAr3IR9gGMu5LJdI5   14-NOV-03      15036 GC
     1556493.1         74113


SQL>


We chose customer id 1


Appserver output
=================
04/04/12 14:00:27 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:472): found SequenceSesHome interface
04/04/12 14:00:27 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:480): found CustomerEntHome interface
04/04/12 14:00:27 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:488): found LargeOrderSesHome interface
04/04/12 14:00:27 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:493): found ItemEntHomeLocal interface
04/04/12 14:00:27 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:498): found OrderLineEntHomeLocal interface
04/04/12 14:00:28 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 
04/04/12 14:00:28 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: 1307751
04/04/12 14:00:28 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
04/04/12 14:00:28 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPriceWithDiscount(Ljava.lang.String;)D(OrderCmp20EJB.java:520): getPriceWithDiscount 
04/04/12 14:00:28 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPercentDiscount(D)D(OrderCmp20EJB.java:592): getPercentDiscount
04/04/12 14:00:28 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.findCustomer()V(OrderCmp20EJB.java:540): findCustomer
04/04/12 14:00:29 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkCustomerCredit()V(OrderCmp20EJB.java:568): checkCustomerCredit 
04/04/12 14:00:29 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkForLargeOrders([Lorg.spec.jappserver.orders.helper.ItemQuantity;)V(OrderCmp20EJB.java:622): checkForLargeOrders 
04/04/12 14:00:29 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbStore()V(OrderCmp20EJB.java:417): ejbStore 
04/04/12 14:00:30 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPassivate()V(OrderCmp20EJB.java:397): ejbPassivate 
=================


SQL> select * from o_orders where o_id = 1307751;

      O_ID     O_C_ID   O_OL_CNT O_DISCOUNT    O_TOTAL   O_STATUS O_ENTRY_D
---------- ---------- ---------- ---------- ---------- ---------- ---------
O_SHIP_DA
---------
   1307751          1          1         .3     1910.2          1 12-APR-04



SQL> select * from o_orderline where ol_o_id = 1307751;

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

SQL>