On 9/08/11 8:45 AM, Joseph Senecal wrote:
Thanks to the help provided from this mailing list, my prototype was done on
time and shows that the concept can work.
The next problem to solve is how to get a Cayenne program to peacefully coexist
with legacy WebObjects programs that will be inserting records into the same
table. I can restrict the conflict to one table, but that one table is central
to all others and new records could be created by any process that loads any of
the related fact tables.
The problem is that Cayenne and WebObjects use differently named sequences to
allocate primary keys. These sequences are also formatted differently because
WebObjects allocates primary keys one at a time where Cayenne allocates primary
keys 20 at the time. The obvious solution is to configure the sequences for
different primary key ranges. The problem is that these programs will be
running at over a dozen different sites, which makes monitoring for exhausting
of an assigned range problematic. My boss would find a different solution, if
one is possible.
I'm sure that combining multiple ORM's has happened before. Does anyone have
advice as to the best way to make them play nicely together?
Joe
The other solution is to move to a database generated PK for this table.
Ari
--
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
