Eclipse Community Forums: EclipseLink » persist a collection in order

Home » Eclipse Projects » EclipseLink » persist a collection in order(persist an entity and its respective collection (OnetoMany) in order)

Show: Today's Messages :: Show Polls :: Message Navigator

persist a collection in order [message #758563]

Wed, 23 November 2011 12:00

FiruzzZ Mising name is currently offline

FiruzzZ Mising name
Messages: 19
Registered: October 2011

Junior Member

Alo..
the issue is that when I persist a Order with a of List<Item> (OneToMany), Item's are persisten randomly without respect the order of the List.
Exam:

order.getItemList().add(item1);
order.getItemList().add(item2);
order.getItemList().add(item3);
persist(order);

When I retrieve (or check directly on the DB) the entity and check the detail, they are disordered.
Sometimes persist first item1, sometimes item2 and so on..

The only way i found to avoid this behavior was persist the Order with a empty collection and then one by one the collections of Item's.

here is fragment of the mapping

//on Order
@OneToMany(cascade = CascadeType.ALL, mappedBy = "order", fetch = FetchType.EAGER)
private List<Item> itemList;

Report message to a moderator

Re: persist a collection in order [message #758619 is a reply to message #758563]

Wed, 23 November 2011 17:46

Piotr Nowicki
Messages: 16
Registered: November 2011
Location: Poland

Junior Member

Are you using @OrderBy or @OrderColumn?

Report message to a moderator

Re: persist a collection in order [message #758728 is a reply to message #758619]

Thu, 24 November 2011 07:22

FiruzzZ Mising name
Messages: 19
Registered: October 2011

Junior Member

would not change anything, because there is no field (column) to determinate the order in which should be persisted (the item.id is still null and autogenerated).
The ORM should respect the order of the items in the collection.

----seconds later Shocked

I could add a transient field to determinate this order!..
BUT "The ORM should respect the order of the items in the collection."

[Updated on: Thu, 24 November 2011 07:25]

Report message to a moderator

Re: persist a collection in order [message #758764 is a reply to message #758563]

Thu, 24 November 2011 09:00

Piotr Nowicki
Messages: 16
Registered: November 2011
Location: Poland

Junior Member

May I ask where did you take this statement from?

Quote:

The ORM should respect the order of the items in the collection.

In a contrary, take a look at JPA 2.0 FR specification:

"JPA 2.0 FR, 2.2 Persistent Fields and Properties"

Collection-valued persistent fields and properties must be defined in terms of one of the following collection-valued interfaces regardless of whether the entity class otherwise adheres to the JavaBeans method conventions noted above and whether field or property access is used: java.util.Collection, java.util.Set, java.util.List, java.util.Map. (...) Portable applications should not expect the order of a list to be maintained across persistence contexts unless the OrderColumn construct is used or unless the OrderBy construct is used and the modifications to the list observe the specified ordering.

Regards.

Report message to a moderator

Re: persist a collection in order [message #758768 is a reply to message #758728]

Thu, 24 November 2011 09:04

Piotr Nowicki
Messages: 16
Registered: November 2011
Location: Poland

Junior Member

May I ask where did you take this statement from?

Quote:
Quote:

The ORM should respect the order of the items in the collection.

In a contrary, take a look at JPA 2.0 FR specification:

"JPA 2.0 FR, 2.2 Persistent Fields and Properties"

> Collection-valued persistent fields and properties must be defined in terms of one of the following collection-valued interfaces regardless of whether the entity class otherwise adheres to the JavaBeans method conventions noted above and whether field or property access is used: java.util.Collection, java.util.Set, java.util.List, java.util.Map. (...) Portable applications should not expect the order of a list to be maintained across persistence contexts unless the OrderColumn construct is used or unless the OrderBy construct is used and the modifications to the list observe the specified ordering.

Regards.

Report message to a moderator

Re: persist a collection in order [message #758771 is a reply to message #758728]

Thu, 24 November 2011 09:05

Piotr Nowicki
Messages: 16
Registered: November 2011
Location: Poland

Junior Member

May I ask where did you take this statement from?

Quote:
Quote:
> The ORM should respect the order of the items in the collection.

In a contrary, take a look at JPA 2.0 FR specification:

"JPA 2.0 FR, 2.2 Persistent Fields and Properties"
> > Collection-valued persistent fields and properties must be defined in terms of one of the following collection-valued interfaces regardless of whether the entity class otherwise adheres to the JavaBeans method conventions noted above and whether field or property access is used: java.util.Collection, java.util.Set, java.util.List, java.util.Map. (...) Portable applications should not expect the order of a list to be maintained across persistence contexts unless the OrderColumn construct is used or unless the OrderBy construct is used and the modifications to the list observe the specified ordering.

Regards.

Report message to a moderator

Re: persist a collection in order [message #758776 is a reply to message #758771]

Thu, 24 November 2011 09:14

FiruzzZ Mising name
Messages: 19
Registered: October 2011

Junior Member

I think it should work that way, make sense.. I don't see the necessity of leave this "issue" to a pseudo random internal mechanisms of THIS (Hibernate doesn't do this) ORM.

PD: why the triple post?

Report message to a moderator

Re: persist a collection in order [message #758780 is a reply to message #758771]

Thu, 24 November 2011 09:14

FiruzzZ Mising name
Messages: 19
Registered: October 2011

Junior Member

I think it should work that way, make sense.. I don't see the necessity of leave this "issue" to a pseudo random internal mechanisms of THIS (Hibernate doesn't do this) ORM.

PD: why the triple post?

Report message to a moderator

Re: persist a collection in order [message #758785 is a reply to message #758780]

Thu, 24 November 2011 09:45

Piotr Nowicki
Messages: 16
Registered: November 2011
Location: Poland

Junior Member

Of course, the JPA provider can do this. It's not forbidden. It's clearly stated that "Portable applications should not expect the order of a list". If you're aware of this and intend to use vendor-specific feature, than it's fine, but you cannot expect portable bahaviour.

PS. I think I'm still not quite sure how this forum works, and what's the difference between 'reply', 'quick reply' and 'post reply'; sometimes my post is shown as separate thread, sometimes like a post within thread. Don't have an idea what's going on Wink

)

Report message to a moderator

Re: persist a collection in order [message #758787 is a reply to message #758780]

Thu, 24 November 2011 09:45

Piotr Nowicki
Messages: 16
Registered: November 2011
Location: Poland

Junior Member

Of course, the JPA provider can do this. It's not forbidden. It's clearly stated that "Portable applications should not expect the order of a list". If you're aware of this and intend to use vendor-specific feature, than it's fine, but you cannot expect portable bahaviour.

PS. I think I'm still not quite sure how this forum works, and what's the difference between 'reply', 'quick reply' and 'post reply'; sometimes my post is shown as separate thread, sometimes like a post within thread. Don't have an idea what's going on ;))

Report message to a moderator

Re: persist a collection in order [message #758821 is a reply to message #758785]

Thu, 24 November 2011 11:10

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

EclipseLink will maintain the order of a List in memory. But can only maintain the order on the database if an OrderBy or OrderColumn is used.

The order you insert objects in to the database has no guarantee that they will come back in that same order. Relational databases are not ordered, the only way to obtain order is to use an order by. Depending on what table pages are free the objects can end up in any order. Selects can also return objects in any order depending on how they process the query.

James : Wiki : Book : Blog

Report message to a moderator

Re: persist a collection in order [message #758822 is a reply to message #758821]

Thu, 24 November 2011 11:11

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

Yes, these forums are screwed up. Please complain to the Eclipse Foundation. It seems any post with a link or code will be duplicated.

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:	persist a collection in order
Next Topic:	How can I check PersistenceContexts for equality

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 18:52:31 EDT 2013