当存在manytomany注释时，Spring data jpa投影重复输出

Question

我有一个user类与一个authority类相关，它们之间有一个manyToMany关系。

@Entity
@Table(name = "user")
public class User {


@Id
@Column(name = "ID")
@GeneratedValue(strategy = GenerationType.AUTO, generator = "user_seq")
@SequenceGenerator(name = "user_seq", sequenceName = "user_seq", allocationSize = 1)
private Long id;

@Column(name = "apiKey", updatable = false, nullable = false, unique=true, columnDefinition = "BINARY(16)")    
private UUID apiKey;


@Column(name = "USERNAME", length = 50, unique = true)
@NotNull
@Size(min = 4, max = 50)
private String username;

@Column(name = "PASSWORD", length = 100)
@NotNull
@Size(min = 4, max = 100)
private String password;

@Column(name = "FIRSTNAME", length = 50)
@NotNull
@Size(min = 4, max = 50)
private String firstname;

@ManyToMany(fetch = FetchType.EAGER)
@JoinTable(
        name = "USER_AUTHORITY",
        joinColumns = {@JoinColumn(name = "USER_ID", referencedColumnName = "ID")},
        inverseJoinColumns = {@JoinColumn(name = "AUTHORITY_ID", referencedColumnName = "ID")})
private List<Authority> authorities;


}

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
    User findByUsername(String username);

    List<UserWithUuid> findAllByNodeId(Long nodeId);  

    interface UserWithUuid {
        String getFirstname();
        String getLastname();       
        String getEmail();
        List<Authority> getAuthorities();
        UUID getApiKey();
    }



}

正如您在输出中看到的，它返回两次相同的用户，但具有不同的角色。

输出

[
    {
        "firstname": "daniel",
        "lastname": "mancera",
        "email": "[e-mail]",
        "apiKey": "7961609f-79d4-4ef2-9baa-6809978c038b",
        "authorities": [
            {
                "id": 1,
                "name": "ROLE_USER"
            }
        ]
    },
    {
        "firstname": "daniel",
        "lastname": "mancera",
        "email": "[e-mail]",
        "apiKey": "7961609f-79d4-4ef2-9baa-6809978c038b",
        "authorities": [
            {
                "id": 2,
                "name": "ROLE_MANAGER"
            }
        ]
    },
    {
        "firstname": "Roger",
        "lastname": "Rabbit",
        "email": "[e-mail]",
        "apiKey": "023bf60b-e79b-461f-bd30-65a920fe99e4",
        "authorities": [
            {
                "id": 1,
                "name": "ROLE_USER"
            }
        ]
    }
]

Answer 1

这很可能是这个Bug https://jira.spring.io/browse/datajpa-1173

Spring Data的当前版本已经修复了这个问题，所以升级您使用的版本应该可以修复这个问题。