Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forums[CDO] Postgres Reference List update problem
https://www.eclipse.org/forums/index.php/mv/msg/814508/1426396/#msg_1426396
With postgres I encountered sometimes problems with reference lists.
If you add some EObjects or remove some EObjects an exception like this may occur:
Batch-Eintrag 2 UPDATE MODEL1_PRODUCT1_ORDERDETAILS_LIST SET CDO_IDX=CDO_IDX+3 WHERE CDO_SOURCE=5 AND CDO_IDX BETWEEN 2 AND 5 /*! ORDER BY CDO_IDX DESC */ wurde abgebrochen. Rufen Sie 'getNextException' auf, um die Ursache zu erfahren.
I have added a JUnit test with the problem.]]>Per Sterner2014-09-18T17:42:50-00:00Re: [CDO] Postgres Reference List update problem
https://www.eclipse.org/forums/index.php/mv/msg/814508/1426777/#msg_1426777
workaround: http://stackoverflow.com/questions/16735950/update-with-order-by]]>Per Sterner2014-09-19T07:47:13-00:00Re: [CDO] Postgres Reference List update problem
https://www.eclipse.org/forums/index.php/mv/msg/814508/1431150/#msg_1431150
real life too.
Should I try to make my own fix or could there be a workaround.
(In one situation I already replace the complete list instead of modifying it. Of course I want to remove this one.)
]]>Per Sterner2014-09-25T09:18:26-00:00Re: [CDO] Postgres Reference List update problem
https://www.eclipse.org/forums/index.php/mv/msg/814508/1434513/#msg_1434513
https://bugs.eclipse.org/bugs/show_bug.cgi?id=445443]]>Per Sterner2014-09-30T07:29:34-00:00