Hibernate Community • View topic - How to remove soft deleted entities in associations

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to remove soft deleted entities in associations

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

fiz

Post subject: How to remove soft deleted entities in associations

Posted: Mon Jan 30, 2017 9:01 am

Newbie

Joined: Mon Jan 30, 2017 7:59 am
Posts: 1

Hello everyone.
In my task I can't delete rows from DB, instead use boolean column "deleted".
All "select" queries with "where deleted = false" solved my problem.

But what I can do wtih relationship table?
Example we have "board" and "window" entity and "boards_windows" relationship table.
In "board" i have mapping to "window", and Hibernate mapping all rows(windows) although I need only those who "deleted = false".

Thanks.

Top

vlad

Post subject: Re: option: 'delete', instead real deletion

Posted: Tue Jan 31, 2017 4:18 am

Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1628
Location: Romania

You need to use the @JoinFormula annotation so that you provide the deleted = true condition.

Considering that you mapped the board_window using a link entity, BoardWindow which has 2 @ManyToOne associations, one to Board and one to Window, and that the BoardWindow.

Code:

@ManyToMany(fetch = FetchType.LAZY)
@JoinFormula(
    "( SELECT bw.window_id FROM boards_windows bw WHERE bw.board_id = id and bw.deleted = false )"
)
private List<Window> windows = new ArrayList()<>;

Check out this article for more details on how @JoinFormula works.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum