hibernate - delete from many-to-many

Question

I have the following two POJOs:

@Entity(name = "project") @Table(name = "project") public class Project { @Column(name = "identifier") @Id @GeneratedValue private Integer identifier; @ManyToMany(cascade = CascadeType.ALL) private Set<Member> members = new HashSet<Member>(); // --- constructors --- public Project() { } // --- getters --- public Integer getIdentifier() { return identifier; } public Set<Member> getMembers() { return members; } }

and

@Entity(name = "member") @Table(name = "member") public class Member { @Column(name = "identifier") @Id @GeneratedValue private Integer identifier; @Column(name = "name", columnDefinition = "text") private String name; @ManyToMany(mappedBy = "members") private Set<Project> projects = new HashSet<Project>(); // --- constructors --- public Member() { } // --- getters --- public Integer getIdentifier() { return identifier; } public String getName() { return name; } public Set<Project> getProjects() { return projects; } }

What is common practise do delete from a many-to-many relation? The following code works perfectly, but it generates a lot of overhead. First, there are some queries:

1 query to get the projects, triggered by member.getProjects()
N queries to get all members of the each project, triggered by project.getMembers()

Second, the complete data set of the project (query 1) and member (query 2) is fetched, and not only the identifier.

final Member member = ...; for (final Project project : member.getProjects()) { project.getMembers().remove(member); } db.delete(member);

Is it possible to do this more efficient without being forced to write ad-hoc queries?

Community · Accepted Answer · 2017-05-23 10:26:37Z

1

Take a look here:

How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?

Additionally you have the option to use jpql statements to delete data:

http://docs.oracle.com/html/E24396_01/ejb3_overview_query.html#ejb3_overview_query_delete

But I think the first link is what you are looking for.

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Sep 14, 2014 at 20:18

treeno

2,6002 gold badges23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

John Riope Over a year ago

I might be wrong, but the first link proposes what I am doing here. However, my concern is that it generated a lot of query/data overhead.

treeno Over a year ago

Well you'r right that will produce some overhead, but as far as I know this is the common way. However, did you try out the jpql solution? That should work with very few Statements.

Collectives™ on Stack Overflow

hibernate - delete from many-to-many

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related