Hi,

I'm wondering if somebody know an existing framework allowing to version control objects stored in DB and to allows functions such as:
- baseline
- branch
- checkin
- checkout
- revise
- ...


If no tool exists, I'm wondering what is the best solution... I'm planning to somehow *tag* the versionable objects. In that case, the hibernate mapping of the object will be cut in 2 tables:
- Master : stores the object unique reference
- Slave : stores the version dependents object

Then the DAO will have to handle the above listed functions and the pojo objects must unify the master/slave transparently to user.

I still have no idea how to implement that neither how to *automate* it based on a *tag on the pojo*.



I would be glad to ear any comment / suggestion / lead ....
Thks for your help.

Have you considered triggers?

They run on a databse level, that means that they are: fast, reliable, client agnostic. Of course, with complex OR mappings maintainig such triggers would be difficult. But the performance would be always much better than with middle tier solutions.

I did considered triggers.

Problems with trigger are:
- Protability : I expect my application to be available on several databases with minimum customisation
- Triggers can automate the creation of new version but when you reach to checkin / checkout / retrieve a baseline, it requires a user interaction and therefore it must be handled through the dataaccess layer...

Does hibernate inheritance mapping have to match pojo's inheritance ?

Look at subversion's model for versioning, it has a very powerful approach to tagging. But that doesn't really answer your question.