Now back to PK issue... You have to take into account that PK cache is
shared within DataDomain.
So if all users access the same physical tables, no matter what the user
login is, you must set up PK sequences to be shared by all users as well.
Separate PK sequence per schema will result in a conflict (probably this
is what you are seeing already).
If each schema has its own independent tables, then you should go with
per-schema sequences and (important!) set PK cache size to 1 on both DB
sequence and Cayenne PK generator.
Andrus
This archive was generated by hypermail 2.0.0 : Mon Jan 10 2005 - 10:54:49 EST