Remove specific select id data from MyBatis cache

Question

<mapper namespace="src.main.domain.EqMapper">
    <cache eviction="FIFO" size="512" readOnly="true"/>

    <select id="getStoreIdAndEqId" resultType="String" flushCache="false" useCache="true">
        select count(author) from blog
    </select>
    <select id="getWholeData" resultType="java.util.LinkedHashMap" flushCache="false" useCache="true">
        select * from blog
    </select>
</mapper>

Configuration configuration = MyBatisUtil.getSqlSessionFactory().getConfiguration(); 
Collection<Cache> caches = configuration.getCaches(); 
for (Cache cache : caches) { 
    Lock w = cache.getReadWriteLock().writeLock(); 
    w.lock(); 
    try { 
        cache.clear(); 
    } finally { 
        w.unlock(); 
    } 
} 

The above cache logic clears all cache. Is it possible to clear a specific cache? I want to delete getStoreIdAndEqId cache and not getWholeData cache.

Answer 1

Try this:

<select id="getStoreIdAndEqId" resultType="String" flushCache="true" useCache="false">
     select count(author) from blog
</select>
<select id="getWholeData" resultType="java.util.LinkedHashMap" flushCache="false" useCache="true">
     select * from blog
</select>