On Aug 4, 2007, at 11:42 PM, james wrote:
The databases that make up this system should behave similar to a repository such as SVN or CVS. There is one "central" repository database, and multiple client databases. A client can only connect to one repository, and a reasonable mechanism should be in place to prevent normal users from connecting a client to a different repository than the one for which it was originally created.
Hmm... while you can probably implement all these things on top of Cayenne, maybe you should use a repository tool instead that does behave like SVN or CVS by design? E.g.:
http://jackrabbit.apache.org/ Andrus