springboot Isolation.READ_COMMITTED不生效解决办法

问题描述

springboot+mybatis可读已提交不生效，先在springboot查询出结果然后在数据库修改值后在Java再次读取，结果读取的还是修改之前的值

原因:

是mybatis二级缓存导致的

解决办法

方案一

​​​​​​​@Resource
private SqlSession sqlSession;

@Transactional(isolation = Isolation.READ_COMMITTED)
@Override
public void aaa() {
    SysLog log1 = this.getById("");
    log.info("log1【{}】", log1.getLogContent());
    sqlSession.clearCache();
    SysLog log2 = this.getById("");
    log.info("log2【{}】", log2.getLogContent());
}

 方案二

@Resource
private SqlSessionTemplate sqlSessionTemplate;

@Transactional(isolation = Isolation.READ_COMMITTED)
@Override
public void aaa() {
    SysLog log1 = this.getById("");
    log.info("log1【{}】", log1.getLogContent());
    sqlSessionTemplate.clearCache();
    SysLog log2 = this.getById("");
    log.info("log2【{}】", log2.getLogContent());
}

方案三

<select id="getById" resultType="SysLog" useCache="false">
    SELECT * FROM sys_log WHERE id = #{id}
</select>