java - Hibernate delete from onetomany -

i have 2 tables onetomany relation

class serviceprovider {

...

@onetomany(fetch=fetchtype.eager,mappedby="serviceprovider", cascade={cascadetype.all,cascadetype.remove},orphanremoval = true) @ondelete(action=ondeleteaction.cascade) private list servicecenters; ...

}

class servicecenterdetails {

... //bi-directional many-to-one association serviceproviderdomainmap @manytoone @joincolumn(name="service_provider_id") private serviceprovider serviceprovider;

...

}

i trying delete provide row. getting below error:

caused by: com.mysql.jdbc.exceptions.jdbc4.mysqlintegrityconstraintviolationexception: cannot delete or update parent row: foreign key constraint fails (fixoline.service_center_details, constraint fk_qvahoxeovx9vmwl6mcu2c0lyw foreign key (service_provider_id) references service_provider (id))

below way trying

  string hql = "delete serviceprovider id =  :providerid";   query query = sessionfactory.getcurrentsession().createquery(hql);           query.setparameter("providerid",providerid);    int result = query.executeupdate(); 

could pls resolving it?

the error message quite clear: there foreign key references serviceproviders trying delete. delete servicecenterdetails first:

delete servicecenterdetails serviceprovider.id = :providerid