Hi !
I would like to do some DELETEs and INSERTs in one transaction, but
since DELETE is made after the INSERTs, it deletes the fresh inserted
values...
Is there a way to force cayenne to do DELETE before all others
operations when a commit occurs ?
What means the "snapshot version changed, don't know what to do"
messages ?
Thanks.
Laurent Marchal.
#
# LOG
#
--- will run 2 queries.
--- transaction started.
INSERT INTO dbo.SNAME_AUX (SAFC, SASEQNO, SAVALUE, SKDID) VALUES (?, ?,
?, ?)
[batch bind: 1->SAFC:112, 2->SASEQNO:2, 3->SAVALUE:'1', 4->SKDID:505]
[batch bind: 1->SAFC:112, 2->SASEQNO:1, 3->SAVALUE:'352', 4->SKDID:505]
[batch bind: 1->SAFC:112, 2->SASEQNO:0, 3->SAVALUE:'517', 4->SKDID:505]
=== updated 3 rows.
DELETE FROM dbo.SNAME_AUX WHERE SAFC = ? AND SASEQNO = ? AND SKDID = ?
[batch bind: 1->SAFC:112, 2->SASEQNO:1, 3->SKDID:505]
=== updated 2 rows.
snapshot version changed, don't know what to do... Old:
[EMAIL PROTECTED], SAVALUE=517,
SAFC=112, SKDID=505}, version=-9223372036854712970,
replaces=-9223372036854775808], New:
[EMAIL PROTECTED], SAVALUE=517,
SAFC=112, SKDID=505}, version=-9223372036854712775,
replaces=-9223372036854775808]
snapshot version changed, don't know what to do... Old:
[EMAIL PROTECTED], SAVALUE=1,
SAFC=112, SKDID=505}, version=-9223372036854712971,
replaces=-9223372036854775808], New:
[EMAIL PROTECTED], SAVALUE=1,
SAFC=112, SKDID=505}, version=-9223372036854712777,
replaces=-9223372036854775808]
postSnapshotsChangeEvent: [SnapshotEvent] source:
[EMAIL PROTECTED], deleted 1 id(s),
indirectly modified 1 id(s)
