|[eclipselink-users] One-to-Many ordered list not ordered when cached|
I have a one to many mapping where the many objects should be sorted by a query key.
In my Eclipselink workbench I have set the Advanced Container Options to List and java.util.ArrayList.
The descriptor of my “many objects” calls an After Load method that sets useTransparentCollection() and addAscendingOrdering( "listSeqNo" ).
I have a unit test that creates several instances of the “many objects” and they are created with ascending values on the query key (called “listSeqNo”) as expected.
The unit test then commits the transaction and a subsequent unit test then uses the objects, however the items are retrieved from the cache and are no longer in sorted order.
If I later retrieve the same items from the database via a query the items are retrieved in correct order.
I can not find a way to configure the cache to obey the ordering as dictated by the query key.
I have tried removing the addAscendingOrdering() from my After Load method and setting it in the workbench on the one-to-many mapping (Ordering tab), but this did not help.
I have tried not using a transparent collection (in the After Load method), but this did not help.
I tried several combinations in the Advanced Container Options without success, although I have not tried the TreeSet, since it is not trivial to update our code.
This is a new problem since migrating from Toplink 2.5.1 (ouch). I have tried everything I can think of to try to get this working.
I am using eclipselink-incubation-1.0M9, Java 1.5 and Oracle 9i.
I have found some similar issues but am not sure if they are the same cause, e.g.
Please help with suggestions or information.
Back to the top