Flush MyBatis Cache externally (outside of mapper)

Question

I'm using MyBatis with second level cache activated via <cache/> in xml mapper files.

Suppose I want to interact with the underlying DB/DataSource decoupled from MyBatis, for instance via direct jdbcTemplate.

How can I assure, that the MyBatis cache gets flushed appropriateley when I Insert/Update/Delete via jdbcTemplate on a table for that MyBatis holds cached query results.

In other words, how can I force MyBatis to flush its cache from outside of MyBatis mappers for certain cache namespace?

I'm aware of @Options(flushCache=true) annotation, but this seems not to work outside of mapper interfaces.

Persia · Accepted Answer · 2016-01-14T11:49:22.317

9

you can get cache from configuration and then get by namespace and clear it.

    @Resource
    SqlSessionFactory sqlSessionFactory;

    public void clearCacheByNamespace(){
        Configuration config = sqlSessionFactory.getConfiguration();
        Cache cache = config.getCache("com.persia.dao.UserInfoMapper");
        if(cache != null){
            cache.clear();
        }
    }

edited Jan 14 '16 at 11:49

answered Jan 14 '16 at 07:02

Persia

855
5
8

not helpful, the question was outside of mybatis mapper – Mahatma_Fatal_Error Jan 14 '16 at 10:52
1

I update the answer , you can do it by getting cache from configuration. – Persia Jan 14 '16 at 11:50

score 0 · Answer 2 · answered Feb 03 '16 at 09:08

0

Hi i have used another approach, because we used spring. Use autowire the Session implementation and call appropriate method

public class SomeServerClass{

    @Autowired
    private org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate;

    private void someClearMethod(){
        sqlSessionTemplate.clearCache();
    }
}

If I use interface org.apache.ibatis.session.SqlSession it refers to same instance

answered Feb 03 '16 at 09:08

Perlos

2,028
6
27
37

As the JavaDoc of SqlSessionTemplate.clearCache() states "Clears local session cache" I assume this clears the local (per thread) cache rather than the global session-independent cache – Mahatma_Fatal_Error Mar 11 '16 at 09:07

Flush MyBatis Cache externally (outside of mapper)

2 Answers2

Linked