| Re: [eclipselink-users] Design Pattern EJB Facade for CRUD operations |
Hi jz,In a JPA provider, there is more to doing a delete than just removing records from the database. As a minimum, any related objects need to be removed from the persistence context and for configurations that make use of caching, potentially other versions of the object need to be removed as well.
If you are using database-level cascade deletes, you will want to be sure to focus some of your testing on ensuring you get the expected behavior from the persistence context and from the cache after you do that kind of a delete.
Despite those reasons, there is probably an argument that a properly implemented database-level cascade delete could provide some performance benefits. Please feel free to enter an enhancement request.
-Tom jz wrote:
Hi,To remove an entity why does not EclipseLink support db level cascade delete? The schema generated does not contain on cascade delete on constraints. I have to manually change the sql script.Regards, Jehanzeb Qayyum ------------------------------------------------------------------------ _______________________________________________ eclipselink-users mailing list eclipselink-users@xxxxxxxxxxx https://dev.eclipse.org/mailman/listinfo/eclipselink-users