Hi,

I have a many-to-many relationship,. Let

Hmmm.... For me both options are identical. In order to implement #1, you need to write query which will return all employees who has specific role and then iterate this list. For #2 you do absolutely the same - you write HQL query which searches for employees who has specific role and pass this query to session.delete() to let Hibernate do the iteration+delete.

So #2 is little less coding but absolutely the same idea. See the sources - session.delete(hqlQuery) has:

Thanks for your answer.

The many-to-many table is generated by Hibernate. I don

You can not delete collection entries with query as far as I know. You need to load parent object and remove entries from its set. Hibernate will update database appropriately.

I suppose your SELECT query should look like




Nost sure though. See http://www.hibernate.org/hib_docs/refer ... anguage-s6 for details

Oops,

employee.priveleges as level

I ended up adding a list of employees (with lazy loading) to the SecurityLevel class.

When I want to reset the privilieges, I empty the list, add the authorized employees, and save the security object.
Everything is being taken care of by Hibernate.

I thought there was a way of doing the same thing without having to declare an employee list in the SecurityLevel class, but apparently not.
Thank you for your help.

-Vincent.