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

1

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)

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Dec 12, 2012 at 15:33

Emil Gotsev

2232 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jerodev Over a year ago

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

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related