Hi,

I have a problem that is probably pretty common. I have 8 tables in a database of 70, all connected to each other as a single unit with 1 head table. It's basically 1 massive object with lots of collections.

I'd like to version the changes automatically for this entire set of tables/entities without the system actually knowing what's going on. For example, a user can make 3 edits to the root table and several updates to child tables and the system just makes new rows without deleting the others. However, I'd like it so that it works exactly like it would if it was not versioned/archived through hibernate. I'm looking for a solution that is not bloated or adds a lot of programming time.

Is this possible? Can hibernate help me with this?

I won't really be doing much on the past versions other than referencing them in other entities. The problem is that I need to keep a snapshot of the entities as they are at that time. Am I just going about it all wrong?

I just don't want to implement a solution where I have copies of the tables (like shadow tables) or something like that. I don't want this to be a maintenance havoc for me.

Please help.