<composite-id name="compOrderLineID" class="net.sf.hibernate.CompositeCustOrdLinesID">
           <key-property name="customerOrderNo" column="CUSTOMERORDERNO" type="string"/>
           <key-property name="countryCode" column="COUNTRYCODE" type="string"/>
       </composite-id>
       
       <property name="deliveryDate" column="DELIVERYDATE"/>
        <property name="price" column="PRICE"/>
        <property name="freightCost" column="FREIGHTCOST"/>
        <property name="status" column="STATUS"/>
        <property name="paymentMode" column="PAYMENTMODE"/>
        <property name="totalVolume" column="TOTALVOLUME"/>
        <property name="totalWeight" column="TOTALWEIGHT"/>
        <property name="totalCost" column="TOTALCOST"/>
        <property name="versionNo" column="VERSIONNO"/>
    </class>

    <class name="net.sf.hibernate.CustomerOrderLine" table="CUSTOMERORDERLINE_T">
   
      
      <composite-id name="compOrderLineID" class="net.sf.hibernate.CompositeCustOrdLinesID">
         <key-many-to-one name="customerOrderNo" class="net.sf.hibernate.CustomerOrder">
            <column name="countryCode"/>
            <column name="customerOrderNo"/>
         </key-many-to-one>
         <key-property name="orderLineNo" column="ORDERLINENO" type="string"/>
      </composite-id>
      
      
        <property name="articleNo" column="ARTICLENO"/>
        <property name="articleName" column="ARTICLENAME"/>
        <property name="quantity" column="QUANTITY"/>
        <property name="price" column="PRICE"/>
        <property name="volume" column="VOLUME"/>
        <property name="weight" column="WEGHT"/>
        <property name="deliveryDate" column="DELIVERYDATE"/>
    </class>

Query q = session.createQuery("SELECT co.customerNo, co.status, co.deliveryDate, col.orderLineNo, col.articleNo, col.articleName, col.price, " +
      "FROM net.sf.hibernate.CustomerOrder co, net.sf.hibernate.CustomerOrderLine col " +
      "WHERE co.id=col.id.countryCode AND co.id=col.id.customerOrderNo col.orderLineNo='181382'");

public class CustomerOrder implements Serializable {
   private Date createDate;
   private Date deliveryDate;
   private int price;
   private int freightCost;   
   private int status;
   private int paymentMode;
   private int totalVolume;
   private int totalWeight;
   private int totalCost;
   private int versionNo;
   private CustomerOrderId customerOrderId;
   public CustomerOrderLine[] orderLines;  // array containing orderLines
   

   

   /**
    * Returns the createDate.
    * @return Date
    */
   public Date getCreateDate() {
      return createDate;
   }

   /**
    * Returns the deliveryDate.
    * @return Date
    */
   public Date getDeliveryDate() {
      return deliveryDate;
   }

   /**
    * Returns the freightCost.
    * @return int
    */
   public int getFreightCost() {
      return freightCost;
   }

   /**
    * Returns the paymentMode.
    * @return int
    */
   public int getPaymentMode() {
      return paymentMode;
   }

   /**
    * Returns the price.
    * @return int
    */
   public int getPrice() {
      return price;
   }

   /**
    * Returns the status.
    * @return int
    */
   public int getStatus() {
      return status;
   }

   /**
    * Returns the totalCost.
    * @return int
    */
   public int getTotalCost() {
      return totalCost;
   }

   /**
    * Returns the totalWeight.
    * @return int
    */
   public int getTotalWeight() {
      return totalWeight;
   }

   /**
    * Returns the totalVolume.
    * @return int
    */
   public int getTotalVolume() {
      return totalVolume;
   }

   /**
    * Returns the versionNo.
    * @return int
    */
   public int getVersionNo() {
      return versionNo;
   }


   /**
    * Sets the createDate.
    * @param createDate The createDate to set
    */
   public void setCreateDate(Date createDate) {
      this.createDate = createDate;
   }

   /**
    * Sets the deliveryDate.
    * @param deliveryDate The deliveryDate to set
    */
   public void setDeliveryDate(Date deliveryDate) {
      this.deliveryDate = deliveryDate;
   }

   /**
    * Sets the freightCost.
    * @param freightCost The freightCost to set
    */
   public void setFreightCost(int freightCost) {
      this.freightCost = freightCost;
   }

   /**
    * Sets the paymentMode.
    * @param paymentMode The paymentMode to set
    */
   public void setPaymentMode(int paymentMode) {
      this.paymentMode = paymentMode;
   }

