Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Soft Delete

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

paull.williams

Post subject: Soft Delete

Posted: Mon Dec 15, 2008 10:05 am

Newbie

Joined: Mon Dec 15, 2008 9:50 am
Posts: 2

Hi !

I have a requirement for soft delete. Following is the table structure:

Student
-ID
-FirstName
-LastName
-Grade
-DeleteFlag

Problem: How can i have constraints such that i can create only UNIQUE(FirstName,LastName) along with the soft delete approach.

Top

SIau_Tie

Post subject: Re: Soft Delete

Posted: Mon Dec 15, 2008 9:31 pm

Senior

Joined: Wed Sep 19, 2007 9:31 pm
Posts: 191
Location: Khuntien (Indonesia)

paull.williams wrote:

I think you can not have a constraint for this case. Suppose you add unique for firstName, lastName, and deleteFlag, you can only delete once.

Top

Keith Branton

Post subject: Don't us a flag to mark soft deletes - use a timestamp

Posted: Thu Jan 15, 2009 6:49 pm

Newbie

Joined: Thu Jan 15, 2009 6:44 pm
Posts: 1

If you use a timestamp instead of a simple flag you can easily have a unique constraint as you describe.

This has the added advantage of letting you know when something was 'deleted' and simplifies housekeeping tasks such as physically deleting all records that were soft deleted over X months ago - which may be useful if your database is going to get large.

Top

Page 1 of 1

[ 3 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