spring - Trying to delete a record from a parent entity java class -

i have 2 entity java classes . trying delete record parent entity throwing error : org.hsqldb.hsqlexception: integrity constraint violation: foreign key no action; sys_fk_10142 table: child.

**parent class** @entity @table(name = "parent") public class parent {   @id   @generatedvalue(strategy = generationtype.identity)   private long id;   @notblank   @column(name = "data")   private string data;   public long getid()   {     return id;   }   public void setid(long id)   {     this.id = id;   }    public string getdata()   {     return data;   }    public void setdata(string data)   {     this.data = data;   } }  **child class**  @entity @table(name = "child") public class child {   @id   @generatedvalue(strategy = generationtype.identity)   private long id;    @notblank   private string model;    @manytoone()   @ondelete(action= org.hibernate.annotations.ondeleteaction.cascade)   private parent parent;    public long getid()   {     return id;   }    public void setid(long id)   {     this.id = id;   }    public string getmodel()   {     return model;   }    public void setmodel(string model)   {     this.model = model;   } } 

since you're deleting parent record , expecting associated child records deleted, may need bi-directional relationship.

@entity @table(name = "parent") public class parent {    ...    ...    @onetomany(mappedby = "parent", cascade = javax.persistence.cascadetype.remove)    private list<child> children;  }  @entity @table(name = "child") public class child {    ...    ...    @manytoone    @joincolumn(name="parent_id", referencedcolumnname="id")    private parent parent;   }