public void increaseSalaryForLocation(Integer id, double raise) {
    Session session = null;
    try {
      session = sf.openSession();
      Query query = session.createQuery("from Department as dep left outer join fetch dep.employees where dep.id = :id");
      query.setParameter("id",id);
      Department dep = (Department)query.list().get(0);
      for(Iterator j=dep.getEmployees().iterator();j.hasNext();) {
          Employee emp = (Employee)j.next();
          double salary = emp.getSalary();
          salary += raise;
          emp.setSalary(salary);
      }
      session.flush();
    } catch (Exception e){
      System.out.println("Error in bulk insert of dept "+e.getMessage());
      e.printStackTrace();
    } finally {
      try {
        session.close();
      } catch (Exception e) {
        System.out.println("Hibernate Exception " + e.getMessage());
        e.printStackTrace();
      }       
    }       
  }