Hibernate delete entry from association table when one part of association is deleted

Question

i have the following hibernate mapping:

Class Magazine:

@Entity
@Table(name = "PROJECTNAME_MAGAZINE")
@SequenceGenerator(name = "MAGAZINE_SEQUENCE_GENERATOR", sequenceName = "MAGAZINE_SEQUENCE")
@Analyzer(definition = "customanalyzer")
public class Magazine extends AbstractBaseEntity implements Serializable{


@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "MAGAZINE_SEQUENCE_GENERATOR")
@Column(name = "ID")
private Long id;
@NotNull
@Field(index=Index.YES, analyze=Analyze.YES, store=Store.NO)

@LazyCollection(LazyCollectionOption.FALSE)
@OneToMany(cascade = CascadeType.ALL, mappedBy="magazine", orphanRemoval = true)
private List<MagazineKeywordMapper> magazineKeywordMappings;

Class MagazineKeyword

@Entity
@Table(name = "PROJECTNAME_MAGAZINE_KEYWORD")
public class MagazineKeyword extends AbstractBaseEntity {

public MagazineKeyword(String keyword) {
    this.keyword = keyword;
    this.id = (long) keyword.hashCode();
}

@Id
@Column(name = "ID")
private Long id;

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy="keyword",orphanRemoval=true)
private List<MagazineKeywordMapper> magazineMappings;

Class MagazineKeywordMapper

@Entity
@Table(name="MAGAZINE_KEYWORD_MAPPER")
public class MagazineKeywordMapper extends AbstractBaseEntity implements Serializable  {

private static final long serialVersionUID = 1L;

@Id
@Column(name = "ID")
private Long id;

@ManyToOne
    @PrimaryKeyJoinColumn(name="MAGAZINE_ID", referencedColumnName="ID")
    private Magazine magazine;


    @ManyToOne
    @PrimaryKeyJoinColumn(name="KEYWORD_ID", referencedColumnName="ID")
    private MagazineKeyword keyword;

    public MagazineKeywordMapper() {

    }

public MagazineKeywordMapper(Magazine magazine, MagazineKeyword keyword) {
    this.magazine = magazine;
    this.keyword = keyword;
    this.id = Long.parseLong(magazine.getId()+""+keyword.getId());
}

I tried alot of stuff, but somehow i could not manage to find a good way to do deletes on the mappings. If i delete a keyword i want all the mappings containing this keyword to be deleted. Somehow all i get are IntegrityConstraintViolations...what am i doing wrong? I use DAO's and call EntityManager.remove() on the keyword object. I also tried manually removing the mappings from the associated Magazine objects. Any hints are highly appreciated. Thanks for your help guys!:)

score 0 · Answer 1 · answered Mar 18 '14 at 17:59

0

as I see that you not use lazy fetch type. It will solve your problem. Use a similar solution:

@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, mappedBy = "xxx")

answered Mar 18 '14 at 17:59

mig8

122
4

FetchType.Lazy unfortunately doesn't change anything :// – user871784 Mar 24 '14 at 13:52

score 0 · Answer 2 · edited May 23 '17 at 12:05

0

Cascade strategy is what you need to look

Hibernate Documentation

Stackoverflow thread

edited May 23 '17 at 12:05

Community

1
1

answered Mar 19 '14 at 07:21

Balaji Reddy

5,576
3
36
47

I use CascadeType.All with orphanRemoval=true however it still throws the same exception... – user871784 Mar 24 '14 at 13:53

score 0 · Accepted Answer · answered Mar 25 '14 at 11:18

0

Found the problem: i had a constraint on the DB that restricted deletes. Set it to cascade, now everything is working perfectly!

answered Mar 25 '14 at 11:18

user871784

1,247
4
13
32

Hibernate delete entry from association table when one part of association is deleted

3 Answers3