   /**
    * Sets the price.
    * @param price The price to set
    */
   public void setPrice(int price) {
      this.price = price;
   }

   /**
    * Sets the status.
    * @param status The status to set
    */
   public void setStatus(int status) {
      this.status = status;
   }

   /**
    * Sets the totalCost.
    * @param totalCost The totalCost to set
    */
   public void setTotalCost(int totalCost) {
      this.totalCost = totalCost;
   }

   /**
    * Sets the totalWeight.
    * @param totalWeight The totalWeight to set
    */
   public void setTotalWeight(int totalWeight) {
      this.totalWeight = totalWeight;
   }

   /**
    * Sets the totalVolume.
    * @param totalVolume The totalVolume to set
    */
   public void setTotalVolume(int totalVolume) {
      this.totalVolume = totalVolume;
   }

   /**
    * Sets the versionNo.
    * @param versionNo The versionNo to set
    */
   public void setVersionNo(int versionNo) {
      this.versionNo = versionNo;
   }

   /**
    * Returns the orderLines.
    * @return CustomerOrderLine
    */
   public CustomerOrderLine[] getOrderLines() {
      return orderLines;
   }

   /**
    * Sets the orderLines.
    * @param orderLines The orderLines to set
    */
   public void setOrderLines(CustomerOrderLine[] orderLines) {
      this.orderLines = orderLines;
   }

   /**
    * Returns the customerOrderId.
    * @return CustomerOrderId
    */
   public CustomerOrderId getCustomerOrderId() {
      return customerOrderId;
   }

   /**
    * Sets the customerOrderId.
    * @param customerOrderId The customerOrderId to set
    */
   public void setCustomerOrderId(CustomerOrderId customerOrderId) {
      this.customerOrderId = customerOrderId;
   }

}

public class CustomerOrderLine implements Serializable {
   private String articleNo;
   private String articleName;
   private int quantity;
   private int price;
   private int volume;
   private int weight;   
   private int deliveryDate;
   private CustomerOrderLineId customerOrderLineId;
   

   

   /**
    * Returns the articleName.
    * @return String
    */
   public String getArticleName() {
      return articleName;
   }

   /**
    * Returns the articleNo.
    * @return String
    */
   public String getArticleNo() {
      return articleNo;
   }

   

   /**
    * Returns the deliveryDate.
    * @return int
    */
   public int getDeliveryDate() {
      return deliveryDate;
   }

   /**
    * Returns the price.
    * @return int
    */
   public int getPrice() {
      return price;
   }

   /**
    * Returns the quantity.
    * @return int
    */
   public int getQuantity() {
      return quantity;
   }

   /**
    * Returns the weight.
    * @return int
    */
   public int getWeight() {
      return weight;
   }

   /**
    * Returns the volume.
    * @return int
    */
   public int getVolume() {
      return volume;
   }

   /**
    * Sets the articleName.
    * @param articleName The articleName to set
    */
   public void setArticleName(String articleName) {
      this.articleName = articleName;
   }

   /**
    * Sets the articleNo.
    * @param articleNo The articleNo to set
    */
   public void setArticleNo(String articleNo) {
      this.articleNo = articleNo;
   }



   /**
    * Sets the deliveryDate.
    * @param deliveryDate The deliveryDate to set
    */
   public void setDeliveryDate(int deliveryDate) {
      this.deliveryDate = deliveryDate;
   }

   /**
    * Sets the price.
    * @param price The price to set
    */
   public void setPrice(int price) {
      this.price = price;
   }

   /**
    * Sets the quantity.
    * @param quantity The quantity to set
    */
   public void setQuantity(int quantity) {
      this.quantity = quantity;
   }

   /**
    * Sets the weight.
    * @param weight The weight to set
    */
   public void setWeight(int weight) {
      this.weight = weight;
   }

   /**
    * Sets the volume.
    * @param volume The volume to set
    */
   public void setVolume(int volume) {
      this.volume = volume;
   }



   /**
    * Returns the customerOrderLineId.
    * @return CustomerOrderLineId
    */
   public CustomerOrderLineId getCustomerOrderLineId() {
      return customerOrderLineId;
   }

   /**
    * Sets the customerOrderLineId.
    * @param customerOrderLineId The customerOrderLineId to set
    */
   public void setCustomerOrderLineId(CustomerOrderLineId customerOrderLineId) {
      this.customerOrderLineId = customerOrderLineId;
   }
}