how Can I do batch delete in hibernate

JavaJason · **Joined:** Thu Jul 22, 2004 4:32 am **Posts:** 31

I want to finish this in hibernate:
"delete from department where deptId in('d001','d002','d002')"

I do it like this now:

Code:

String deptIds = {'d001','d002','d002'};
for(int i=0;i<deptIds.length;i++){
  Object obj = session.load(DepartmentPO.class,deptIds[i]);
  session.delete(obj);
}

and this will generate 3 select sql commands and 3 delete sql commands,
I don't think this is a good to do it ,Who can give me some suggestion?

Best Wishes.

anthony · **Posted:** Thu Aug 19, 2004 1:49 am

for massive update or delete, do it in jdbc

with orm you'll generally have one select/update or one select/delete

JavaJason · **Joined:** Thu Jul 22, 2004 4:32 am **Posts:** 31

thank you