cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lon Varscsak <>
Subject Re: Order of insert/update/delete operations
Date Tue, 01 Aug 2017 22:40:17 GMT
I think in EOF I handled this with a custom ordering of operations, where I
had a master list of entities in the order I wanted operations to perform
(and then reversed them for deletes).  Maybe there’s some way to do this
with Cayenne, but it’s not immediately evident to me where.


On Tue, Aug 1, 2017 at 3:37 PM, Lon Varscsak <> wrote:

> Hey guys, so Cayenne does db operations in insert/update/delete
> order…which makes sense in most cases.  But in Sybase I don’t have deferred
> constraints (it’s not an option) and if I delete an object and then
> recreate it will the same primary key I end up with a database error
> because it tries to insert a duplicate row into the database.
> Originally I had changed the order of operations in my fork to
> update/delete/Insert which solves this problems and works in all cases
> (that I use) except for one.  That’s where you need to insert a row to get
> it’s id (identity) which would then be used in an update operation for a FK.
> It’s possible I’m the only one that uses Sybase, but just looking for some
> thoughts on how I could go about solving this.  I can’t think of a
> straightforward case.
> Thanks,
> Lon

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message