Hibernate delete object without deleting related objects

Question

I have a database with 3 tables: Slideshows, MediaItemsInSlideshows and Mediaitems. I am using this database with a jsp site using hibernate. I would like to be able to delete a slideshow without deleting the mediaitems. The rows in the MediaItemsInSlideshows should be deleted though.

Currently I use the following code to remove the slideshow. When I use this all mediaitems that were used in the slideshow are gone.

Session session = HibernateUtil.getSessionFactory().openSession(); Slideshow s = this.getSlideshowById(id, session); session.beginTransaction(); session.delete(s); session.getTransaction().commit();

This is a visual representation of the database: enter image description here

Community · Accepted Answer · 2017-05-23 12:29:20Z

Deleting A will set the reference to it in B to null which is forbidden by the schema. An alternative to changing the order of deletions would be to add a reverse one-to-many collection in B, with cascaded deletes. Only the deletion of A would than be needed. (source: Deleting of related objects in hibernate)

I solved it by setting the cascadeType to persist, thanks. :)

Collectives™ on Stack Overflow

Hibernate delete object without deleting related objects

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related