JPA存在关联关系调用子类中的查询方法不执行sql问题解决

JPA存在关联关系调用子类中的查询方法不执行sql问题解决

场景：
在某个实体类中引入了file实体类并做了一对多的关联关系。
当用户修改此实体类时调用了file自己的update方法，于是引出了file方法中执行findById不执行sql。
特此记录一下！

某个实体类

@Entity
@Data
@Table(name = "art_law_dynamic")
@Where(clause = "deleted=0")
@SQLDelete(sql = "update art_law_dynamic set deleted=1 where id=?")
@SQLDeleteAll(sql = "update art_law_dynamic set deleted=1 where id=?")
public class ArtLawDynamic extends BaseEntity implements Serializable {
    /**
     * 文件多对多关系
     */
    @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.MERGE)
    @JoinColumn(name = "business_id", updatable = false, insertable = false)
    private Set<QiniuContent> files;

    /**
     * 文本标题
     */
    @Column(name = "title")
    private String title;
}

修改方法

	/**
	* 某个实体类的修改方法
	*/
    @Override
    @Transactional(rollbackFor = Exception.class)
    public void update(ArtLawDynamic resources) {
        ArtLawDynamic artLawDynamic = artLawDynamicRepository.findById(resources.getId()).orElseGet(ArtLawDynamic::new);
        ValidationUtil.isNull(artLawDynamic.getId(), "ArtLawDynamic", "id", resources.getId());
        artLawDynamicRepository.save(artLawDynamic);
        //  处理 图片表、
        // 处理 文件表、视频表
        Optional.ofNullable(resources.getFileId()).ifPresent(id -> {
            QiniuContent qiniuContent = new QiniuContent();
            qiniuContent.setBusinessId(resources.getId());
            qiniuContent.setId(id);
            qiNiuService.updateContent(qiniuContent);
        });
    }
    
    /**
	* file文件的修改方法
	*/
	    @Override
    public QiniuContent updateContent(QiniuContent qiniuContent) {
    	//此处是bug出现的地方，这里不进行sql查询
        QiniuContent content = qiniuContentRepository.findById(qiniuContent.getId()).orElseGet(QiniuContent::new);
        ValidationUtil.isNull(content.getId(), "QiniuContent", "id", qiniuContent.getId());
        content.copy(qiniuContent);
        return qiniuContentRepository.save(content);
    }

解决办法：

在调用file的update之前使用entityManager.clear();之后再使用entityManager.merge(T t);就可以啦。

    @PersistenceContext
    private EntityManager entityManager;

		/**
	* 某个实体类的修改方法
	*/
    @Override
    @Transactional(rollbackFor = Exception.class)
    public void update(ArtLawDynamic resources) {
        ArtLawDynamic artLawDynamic = artLawDynamicRepository.findById(resources.getId()).orElseGet(ArtLawDynamic::new);
        ValidationUtil.isNull(artLawDynamic.getId(), "ArtLawDynamic", "id", resources.getId());
        artLawDynamicRepository.save(artLawDynamic);

		//将所有Managed状态的Entity实例同步到数据库；
		entityManager.clear();
        //  处理 图片表、
        // 处理 文件表、视频表
        Optional.ofNullable(resources.getFileId()).ifPresent(id -> {
            QiniuContent qiniuContent = new QiniuContent();
            qiniuContent.setBusinessId(resources.getId());
            qiniuContent.setId(id);
            qiNiuService.updateContent(qiniuContent);
        });
        //将Detached状态的Entity实例转至Managed状态；
        entityManager.merge(resources);
    }

整理不易，给个赞吧！