Spring多对多关联更新报错：参数类型不匹配问题排查

我尝试通过JSON更新实体的多对多关联，关联关系为Utente-Ruoli、Ruoli-Privileggi，在JSON DTO中传入Ruoli的ID列表和用户ID，但执行时始终报错。

相关代码 #

Utente JPA仓库方法 #

@Modifying(flushAutomatically = true, clearAutomatically = true)
@Transactional
@Query("UPDATE Utente u SET u.roles = :roles WHERE u.id = :userId")
int saveUserRoles(@Param("userId") Integer userId, @Param("roles") Set<Ruoli> roles);

业务层逻辑 #

public Utente addRolesToUser(RuoliDTO ruoliDTO) {
    log.info("{}.addRolesToUser adding user: {} to list roles: {}", this.getClass().getName(), ruoliDTO.getUser().getUsername(), ruoliDTO.getRoles().size());
    Utente utente = ruoliDTO.getUser();
    Set<Ruoli> rolesToAdd = ruoliDTO.getRoles();
    utente.setRoles(ruoliDTO.getRoles());
    userRepository.saveUserRoles(utente.getId(), rolesToAdd);
    return utente;
}

实体类定义 #

Utente实体

@Entity
@Table(name = "utente")
@Data
public class Utente implements Serializable {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    
    @JsonIgnoreProperties("utenti")
    @ManyToMany(fetch = FetchType.EAGER, cascade = {CascadeType.MERGE, CascadeType.PERSIST})
    @JoinTable(
            name = "utente_ruolo",
            joinColumns = @JoinColumn(name = "utente_id", referencedColumnName = "id"),
            inverseJoinColumns = @JoinColumn(name = "role_id", referencedColumnName = "id")
    )
    private List<Ruoli> roles;
}

Ruoli实体

@Data
@Entity
@Table(name = "ruoli")
public class Ruoli implements Serializable {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    
    @JsonIgnore
    @ManyToMany(cascade ={ CascadeType.MERGE, CascadeType.PERSIST})
    @JoinTable(
            name = "utente_ruolo",
            joinColumns = @JoinColumn(name = "role_id", referencedColumnName = "id"),
            inverseJoinColumns = @JoinColumn(name = "utente_id", referencedColumnName = "id")
    )
    private List<Utente> utenti;
}

Privileggi实体

@Entity
@Data
@Table(name = "privileggi")
public class Privileggi implements Serializable {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    
    @Column(name = "priv_name")
    private String privName;
    
    @Column(name = "description")
    private String description;
    
    @Column(name = "active")
    private Boolean active;
    
    @JsonIgnore
    @ManyToMany( cascade ={ CascadeType.MERGE, CascadeType.PERSIST})
    @JoinTable(
            name = "ruolo_privileggi",
            joinColumns = @JoinColumn(name = "priv_id", referencedColumnName = "id"),
            inverseJoinColumns = @JoinColumn(name = "role_id", referencedColumnName = "id")
    )
    private List<Ruoli> ruoli;
}

报错信息 #

Parameter value [Ruoli{id=2, roleName='ADMIN', description='admin', privileggi=[Privileggi{id=1, privName='UNICACON_MDJS_USER', description='basic user', active=false}, Privileggi{id=3, privName='UNICACON_MDJS_ADMIN', description='admin role', active=true}, Privileggi{id=4, privName='ARCHICON_MDJS_USER', description='archicon role', active=true}]}] did not match expected type [java.util.Set (n/a)]; nested exception is java.lang.IllegalArgumentException: Parameter value [Ruoli{id=2, roleName='ADMIN', description='admin', privileggi=[Privileggi{id=1, privName='UNICACON_MDJS_USER', description='basic user', active=false}, Privileggi{id=3, privName='UNICACON_MDJS_ADMIN', description='admin role', active=true}, Privileggi{id=4, privName='ARCHICON_MDJS_USER', description='archicon role', active=true}]}] did not match expected type [java.util.Set (n/a)]

核心问题 #

1. 集合类型不匹配：Utente实体中roles字段定义为List<Ruoli>，但仓库方法saveUserRoles的参数roles声明为Set<Ruoli>，JPA解析JPQL时发现类型不匹配，抛出参数类型错误。
2. JPQL UPDATE无法直接更新多对多关联：JPA的UPDATE语句仅支持更新实体基本字段或单值关联，无法直接修改集合类型的多对多关联，即使类型匹配也会执行失败。

修复步骤 #

步骤1：统一集合类型 #

将仓库方法的参数类型改为与实体一致的List<Ruoli>：

@Modifying(flushAutomatically = true, clearAutomatically = true)
@Transactional
@Query("UPDATE Utente u SET u.roles = :roles WHERE u.id = :userId")
int saveUserRoles(@Param("userId") Integer userId, @Param("roles") List<Ruoli> roles);

同时调整业务层代码中的集合类型：

public Utente addRolesToUser(RuoliDTO ruoliDTO) {
    log.info("{}.addRolesToUser adding user: {} to list roles: {}", this.getClass().getName(), ruoliDTO.getUser().getUsername(), ruoliDTO.getRoles().size());
    Utente utente = ruoliDTO.getUser();
    List<Ruoli> rolesToAdd = ruoliDTO.getRoles();
    utente.setRoles(rolesToAdd);
    userRepository.saveUserRoles(utente.getId(), rolesToAdd);
    return utente;
}

步骤2：替换JPQL UPDATE为持久化上下文操作（推荐方案） #

由于JPQL无法直接更新多对多集合，更可靠的方式是通过JPA持久化上下文更新关联：

// 仓库层无需自定义UPDATE方法，直接使用Spring Data JPA的save方法
public interface UtenteRepository extends JpaRepository<Utente, Integer> {
}

// 业务层修改为：
public Utente addRolesToUser(RuoliDTO ruoliDTO) {
    log.info("{}.addRolesToUser adding user: {} to list roles: {}", this.getClass().getName(), ruoliDTO.getUser().getUsername(), ruoliDTO.getRoles().size());
    // 从数据库加载持久化状态的用户实体
    Utente utente = userRepository.findById(ruoliDTO.getUser().getId())
            .orElseThrow(() -> new RuntimeException("用户不存在"));
    // 直接设置角色集合，持久化上下文会自动同步到中间表
    utente.setRoles(ruoliDTO.getRoles());
    return userRepository.save(utente);
}

步骤3：优化多对多关联维护 #

由于Utente和Ruoli都维护了多对多关联，建议指定单侧维护关联避免数据不一致：

• 在Utente的@ManyToMany注解中保留@JoinTable配置，作为关联维护端
• 在Ruoli的@ManyToMany注解中添加mappedBy属性，指定由Utente维护关联：

@JsonIgnore
@ManyToMany(mappedBy = "roles", cascade ={ CascadeType.MERGE, CascadeType.PERSIST})
private List<Utente> utenti;

内容的提问来源于stack exchange，提问作者Alex