选择过程中的冬眠重复行

Question

几个月前，我开始使用Hibernate 5进行冒险。我正在创建一个Spring Boot应用程序，该应用程序需要从数据库视图中获取数据。我创建了一个JPA实体，并编写负责运行查询和将结果映射到ORM实体的代码。问题是Hibernate会在痕迹中生成适当的查询，但将第一行的重复返回为列表。Hibernate创建的查询看起来像：

select
    revenuesum0_.revenueId as revenueI1_9_,
    revenuesum0_.amount as amount2_9_,
    revenuesum0_.calculatedDate as calculat3_9_,
    revenuesum0_.revenueCalculatedDateId as revenueC4_9_,
    revenuesum0_.categoryName as category5_9_,
    revenuesum0_.timeSpan as timeSpan6_9_,
    revenuesum0_.title as title7_9_,
    revenuesum0_.userId as userId8_9_ 
from
    RevenueSummaryView revenuesum0_ 
where
    revenuesum0_.userId=?;

当我在dbeaver上运行它，在MySQL控制台中它可以正常运行，结果集是正确的。当我尝试使用Java JPA查询执行获取数据时，出现问题。负责错误的代码在这里：

    package org.pbt.dao;
    import org.hibernate.Session;
    import org.hibernate.SessionFactory;
    import org.pbt.HibernateUtil;
    import org.pbt.model.entity.ExpenseSummaryView;
    import org.pbt.model.filter.Filter;
    import org.springframework.stereotype.Repository;
    import javax.persistence.Query;
    import java.util.List;

    @Repository
    public class ExpenseSummaryViewDAOImpl implements ExpenseSummaryViewDAO {
        private SessionFactory sessionFactory = HibernateUtil.getSessionFactory();

        @Override
        public List<ExpenseSummaryView> getFiltered(Filter filter) {
            Session session = this.sessionFactory.openSession();
            String hql = "FROM ExpenseSummaryView WHERE userId = :userId ";
            if (filter.getStartDate() != null && filter.getEndDate() != null) {
                hql += "AND calculatedDate BETWEEN :startDate AND :endDate ";
            } else if (filter.getStartDate() != null) {
                hql += "AND calculatedDate >= :startDate ";
            } else if (filter.getEndDate() != null) {
                hql += "AND calculatedDate <= :endDate ";
            }
            Query query = session.createQuery(hql);
            query.setParameter("userId", filter.getUserId());
            if (filter.getStartDate() != null && filter.getEndDate() != null) {
                query.setParameter("startDate", filter.getStartDate());
                query.setParameter("endDate", filter.getEndDate());
            } else if (filter.getStartDate() != null) {
                query.setParameter("startDate", filter.getStartDate());
            } else if (filter.getEndDate() != null) {
                query.setParameter("endDate", filter.getEndDate());
            }
            List<ExpenseSummaryView> expenseSummaryViews = (List<ExpenseSummaryView>) query.getResultList();
            session.close();
            return expenseSummaryViews;
        }
    }

在调试中，整个ExpensemaryViews列表元素具有相同的对象参考。JPA实体看起来像：

package org.pbt.model.entity;
import org.springframework.format.annotation.DateTimeFormat;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.time.LocalDate;

@Entity
@Table(name = "ExpenseSummaryView")
public class ExpenseSummaryView {
    @Id
    @Column(name = "expenseId")
    private int id;
    @Column(name = "expenseCalculatedDateId", nullable = false)
    private int calculatedDateId;
    @Column(name = "userId", nullable = false)
    private int userId;
    @Column(name = "title", nullable = false)
    private String title;
    @Column(name = "amount", nullable = false)
    private double amount;
    @DateTimeFormat(iso = DateTimeFormat.ISO.DATE)
    @Column(name = "calculatedDate", nullable = false)
    private LocalDate calculatedDate;
    @Column(name = "categoryName", nullable = false)
    private String categoryName;
    @Column(name = "timeSpan", nullable = false)
    private String timeSpan;

    public int getId() {
        return id;
    }
    public int getCalculatedDateId() {
        return calculatedDateId;
    }
    public int getUserId() {
        return userId;
    }
    public String getTitle() {
        return title;
    }
    public double getAmount() {
        return amount;
    }
    public LocalDate getCalculatedDate() {
        return calculatedDate;
    }
    public String getCategoryName() {
        return categoryName;
    }
    public String getTimeSpan() {
        return timeSpan;
    }
    @Override
    public String toString() {
        return "{id:" + id + ", calculatedDateId:" + calculatedDateId + ", userId:" + userId + ", title:" + title + ", amount:" + amount + ", calculatedDate:" + calculatedDate.toString() + ", categoryName:" + categoryName + "}";
    }
}

值得一提的是，在非常类似的情况下，我使用Hibernate从同一应用程序中同一DB上的另一个视图中拿起行，并且它正常起作用，但是在上面的情况下，它却没有。

有没有人可以提供帮助？

Answer 1

是由于数据库中没有可用的ID而引起的，而devenseID字段在db中不是真实的ID，在更改后，源代码启动正常工作。