session.delete(query)

croudet · **Joined:** Mon Apr 19, 2004 6:54 pm **Posts:** 79

Hi,

I would like to do a delete several objects with a query like that
"from Device d where d.id in (:idlist)".

With a query, I will use query.setParameterList("idlist", ids) to bind the named parameter.
How can I do that with the session.delete() ?

Christophe

dcjarvis · **Posted:** Thu Jun 17, 2004 1:55 pm

Looks like you are having fun learning too! Here's what I did...

I did a query.list() to retrieve a list of all objects that satisfy the query, then call session.delete(Object) on each of them. If you're not familiar with query.list, you can also use either session.find() for a full list of objects all in memory at the same time, or session.iterate() to bring them back one by one... at the expense of executing SQL for each row.

Code:

   try {
      session = hSessFact.openSession();
   }
   catch(HibernateException e) {
      logger.error("Could not create Hibernate Session.", e);
      throw e;
   }
   try {
      Query query = session.getNamedQuery("ConxxxxRequest_by_job_id");
      query.setString("JOBID", jobName);
      tx = session.beginTransaction();
      jobList = query.list();
      ListIterator li = jobList.listIterator();
      while(li.hasNext()) {
         ConxxxxRequest request = (ConxxxxRequest)li.next();
         session.delete(request);
      }
      tx.commit();
   }
   catch(Exception e) {
      if(tx != null) { 
         tx.rollback();
      }
      logger.error("Hibernate processing error.", e);
   }
   finally {
      session.close();
   }