


## Why Does Hibernate Criteria with FetchType.EAGER Result in Duplicate Order Objects?
Oct 26, 2024 am 03:50 AMHibernate Criteria Returns Multiple Repeated Orders with FetchType.EAGER
Problem:
When using a Hibernate Criteria with FetchType.EAGER for a one-to-many relationship, the resulting list contains multiple copies of the same Order object.
Original Code:
<code class="java">public List<OrderTransaction> getOrderTransactions() { return orderTransactions; }</code>
Modified Code with FetchType.EAGER:
<code class="java">public List<OrderTransaction> getOrderTransactions() { return orderTransactions; }</code>
Question:
Why does the modified code with FetchType.EAGER result in multiple copies of the Order object?
Answer:
This behavior is expected when enabling eager fetching. A join is performed between the Order and OrderTransaction tables, resulting in the same number of rows as a regular SQL join. Therefore, each Order object appears multiple times, corresponding to the number of related OrderTransaction records.
Explanation:
An outer join is used when fetching data with FetchType.EAGER. This means that even if an Order has no related OrderTransaction records, it will still be included in the result set. The result is a list of Order objects, each potentially associated with multiple OrderTransaction objects.
Solution:
To avoid multiple copies of the Order object, consider using a set instead of a list to prevent duplicates. Alternatively, use a DistinctRootEntity in the Criteria query, which explicitly specifies the distinct Order objects to be returned.
Example:
<code class="java">Criteria criteria = getHibernateSession() .createCriteria(Order.class) .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY) .add(Restrictions.in("orderStatus", orderFilter.getStatusesToShow()));</code>
The above is the detailed content of ## Why Does Hibernate Criteria with FetchType.EAGER Result in Duplicate Order Objects?. For more information, please follow other related articles on the PHP Chinese website!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Top 4 JavaScript Frameworks in 2025: React, Angular, Vue, Svelte

How does Java's classloading mechanism work, including different classloaders and their delegation models?

Iceberg: The Future of Data Lake Tables

How can I use JPA (Java Persistence API) for object-relational mapping with advanced features like caching and lazy loading?

Spring Boot SnakeYAML 2.0 CVE-2022-1471 Issue Fixed

How do I implement multi-level caching in Java applications using libraries like Caffeine or Guava Cache?

How do I use Maven or Gradle for advanced Java project management, build automation, and dependency resolution?

Node.js 20: Key Performance Boosts and New Features
