#40 Version ID inside BO is out of sync with version ID on DB af

[bjlai]

Given the following relationship:

direct_order extends client_order which extends order

With an instance of direct_order I modify its contents
then call saveChanges(). I then modify it again and
call saveChanges() again it then throws:

PSUpdateDataIntegrityViolationException: Unable to
update ClientOrder record with Instance Id 0-2d-sn

From the SQL output you can see the e_order goes from
version 3 to 4 then 4 to 5, as expected.

But because e_client_order has no modifications it goes
from version 3 to 4 for the first saveChanges() and
then 3 to 4 again which throws the exception.

DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: About to execute SQL
statement: UPDATE e_order SET versionid = ? ,state = ?,
a_last_modified_timestamp = ?, a_price = ? WHERE
recordid = ? AND versionid = ?;
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 1 value: 4
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 2 value: Open
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 3 value:
27/04/2006 10:00:05
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 4 value: 3930
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 5 value: 0-2d-sn
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 6 value: 3
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: About to execute SQL
statement: UPDATE e_client_order SET versionid = ?
WHERE recordid = ? AND versionid = ?;
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 1 value: 4
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 2 value: 0-2d-sn
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 3 value: 3
DEBUG 10:00:05.566 [Thread-27]
oracleimpl.PSDirectOrderImpl: About to execute SQL
statement: UPDATE e_direct_order SET versionid = ?
WHERE recordid = ? AND versionid = ?;
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 1 value: 4
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 2 value: 0-2d-sn
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 3 value: 3
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: About to execute SQL
statement: UPDATE e_order SET versionid = ?,
a_last_modified_timestamp = ? WHERE recordid = ? AND
versionid = ?;
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 1 value: 5
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 2 value:
27/04/2006 10:00:05
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 3 value: 0-2d-sn
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 4 value: 4
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: About to execute SQL
statement: UPDATE e_client_order SET versionid = ?,
a_client_order_i_d = ? WHERE recordid = ? AND versionid
= ?;
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 1 value: 4
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 2 value: 2ics-180
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 3 value: 0-2d-sn
DEBUG 10:00:05.581 [Thread-27]
oracleimpl.PSDirectOrderImpl: Parameter 4 value: 3

[Rost Vashevnik]

Logged In: YES
user_id=883678

Hello !

This message is to notify you that someone from MetaBoss team
have had a look at your bug report, it was accepted and is
now awaiting the resolution. This means that someone from the
MetaBoss team will have a closer look at it and formulate a
response to you (most likely within 48 hours).

Please note that in addition to the Sourceforge support facilities
we maintain a FAQ and Forum at www.metaboss.com. If you have
not already done so, we suggest that you visit our site and search
for possible workarounds.

Please also note that all MetaBoss users are free to use any
support channel they like, however, in order to enjoy VIP Support,
MetaBoss Commercial License Holders must submit their questions
to the Forum at www.metaboss.com.

Thank you for your contribution to MetaBoss

MetaBoss team

[Rost Vashevnik]

Logged In: YES
user_id=883678

The bug reported in this message has been fixed and
will be available in the next release.

Thank you for your contribution to MetaBoss

MetaBoss team