Hi,
I have a list created like this :


The thing is we can have concurrent acces and the list can get more than 1 element in the same order :


And for some reason, hibernate only gets the 0-1 order and not 0-1-1.
On DataNucleus it gets all the item and when it persist back it sets the order correctly.

Is there any ways to get all Item of a list even if order are the same?

Thanks

Try with an @OrderColumn as explained in this article.

I already have @OrderColumn.
When we print out the sql, hibernate gets all the list, but then strip out what is duplicated order.
If we have a list with 0-10 order and remove the 0, hibernate will return an empty list.
Is there a reason for that?
Hibernate should just select all item even if the order is not correct.

Thanks

I don't understand the exact problem. For instance, the @JoinColumn doesn't have much sense on the ManyToMany relationship. Try the examples for the docs or even better, try using two @OneToMany associations as explained in the User Guide.

Let's take for example a simple List<> of any type with @OrderColumn.
In MySQL DB a table will looks like
some_field order_id <-- that is the order used to reconstruct the list.

the order id will start from 0 to n. If, for example, you go in the database directly add another row with the same order of another one, like 4.
The the order will looks like 0, 1, 2, 3, 4, 4, 5.. n.
When you get the list from hibernate it will only return the row with the first 4. The second 4 will get removed.

If instead of adding another row you delete the row with order 0 and then get the list from hibernate, hibernate will crash because there is no order 0.

Is there a way for Hibernate to just get all the data and then order then by order column? So I would get 0 1 2 3 4 4..n instead of just 0 1 2 3 4..n
Or 1, 2, 3 ,4..n instad of nothing.

Am I clearer now?

Thanks

Sure it is. You can use a bidirectional one-to-many association and have the order_id mapped as a regular orderId property on the child-side.
Then, on the mappedBy @OneToMany, you just add the @OrderColumn(name = "orderId") or an @OrderBy("orderId)

If I understand correctly, I will have to handle the order manually, is that right?

Thanks

Hibernate can take care of the order if you use those annotations.

If I do something like this :



Hibernate will auto generate orderID.
After creating some test if I go into the database which looks like this :


And move the orderID from 9 to 8,



If I do a simple get of the user and then for each on all "Test" it will print


If I change from @OrderColumn to @OrderBy without deleting generated table, it works. I get 1 to 9 with 8. But if I start anew (drop table) and put @OrderBy, it does not auto generate orderID.

Is there anyways to let Hibernate autogenerate orderID and still let me fetch every entry, or do I have to handle the order id myself?

I suggest you read the new User Guide because it explains all these mapping in details.
Unidirectional associations use a link table which is where the order column goes too.
What you want is a bidirectional ordered list which can have the order column in the child table.