SQL> select * from c_customer where c_id < 15 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
-------------- -------------
         3 55P0T9O9QvNiUS   HKGko1VGw5iq0AB  8XfoMLIPTQN6fo9XW
ZS4ImZ7XaLm4         j4sfUmLQsux0Ydm8     gX 8pX        920211111
013984641071     lq1thSYKkCv9KFuywrU6px0N  09-AUG-00       4789 BC
             0        196406


      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
-------------- -------------
         4 5mG3tAk6         Hn4FRrEdju       8XfoMLIPTQN6fo9XW
ZS4ImZ7XaLm4         j4sfUmLQsux0Ydm8     gX 8pX        920211111
013984641071     kopNKUmmgDd6O2hp          20-NOV-99       3029 BC
             0        296341


      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
-------------- -------------
        11 do6EVXabzpUWnq   gdeZ10fKZaYe7    8et8OpLVDrGnGRVXt0Y
upgfRctQNvTZ7Z       C3GgWJxkeIEH3Smi     b4 HlubetXav  017311111
8346099476402    uPSgaSSTw4Ohpu            06-JAN-04       3002 BC
             0        101406


SQL>

We choose Customer Id 3.


Appserver output
==================
04/04/12 13:46:42 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:472): found SequenceSesHome interface
04/04/12 13:46:42 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:480): found CustomerEntHome interface
04/04/12 13:46:42 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:488): found LargeOrderSesHome interface
04/04/12 13:46:42 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:493): found ItemEntHomeLocal interface
04/04/12 13:46:42 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.setEntityContext(Ljavax.ejb.EntityContext;)V(OrderCmp20EJB.java:498): found OrderLineEntHomeLocal interface
04/04/12 13:46:42 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 13:46:43 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: 1297751
04/04/12 13:46:43 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 13:46:43 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPriceWithDiscount(Ljava.lang.String;)D(OrderCmp20EJB.java:520): getPriceWithDiscount 
04/04/12 13:46:43 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.getPercentDiscount(D)D(OrderCmp20EJB.java:592): getPercentDiscount
04/04/12 13:46:43 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.findCustomer()V(OrderCmp20EJB.java:540): findCustomer
04/04/12 13:46:44 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.checkCustomerCredit()V(OrderCmp20EJB.java:568): checkCustomerCredit 
04/04/12 13:46:44 OrderCmp20EJB_PersistenceManager16 at org.spec.jappserver.orders.orderent.ejb.OrderCmp20EJB.ejbPassivate()V(OrderCmp20EJB.java:397): ejbPassivate 
==================


SQL> select * from o_orders where o_id = 1297751;

no rows selected

SQL> select * from o_orderline where ol_o_id = 1297751;

no rows selected

SQL>

