Hello

I have a query that returns a list of primary keys



and I need to delete the list.

question: is there any way to delete the list at once?

example

Hi,

What is the query that you pass to get the List of keys??

If you are deleting based on PK:
you have to option of deleting with session.delete() or use HQL through manual iteration..


If you are deleting based on some field:
1) use HQL to delete the row giving your field on the where clause.
String hqlDelete = "delete Customer c where c.name = :oldName";
int deletedEntities = s.createQuery( hqlDelete )
.setString( "oldName", oldName )
.executeUpdate();

2) session.delete("select customer FROM Customer as customer where customerType = 'XXXX'");

If you are using Spring Hibernate Template:
1) HibernateTemplate.deleteAll(Collection)
2) getHibernateTemplate().bulkUpdate(”delete from Customer where customerType = ?”, type);

Hope this helps...If not elaborate:-)

I need something like this, but instead of oldName I need to put a list


there is some way?

Hi,
you can use this; I am not sure if you key is a composite key.

Try this

String hqlDelete = "delete Item i where i.id = :ids";
int deletedEntities = session.createQuery( hqlDelete ).setParameterList("ids", keys).executeUpdate();

where keys is a list of your keys.

What is the type of your composite key?

Hope this help