Hello. I'm passing an ArrayList of ids to my query. It shouldn't be returning all the rows of the table if only some of the ids are in the list, but somehow all the rows is what I'm getting. Can anyone help me with this? Thanks in advance.
public static List<Applicant> getByJob(List<Employment> employment) {
try {
SessionFactory sessionFactory = new Configuration().configure()
.buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria c = session.createCriteria(Applicant.class);
Iterator<Employment> iter = employment.iterator();
ArrayList<Integer> idList = new ArrayList<Integer>();
while (iter.hasNext()) {
Employment next = (Employment) iter.next();
idList.add(next.getPersonid());
}
for (int i = 0; i < idList.size() - 1; i++) {
for (int j = i + 1; j < idList.size(); j++) {
if (idList.get(j) == idList.get(i)) {
idList.remove(j);
}
}
}
System.out.println("idList.size = " + idList.size());
Query query = session.createQuery("from Person p where p.id_prsn in (:ids)");
query.setParameterList("ids", idList);
List<Applicant> results = (List<Applicant>) c.list();
if (!results.isEmpty()) {
return results;
} else {
return null;
}
} catch (HibernateException e) {
e.printStackTrace();
return null;
}
}
Login
FAQ
Search
