Why can I only have one field of the type List in my entity class?

Question

When I create a new entity class and want to have more than one List in it, Xpert.ivy says: "If an entity class has more than one collection you have to use 'Set' instead of 'List' as type."

I think the JEE Persistence API does not have this limitation.

Accepted Answer

The JPA itself also has this limitation if the list's are eagerly fetched (which is like this in ivy). Eager means also all entries in the list's are fetched/loaded if the main entity is loaded. If there is more than one list, all relations are loaded with a big join (bad performance) and then jpa (hibernate) has to find the entries for each list, but then this list would have multiple entries of the same id because of the big join, so it is necessary that the type is Set.

The advice is to use no mapped by relations if not relay necessary, because this results in very bad performance.

Example:

type Employee {
  field company Company MANY_TO_ONE;
}
type Company {
  field employees List<Employee> ONE_TO_MANY mapped by company;
}

IF you now load just one employee (e.g. find(Employee.class, 1)) the result is the employee with its company and all employee's in the list of employees of the company. So do not use the employees list of the company, remove it. If you wan to get all employees of a company use a query to find them all.

Answer 2

This does not solve your problem but is some information to understand your problem:

List: Ordered collection of entities, duplicate allowed.
Set: Unordered collection of unique entities, duplicates not allowed.

In JPA there is no such restriction but:

When defining entities you should use 'set' instead of 'list' for collections.

This follows the exact same rules as using different collection types anywhere else throughout your code. You could use Object or Collections for all your references, yet in most cases you use more concrete types.

For example, when I see a List, I know it comes sorted in some way, and that duplicates are either acceptable or irrelevant for this case. When I see a Set, I usually expect it to have no duplicates and no specific order (unless it's a SortedSet). When I see a Collection, I don't expect anything more from it than to contain some entities.

Solution: Change all collections to sets when used in a domain-class.

Why can I only have one field of the type List in my entity class?

Follow this question

Related questions