Hibernate inserts duplicates into a @OneToMany collection
It's a bug in Hibernate. Surprisingly, it's not reported yet, feel free to report it.
Operations against non-initialized lazy collections are queued in order to execute them after collection is initialized, and Hibernate doesn't handle the situation when these operations conflict with the data from the database. Usually it's not a problem, because this queue is cleared upon flush()
, and possible conflicting changes are propagated to the database upon flush()
as well. However, some changes (such as persisting of entities with ids generated by generator of type IDENTITY
, I guess, it's your case) are propagated to the database without the full flush()
, and in these cases conflicts are possible.
As a workaround you can flush()
the session after persisting the child:
em.persist(child);
em.flush();
I fixed this problem by telling Hibernate not to add duplicates in my collection. In your case change the type of your children
field from List<Child>
to Set<Child>
and implement equals(Object obj)
and hashCode()
on the Child
class.
Obviously this will not be possible in every case, but if there is a sane way to identify that a Child
instance is unique then this solution can be relatively painless.
I came across this question when I had issues not with adding items to a list annotated with @OneToMany, but when trying to iterate over the items of such a list. The items in the list were always duplicated, sometimes a lot more than twice. (Also happened when annotated with @ManyToMany). Using a Set was not a solution here, since these lists were supposed to allow duplicate elements in them.
Example:
@OneToMany(mappedBy = "parent", fetch = FetchType.EAGER)
@Cascade(CascadeType.ALL)
@LazyCollection(LazyCollectionOption.FALSE)
private List entities;
As it turned out, Hibernate executes sql statements using left outer join
, which can result in duplicate results returned by the db. What helped was simply defining an ordering on the result, using OrderColumn:
@OrderColumn(name = "columnName")