ant -f /home/mauronew/NetBeansProjects/progetti_netbeans8.2/projects_kay/LazyJPATest -Dnb.internal.action.name=run run
init:
Deleting: /home/mauronew/NetBeansProjects/progetti_netbeans8.2/projects_kay/LazyJPATest/build/built-jar.properties
deps-jar:
Updating property file: /home/mauronew/NetBeansProjects/progetti_netbeans8.2/projects_kay/LazyJPATest/build/built-jar.properties
compile:
run:
nov 07, 2016 4:50:55 PM org.hibernate.ejb.HibernatePersistence logDeprecation
WARN: HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
nov 07, 2016 4:50:55 PM org.hibernate.ejb.HibernatePersistence logDeprecation
WARN: HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
nov 07, 2016 4:50:55 PM org.hibernate.ejb.HibernatePersistence logDeprecation
WARN: HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
nov 07, 2016 4:50:56 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
INFO: HHH000204: Processing PersistenceUnitInfo [
	name: LazyJPAHibernateTestPU
	...]
nov 07, 2016 4:50:56 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.3.11.Final}
nov 07, 2016 4:50:56 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
nov 07, 2016 4:50:56 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
nov 07, 2016 4:50:57 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
nov 07, 2016 4:50:57 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
nov 07, 2016 4:50:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000401: using driver [org.apache.derby.jdbc.EmbeddedDriver] at URL [jdbc:derby:classpath:sample]
nov 07, 2016 4:50:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000046: Connection properties: {user=app, password=****}
nov 07, 2016 4:50:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000006: Autocommit mode: false
nov 07, 2016 4:50:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
nov 07, 2016 4:51:01 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.DerbyTenSevenDialect
nov 07, 2016 4:51:01 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Hibernate:
    /* named HQL query Customer.findAll */ select
        customer0_.CUSTOMER_ID as CUSTOMER1_0_,
        customer0_.ADDRESSLINE1 as ADDRESSL2_0_,
        customer0_.ADDRESSLINE2 as ADDRESSL3_0_,
        customer0_.CITY as CITY4_0_,
        customer0_.CREDIT_LIMIT as CREDIT_L5_0_,
        customer0_.DISCOUNT_CODE as DISCOUN11_0_,
        customer0_.EMAIL as EMAIL6_0_,
        customer0_.FAX as FAX7_0_,
        customer0_.NAME as NAME8_0_,
        customer0_.PHONE as PHONE9_0_,
        customer0_.STATE as STATE10_0_,
        customer0_.ZIP as ZIP12_0_
    from
        CUSTOMER customer0_
    order by
        customer0_.CUSTOMER_ID
CUSTOMERS
==========================================
ID: 1, Name: Jumbo Eagle Corp, Email: jumboeagle@example.comHibernate:
    select
        discountco0_.DISCOUNT_CODE as DISCOUNT1_1_0_,
        discountco0_.RATE as RATE2_1_0_
    from
        DISCOUNT_CODE discountco0_
    where
        discountco0_.DISCOUNT_CODE=?
, Discount: 0.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 10398001Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Identity ServerHibernate:
    select
        productcod0_.PROD_CODE as PROD_COD1_5_0_,
        productcod0_.DESCRIPTION as DESCRIPT2_5_0_,
        productcod0_.DISCOUNT_CODE as DISCOUNT3_5_0_
    from
        PRODUCT_CODE productcod0_
    where
        productcod0_.PROD_CODE=?
 (Software), Qty: 10
   --> Order#: 10398005Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Sound CardHibernate:
    select
        productcod0_.PROD_CODE as PROD_COD1_5_0_,
        productcod0_.DESCRIPTION as DESCRIPT2_5_0_,
        productcod0_.DISCOUNT_CODE as DISCOUNT3_5_0_
    from
        PRODUCT_CODE productcod0_
    where
        productcod0_.PROD_CODE=?
 (Firmware), Qty: 100
ID: 2, Name: New Enterprises, Email: www.new.example.comHibernate:
    select
        discountco0_.DISCOUNT_CODE as DISCOUNT1_1_0_,
        discountco0_.RATE as RATE2_1_0_
    from
        DISCOUNT_CODE discountco0_
    where
        discountco0_.DISCOUNT_CODE=?
, Discount: 11.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 10398002Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Accounting Application (Software), Qty: 8
   --> Order#: 10398003Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: 1Ghz Sun Blade ComputerHibernate:
    select
        productcod0_.PROD_CODE as PROD_COD1_5_0_,
        productcod0_.DESCRIPTION as DESCRIPT2_5_0_,
        productcod0_.DISCOUNT_CODE as DISCOUNT3_5_0_
    from
        PRODUCT_CODE productcod0_
    where
        productcod0_.PROD_CODE=?
 (Hardware), Qty: 25
