<class name="OrderBean" table="ORDERINFO">
        <id name="orderId" unsaved-value="null" >
            <column name="ORDER_ID" not-null="true"/>
        </id>
        <property name="dateField">
            <column name="ORDER_DATE"/>
        </property>
        <property name="intAmount">
            <column name="TOTAL_AMOUNT" not-null="true"/>
        </property>
        <property name="intCustomerId">
            <column name="CUSTOMER_ID" not-null="true"/>
        </property>

         <!--set name="items" inverse="true" cascade="all">
      <key column="ITEM_ID"/>
      <one-to-many class="Child"/>
   </set-->


   <join table="ORDER_ITEM">
      <key column="ORDER_ID"/>
      <property name="intItemId" column="ITEM_ID" />
      <property name="intQuantity" column="QUANTITY" />
   </join>
    </class>

        Query query1 = session.createQuery("from OrderBean order,CustomerBean customer where order.intCustomerId = customer.customerId");

        List orderList = query1.list();
        org.hibernate.type.Type []typeArray = query1.getReturnTypes();

        for (int i=0; i<typeArray.length; i++){
          System.out.println(typeArray[i].getName());
          // this block prints the the name of my persisted classes
          // e.g. com.ts.hibernate.OrderBean and com...CustomerBean
        }

        Iterator iter1 = orderList.iterator();
        while (iter1.hasNext()){

          Object object = iter1.next();

          try{
            OrderBean order = (OrderBean) object;
            System.out.println("Date : " + order.getDateField());
          }catch(ClassCastException ee){
            try{
              System.out.println("ex : " + ee);
              CustomerBean customer = (CustomerBean) object;
              System.out.println("Customer : " + customer.getCustomerName());
            }catch(ClassCastException e){
                 // for all objects contained in the list, this exception is thrown
            }

Iterator kittensAndMothers = sess.createQuery(
            "select kitten, mother from Cat kitten join kitten.mother mother")
            .list()
            .iterator();

while ( kittensAndMothers.hasNext() ) {
    Object[] tuple = (Object[]) kittensAndMothers.next();
    Cat kitten  = tuple[0];
    Cat mother  = tuple[1];
    ....
}

Iterator results = sess.createQuery(
        "select cat.color, min(cat.birthdate), count(cat) from Cat cat " +
        "group by cat.color")
        .list()
        .iterator();

while ( results.hasNext() ) {
    Object[] row = results.next();
    Color type = (Color) row[0];
    Date oldest = (Date) row[1];
    Integer count = (Integer) row[2];
    .....
}