Unfortunately I've been inactive for a while but now i've more time to work on Jackrabbit which is good . I created a second patch for this issue which also addresses the upgrade scenario that Dominique mentioned:
- Added the LOCAL_REVISIONS table to the create scripts (*.ddl)
- Added InstanceRevision interface
- The InstanceRevision is now retrieved through the Journal instance
- Added logic to the DatabaseJournal to migrate to a db based InstanceRevision,
and (ii) start a janitor thread for cleaning up old cluster revision entries
I've tested the patch only on MSSQL, MySQL and Oracle, because I don't have access to the other databases.
I don't really like the solution for the upgrade scenario (a ddl is scanned for the line that creates the LOCAL_REVISIONS table), but I like the alternative of having twice as many .ddl files even less. But maybe there's a third way...?
Best regards, Martijn