How can I delete member of a collection without fetching it from a one-to-many association using hibernate criteria or hql?

Question

I have a one-to-many association from Institution -> Course where an institution can handle multiple courses. For this use case consider a course can only belong to one institution.

@Entity 
Institution {
@Id
long id;
@JoinTable(name = "INSTITUTION_COURSES", joinColumns = @JoinColumn(name = "INSTITUTION_ID"), inverseJoinColumns = @JoinColumn(name = "COURSE_ID"))
Set<Course> coursesOffered;
}

@Entity
Course{
@Id
long id;
@Column
String name;
}

And their map is stored in seperate table

How can I delete a course using HQL or Hibernate criteria without fetching the Institution object and the associated collection such that the corresponding rows in the mapping table are also removed.

Answer 1

Are you doing something like this inside a transactional context? ...

Institution institution = institutionDAO.findById(institutionId, false);
institution.getCourses().remove(course);

institution = institutionDAO.mergeState(institution);