ID: 3, Name: Small Bill Company, Email: www.smallbill.example.comHibernate:
    select
        discountco0_.DISCOUNT_CODE as DISCOUNT1_1_0_,
        discountco0_.RATE as RATE2_1_0_
    from
        DISCOUNT_CODE discountco0_
    where
        discountco0_.DISCOUNT_CODE=?
, Discount: 7.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 10398004Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: 10Gb Ram (Firmware), Qty: 9
ID: 25, Name: Wren Computers, Email: www.wrencomp.example.com, Discount: 11.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
    --> No purchase orders found!
ID: 106, Name: Early CentralComp, Email: www.centralcomp.example.com, Discount: 7.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 10398008Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: 104-Key Keyboard (Hardware), Qty: 500
ID: 149, Name: John Valley Computers, Email: www.johnvalley.example.com, Discount: 7.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 10398009Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Directory Server (Software), Qty: 1000
ID: 409, Name: Old Media Productions, Email: www.oldmedia.example.com, Discount: 7.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 30198001, Product: Identity Server (Software), Qty: 50
ID: 410, Name: Yankee Computer Repair Ltd, Email: www.nycompltd@repair.example.com, Discount: 11.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 30298004Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Sun Studio C++ (Software), Qty: 100
ID: 722, Name: Big Car Parts, Email: www.bparts.example.com, Discount: 0.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 20598101Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Learn NetBeansHibernate:
    select
        productcod0_.PROD_CODE as PROD_COD1_5_0_,
        productcod0_.DESCRIPTION as DESCRIPT2_5_0_,
        productcod0_.DISCOUNT_CODE as DISCOUNT3_5_0_
    from
        PRODUCT_CODE productcod0_
    where
        productcod0_.PROD_CODE=?
 (Books), Qty: 250
ID: 753, Name: Zed Motor Co, Email: www.parts@ford.example.comHibernate:
    select
        discountco0_.DISCOUNT_CODE as DISCOUNT1_1_0_,
        discountco0_.RATE as RATE2_1_0_
    from
        DISCOUNT_CODE discountco0_
    where
        discountco0_.DISCOUNT_CODE=?
, Discount: 16.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 20598100Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: 300Mhz Pentium Computer (Hardware), Qty: 100
ID: 777, Name: West Valley Inc., Email: www.westv.example.com, Discount: 7.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 20198001Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: Network CableHibernate:
    select
        productcod0_.PROD_CODE as PROD_COD1_5_0_,
        productcod0_.DESCRIPTION as DESCRIPT2_5_0_,
        productcod0_.DISCOUNT_CODE as DISCOUNT3_5_0_
    from
        PRODUCT_CODE productcod0_
    where
        productcod0_.PROD_CODE=?
 (Cables), Qty: 75
ID: 863, Name: Big Network Systems, Email: www.bignet.example.com, Discount: 0.00%
Hibernate:
    select
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_0_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_0_,
        purchaseor0_.ORDER_NUM as ORDER_NU1_6_1_,
        purchaseor0_.CUSTOMER_ID as CUSTOMER7_6_1_,
        purchaseor0_.FREIGHT_COMPANY as FREIGHT_2_6_1_,
        purchaseor0_.PRODUCT_ID as PRODUCT_8_6_1_,
        purchaseor0_.QUANTITY as QUANTITY3_6_1_,
        purchaseor0_.SALES_DATE as SALES_DA4_6_1_,
        purchaseor0_.SHIPPING_COST as SHIPPING5_6_1_,
        purchaseor0_.SHIPPING_DATE as SHIPPING6_6_1_
    from
        PURCHASE_ORDER purchaseor0_
    where
        purchaseor0_.CUSTOMER_ID=?
   --> Order#: 10398010Hibernate:
    select
        product0_.PRODUCT_ID as PRODUCT_1_4_0_,
        product0_.AVAILABLE as AVAILABL2_4_0_,
        product0_.DESCRIPTION as DESCRIPT3_4_0_,
        product0_.MANUFACTURER_ID as MANUFACT7_4_0_,
        product0_.MARKUP as MARKUP4_4_0_,
        product0_.PRODUCT_CODE as PRODUCT_8_4_0_,
        product0_.PURCHASE_COST as PURCHASE5_4_0_,
        product0_.QUANTITY_ON_HAND as QUANTITY6_4_0_
    from
        PRODUCT product0_
    where
        product0_.PRODUCT_ID=?
, Product: 512X IDE DVD-ROM (Hardware), Qty: 100
BUILD SUCCESSFUL (total time: 14 seconds)