Nsryjdtyk

I am relatively new to hibernate. I am using hibernate with Spring boot 1.5 and I am encountering a strange problem which I have no idea how to fix.

In the image below, you will notice the same email field is repeated.

User Model Object

@Data

@Entity

@Table(name = "user")

@EntityListeners(AuditingEntityListener.class)

@JsonIgnoreProperties(value = {"createdAt", "updatedAt"}, allowGetters = false)

@DynamicUpdate

public class User {

    @Id

    @GeneratedValue(strategy = GenerationType.AUTO)

    private Integer id;

    ...



    private Boolean isActive;



    @OneToMany(mappedBy = "user", orphanRemoval = true, cascade = CascadeType.ALL, fetch = FetchType.EAGER)

    private List<UserEmail> emails = new ArrayList<>();



    @ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)

    @JoinTable(name = "users_roles",

    joinColumns = @JoinColumn(name = "user_id"), inverseJoinColumns = @JoinColumn(name = "role_id"))

    private Set<Role> roles;



    public void addUserEmail(UserEmail email) {

        email.setUser(this);

        this.emails.add(email);

    }



    public void removeUserEmail(UserEmail email) {

        emails.remove(email);

        email.setUser(null);

    }

}

UserEmail Model Object

@Data

@Entity

@EntityListeners(AuditingEntityListener.class)

public class UserEmail {

    @Id

    @GeneratedValue(strategy = GenerationType.AUTO)

    private Integer id;



    @ManyToOne

    @JoinColumn(name = "user_id")

    private User user;



    @Email

    @NaturalId(mutable = true)

    @Column(name = "email", unique = true)

    private String email;

}

But in the database, the email is not actually repeated.

The following is the sql query executed when I want to fetch a user:

Hibernate: select user0_.id as id1_2_0_, user0_.created_at as created_2_2_0_, 

user0_.first_name as first_na3_2_0_, user0_.is_active as is_activ4_2_0_, 

user0_.last_name as last_nam5_2_0_, user0_.password as password6_2_0_, 

user0_.phone as phone7_2_0_, user0_.updated_at as updated_8_2_0_, 

user0_.username as username9_2_0_, emails1_.user_id as user_id3_4_1_, 

emails1_.id as id1_4_1_, emails1_.id as id1_4_2_, emails1_.email as 

email2_4_2_, emails1_.user_id as user_id3_4_2_, roles2_.user_id as 

user_id1_5_3_, role3_.id as role_id2_5_3_, role3_.id as id1_1_4_, role3_.name 

as name2_1_4_ from user user0_ left outer join user_email emails1_ on 

user0_.id=emails1_.user_id left outer join users_roles roles2_ on 

user0_.id=roles2_.user_id left outer join role role3_ on 

roles2_.role_id=role3_.id where user0_.id=1

which gives me the following result

In the picture, we can see that two rows are returned. The sql query constructed by hibernate is somewhat fetching the same email result for each role. I understand (and have cross-checked) that this is happening only in cases of users with more than one role only. Now since the emails are the same, shouldn't hibernate/jpa identify properly and merge the two emails into one?

How do I fix this problem? Any help is appreciated. I understand that my question may not be well-explained so if you have confusions, please ask.