Delete Data From Many-to-many Relationship

CustomerEntity class

@Entity(name = "CUSTOMER")

public class CustomerEntity {

   @Id

   @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "customerid-gen")

   @SequenceGenerator(name = "customerid-gen", sequenceName = "CUSTOMER_SEQ", 

      allocationSize = 1, initialValue = 0)

   @Column(name = "CUSTOMER_ID")

   private Integer id;

   private String customerName;

   @ManyToMany(cascade ={CascadeType.ALL})

   @JoinTable(name = "CUST_PHONE", 

      joinColumns = @JoinColumn(name = "CUSTOMER_ID", 

                                 referencedColumnName = "CUSTOMER_ID"), 

   inverseJoinColumns = @JoinColumn(name = "PHONE_ID", 

                                 referencedColumnName = "PHONE_ID"))

   private List<PhoneNumberEntity> phones = new ArrayList<PhoneNumberEntity>();

}

PhoneNumberEntity class

@Entity(name = "PHONE")

public class PhoneNumberEntity {

   @Id

   @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "phoneid-gen")

   @SequenceGenerator(name = "phoneid-gen", sequenceName = "PHONE_SEQ", 

      allocationSize = 1, initialValue = 0)

   @Column(name = "PHONE_ID")

   private Integer id;

   private String phNumber;

   @ManyToMany(cascade ={CascadeType.ALL})

   @JoinTable(name = "CUST_PHONE", joinColumns = @JoinColumn(name = "PHONE_ID",

                   referencedColumnName = "PHONE_ID"),

              inverseJoinColumns = @JoinColumn(name = "CUSTOMER_ID", 

                     referencedColumnName = "CUSTOMER_ID"))

   private List<CustomerEntity> customers;

}

Testing class

CustomerEntity entity = new CustomerEntity("Shambhu");

entity.getPhones().add(new PhoneNumberEntity("(8837199181"));

entity.getPhones().add(new PhoneNumberEntity("(8981518899"));

Integer id = emService.persistCustomer(entity);

             

CustomerEntity customerEntity=emService.findCustomerById(id);

             

List<PhoneNumberEntity> phones= customerEntity.getPhones();

             

for(PhoneNumberEntity entity2:phones){

       System.out.println("Deleting phone id :"+entity2.getId());

       emService.deletePhone(entity2.getId());

       //break;

}