Spring Boot 3中JPA多对多关联更新异常求助

核心原因 #

1. 双向多对多关联未同步维护：JPA不会自动同步双向关联的两端集合，仅删除Character实体时，数据库中间表的关联记录会被删除（若Character是关联拥有方），但内存中已加载的Book对象的characters集合不会自动移除无效引用。
2. 一级缓存（持久化上下文）缓存旧数据：已加载到Session中的Book实体不会主动从数据库重新刷新，即使数据库中的关联已被清除，缓存中的对象仍保持旧状态。
3. 自定义@Modifying Query未同步内存状态：手动删除中间表关联的SQL仅修改数据库，但未更新内存中Book实体的集合，且flush操作仅将上下文变更刷到数据库，不会刷新已有缓存对象。

解决方案 #

方案1：手动同步双向关联集合（推荐） #

在删除Character前，先遍历其关联的所有Book，从Book的characters集合中移除当前Character，确保内存与数据库状态一致。

实体定义（正确配置双向关联）

@Entity
public class Book {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String title;
    
    // 由Character端维护关联（mappedBy指定关联拥有方）
    @ManyToMany(mappedBy = "books")
    private Set<Character> characters = new HashSet<>();

    // getter、setter
    public Set<Character> getCharacters() {
        return characters;
    }
}

@Entity
public class Character {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    
    // 关联拥有方，定义中间表
    @ManyToMany
    @JoinTable(
        name = "book_character",
        joinColumns = @JoinColumn(name = "character_id"),
        inverseJoinColumns = @JoinColumn(name = "book_id")
    )
    private Set<Book> books = new HashSet<>();

    // 封装关联维护方法，避免手动操作出错
    public void addBook(Book book) {
        this.books.add(book);
        book.getCharacters().add(this);
    }

    public void removeBook(Book book) {
        this.books.remove(book);
        book.getCharacters().remove(this);
    }

    // getter、setter
    public Set<Book> getBooks() {
        return books;
    }
}

删除逻辑实现

@Service
@Transactional
public class CharacterService {
    private final CharacterRepository characterRepository;
    private final BookRepository bookRepository;

    // 构造注入（替代@Autowired）
    public CharacterService(CharacterRepository characterRepository, BookRepository bookRepository) {
        this.characterRepository = characterRepository;
        this.bookRepository = bookRepository;
    }

    public void deleteCharacter(Long characterId) {
        Character character = characterRepository.findById(characterId)
                .orElseThrow(() -> new IllegalArgumentException("Character not found"));
        
        // 遍历关联的Book（用新集合避免遍历中修改原集合引发异常）
        for (Book book : new HashSet<>(character.getBooks())) {
            book.getCharacters().remove(character);
            bookRepository.save(book);
        }
        
        characterRepository.delete(character);
    }
}

方案2：清除一级缓存或重新加载Book #

如果不想手动维护关联集合，可在删除操作后清除持久化上下文缓存，或重新查询Book以获取最新状态。

自定义Repository方法

@Repository
public interface CharacterRepository extends JpaRepository<Character, Long> {
    @Modifying
    @Query(value = "DELETE FROM book_character WHERE character_id = :characterId", nativeQuery = true)
    void deleteBookCharacterAssociations(Long characterId);
}

删除逻辑实现

@Service
@Transactional
public class CharacterService {
    private final CharacterRepository characterRepository;
    private final EntityManager entityManager;

    public CharacterService(CharacterRepository characterRepository, EntityManager entityManager) {
        this.characterRepository = characterRepository;
        this.entityManager = entityManager;
    }

    public void deleteCharacter(Long characterId) {
        // 先删除中间表关联
        characterRepository.deleteBookCharacterAssociations(characterId);
        // 删除Character实体
        characterRepository.deleteById(characterId);
        
        // 清除整个持久化上下文缓存，后续查询会从数据库重新加载
        entityManager.clear();
        
        // 若仅需刷新特定Book，可使用：
        // Book book = bookRepository.findById(bookId).orElseThrow();
        // entityManager.refresh(book);
    }
}

方案3：利用JPA自动清除中间表关联（需确保关联拥有方正确） #

若Character是多对多关联的拥有方（即@JoinTable定义在Character中），删除Character时JPA会自动删除中间表的关联记录，但仍需重新加载Book以更新内存状态：

@Service
@Transactional
public class CharacterService {
    private final CharacterRepository characterRepository;
    private final BookRepository bookRepository;

    public CharacterService(CharacterRepository characterRepository, BookRepository bookRepository) {
        this.characterRepository = characterRepository;
        this.bookRepository = bookRepository;
    }

    public void deleteCharacter(Long characterId) {
        characterRepository.deleteById(characterId);
        
        // 重新查询Book获取最新状态
        Book book = bookRepository.findById(bookId).orElseThrow();
    }
}

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