Java - CascadeType ne fonctionne pas dans la base de données en mémoire - Stack Overflow

I have a webapp with database where two Entities have many-to-many relationship but I implemented join table manually. When one of the entities gets deleted it deletes all entries in the join table and updates the other entity so all works perfectly fine, but now I'm supposed to write a test for this feature. For tests I am using in-memory database and that's really the only difference, the same methods with the same annotations (and cascade types) are called but I keep getting:

org.hibernate.exception.ConstraintViolationException: integrity constraint violation: foreign key no action; FKC17477FD8940DF2B table ENTITY1_ENTITY2

I didn't paste any code as I don't believe there is anything wrong with it since it's working. I don't ask to fix this for me, I just need to know what is likely to cause this kind of behavior because I've just ran out of ideas and I don't know what else to search for... Thanks

EDIT: here's some code:

@Entity
@Table(name = "interviewer")
public class Interviewer implements Identifiable {

    @OneToMany(fetch = FetchType.EAGER)
    @JoinColumn(name = "interviewer_id")
    private Collection<InterviewerTechnology> technologies;
}


@Entity
@Table(name = "technology")
public class Technology implements Identifiable {

    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JoinColumn(name = "technology_id")
    private Collection<InterviewerTechnology> technologies;
}

@Entity
@Table(name = "interviewer_technology")
public class InterviewerTechnology implements Identifiable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    @ManyToOne(cascade = CascadeType.MERGE, fetch = FetchType.LAZY)
    private Interviewer interviewer;

    @ManyToOne(cascade = CascadeType.MERGE, fetch = FetchType.EAGER)
    private Technology technology;
}

@Component
public class TechnologyDao extends AbstractEntityDao<Technology> {

    public void remove(Integer id) {
        Technology technology = find(id);
        em.remove(technology);
    }
}

This code does exactly what I want it to do, it just seems like database used for tests does not see CascadeType parameters that do all the job here

I have a webapp with database where two Entities have many-to-many relationship but I implemented join table manually. When one of the entities gets deleted it deletes all entries in the join table and updates the other entity so all works perfectly fine, but now I'm supposed to write a test for this feature. For tests I am using in-memory database and that's really the only difference, the same methods with the same annotations (and cascade types) are called but I keep getting:

org.hibernate.exception.ConstraintViolationException: integrity constraint violation: foreign key no action; FKC17477FD8940DF2B table ENTITY1_ENTITY2

I didn't paste any code as I don't believe there is anything wrong with it since it's working. I don't ask to fix this for me, I just need to know what is likely to cause this kind of behavior because I've just ran out of ideas and I don't know what else to search for... Thanks

EDIT: here's some code:

@Entity
@Table(name = "interviewer")
public class Interviewer implements Identifiable {

    @OneToMany(fetch = FetchType.EAGER)
    @JoinColumn(name = "interviewer_id")
    private Collection<InterviewerTechnology> technologies;
}


@Entity
@Table(name = "technology")
public class Technology implements Identifiable {

    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JoinColumn(name = "technology_id")
    private Collection<InterviewerTechnology> technologies;
}

@Entity
@Table(name = "interviewer_technology")
public class InterviewerTechnology implements Identifiable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    @ManyToOne(cascade = CascadeType.MERGE, fetch = FetchType.LAZY)
    private Interviewer interviewer;

    @ManyToOne(cascade = CascadeType.MERGE, fetch = FetchType.EAGER)
    private Technology technology;
}

@Component
public class TechnologyDao extends AbstractEntityDao<Technology> {

    public void remove(Integer id) {
        Technology technology = find(id);
        em.remove(technology);
    }
}

This code does exactly what I want it to do, it just seems like database used for tests does not see CascadeType parameters that do all the job here

Source