Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.1

Name and version of the database you are using:
Oracle 9i

I want to keep a trace of deleted records in my db :

Tables


Records


After deleting A(1)


I saw that you can specify a where clause for fetching records from the db. Could 'where removed_flag=false' be used in combination with an interceptor that does not delete records but sets the flag instead ?

Or is there any other standard approach for modelling this kind of behaviour ? I guess you could also use some kind of database trigger, but I'm not too familiar with triggers...

Many thanks for all your comments,

Kristof

Instead uf using the delete-function just modify the objects as you wish and save them. When you load your objects, look that you only load the ones, that have deleted=false.

Marking each object explicitely would work, but what do you do when you have a complex object graph ?

I would love to rely on the cascade specification on my methods to properly delete and not bother to calculate this myself.