public List<TeacherDetails> getAllTeachersFromClass(int class_id) { ArrayList<TeacherDetails> teachers = new ArrayList<TeacherDetails>(); Session session = null; Transaction transaction = null; List queryResultList = null; String queryString = "from Teacher where class_id=:class_id"; try { session = HibernateUtil.getSessionfactory().openSession(); transaction = session.beginTransaction(); Query query = session.createQuery(queryString); query.setInteger("class_id", class_id); queryResultList = query.list(); transaction.commit(); Iterator itr = queryResultList.iterator(); while (itr.hasNext()) { Teacher entry = (Teacher) itr.next(); TeacherDetails teacherDetails = new TeacherDetails(); teacherDetails.setTeacherId(entry.getUser_id()); teacherDetails.setSubjectIds(entry.getSub_ids()); teacherDetails.setTeacherBean(getTeacherDetailsFromID(entry.getUser_id())); if (entry.getSuffix() != null) { teacherDetails.setSuffix(entry.getSuffix()); } else { teacherDetails.setSuffix(""); } if (!entry.getSub_ids().equals("")) { teacherDetails.setSubjects(getAssignedSubjects(entry.getSub_ids().split(","))); } else { teacherDetails.setSubjects(new ArrayList<Subject>()); } teachers.add(teacherDetails); } return teachers; } catch (Exception e) { e.printStackTrace(); } finally { if (null != session) { session.close(); } } return null; }