public class Main {
   
   public static void main(String[] args) {
      HibernateUtil.setup("create table Supplier ( id int, name VARCHAR);");
      HibernateUtil.setup("create table Product ( id int, name VARCHAR, description VARCHAR, price double,supplierId int);");
      
      prepareData();
      Session session = HibernateUtil.currentSession();
      
        String hql = "from Supplier s inner join fetch s.products as p";
        Query query = session.createQuery(hql);
        List results = query.list();
        displaySupplierList(results);
       
        String hql2 = "from Supplier s inner join s.products as p";
        Query query2 = session.createQuery(hql2);
        List results2 = query2.list();
        displaySupplierList(results2);
      
      
        //HibernateUtil.checkData("select * from Supplier");
        //HibernateUtil.checkData("select * from Product");

   }
    static public void displaySupplierList(List list) {
        Iterator iter = list.iterator();
        if (!iter.hasNext()) {
            System.out.println("No suppliers to display.");
            return;
        }       
        while (iter.hasNext()) {
            Supplier supplier = (Supplier) iter.next();
            String msg = supplier.getName();
            String msg2 = ((Product)supplier.getProducts().get(0)).getName();
            System.out.println(msg + " " + msg2);
        }
    }




   private static void prepareData(){
        Session session = HibernateUtil.currentSession();

        Supplier supplier1 = new Supplier();
        supplier1.setName("Supplier Name 1");
        session.save(supplier1);
       
        Supplier supplier2 = new Supplier();
        supplier2.setName("Supplier Name 2");
        session.save(supplier2);       
       
        Product product1 = new Product("Product 1","Name for Product 1", 2.0);
        product1.setSupplier(supplier1);
        supplier1.getProducts().add(product1);
        session.save(product1);
       
        Product product12 = new Product("Product 2","Name for Product 2", 22.0);
        product12.setSupplier(supplier1);
        supplier1.getProducts().add(product12);       
        session.save(product12);
       
        Product product2 = new Product("Product 3", "Name for Product 3", 30.0);
        product2.setSupplier(supplier2);
        supplier2.getProducts().add(product2);
        session.save(product2);
       
        session.flush();
        HibernateUtil.closeSession();
   }
}

select s from Supplier s inner join fetch s.products

select s, p from Supplier s inner join s.products as p