If I save an object containing the following list
@OneToMany(cascade=CascadeType.ALL, mappedBy="taskList")
@OrderColumn(name="position", nullable=false)
public List<Task> tasks = new ArrayList<Task>();
I get the exception
org.hibernate.HibernateException: Found two representations of same collection
The code in the Play! controller looks like this:
TaskList taskList = taskList.findById(taskListId);
taskList.add(position, task);
taskList.save();
If I insert taskList.refresh()
before this block it works, but the position information is lost (which leads to other errors).
Is this a Hibernate bug or is something wrong with my code?
The problem was, that Hibernate does not support the combination of @OneToMany(mappedBy=...)
and @OrderColumn
. Without mappedBy
Hibernate uses a join table and everything works as expected. See explanation.
If you need the list to be persisted you might need to annotate your list with @OneToMany to be able to persist your entity.
Another reason for the exception "org.hibernate.HibernateException: Found two representations of same collection" is duplicated getters/setters in the entity.
The same error occurs when you try to modify an associated collection of an object. e.g.:
MyObject myObject = myObjectService.get(id);
List<Task> newTasks = //populate new list of Task here
myObject.setTasks(newTasks);
myObjectService.saveOrUpdateObject(myObject); // or merge(myObject)
In such a case, it can be resolved by:
MyObject myObject = myObjectService.get(id);
List<Task> newTasks = //populate new list of Task here
myObject.setTasks(new List<Task>); // or myObject.getTasks().clear();
myObject.getTasks().addAll(newTasks);
myObjectService.merge(myObject);
the problem is with your joining check whether you are not fatching any data which is not in the table