(1)如何清除一级缓存或不使用缓存
从源码中可以看到解决办法:
public <E> List<E> query(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql) throws SQLException {
ErrorContext.instance().resource(ms.getResource()).activity("executing a query").object(ms.getId());
if (closed) {
throw new ExecutorException("Executor was closed.");
}
if (queryStack == 0 && ms.isFlushCacheRequired()) {
clearLocalCache();
}
List<E> list;
try {
queryStack++;
list = resultHandler == null ? (List<E>) localCache.getObject(key) : null;
if (list != null) {
handleLocallyCachedOutputParameters(ms, key, parameter, boundSql);
} else {
list = queryFromDatabase(ms, parameter, rowBounds, resultHandler, key, boundSql);
}
} finally {
queryStack--;
}
if (queryStack == 0) {
for (DeferredLoad deferredLoad : deferredLoads) {
deferredLoad.load();
}
// issue #601
deferredLoads.clear();
if (configuration.getLocalCacheScope() == LocalCacheScope.STATEMENT) {
// issue #482
clearLocalCache();
}
}
return list;
}
方法一:mybatis-config.xml中的localCacheScope为STATEMENT,默认为SESSION
if (configuration.getLocalCacheScope() == LocalCacheScope.STATEMENT) {
// issue #482
clearLocalCache();
}
方法二:配置映射文件节点的flushCache属性,设置为true
if (queryStack == 0 && ms.isFlushCacheRequired()) {
clearLocalCache();
}
(2)二级缓存
对整个Application而言,Mybatis二级缓存并不是只有一份,每个Mapper文件都会有一个<cache>节点,只要配置这个节点,这个mapper文件就对应一个Cache对象,也可以多个mapper文件公用一个Cache,只需要配置一下<cache-ref>检点,指定它的namespace属性;
Mybatis的二级缓存可以指定某一条查询语句是否可以开启二级缓存,只有查询节点内指定useCache为true时才会走二级缓存,所以如果某个select几点支持二级缓存要满足三个条件:
1、mybatis-config.xml文件中cacheEnabled设为true,默认是开启的
2、mapper.xml中配置了cache或cache-ref节点
<cache></cache>
<cache-ref namespace="" ></cache-ref>
3、select节点配置了useCache=true属性
源码分析:
public <E> List<E> query(MappedStatement ms, Object parameterObject, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql)
throws SQLException {
// 获取该mapper对象的cache节点
Cache cache = ms.getCache();
if (cache != null) {
// 判断是否清空二级缓存
flushCacheIfRequired(ms);
if (ms.isUseCache() && resultHandler == null) {
ensureNoOutParams(ms, parameterObject, boundSql);
@SuppressWarnings("unchecked")
List<E> list = (List<E>) tcm.getObject(cache, key);
if (list == null) {
//如果二级缓存中没有数据则去进行一级缓存
list = delegate.<E> query(ms, parameterObject, rowBounds, resultHandler, key, boundSql);
//将获得的数据存入二级缓存中
tcm.putObject(cache, key, list); // issue #578 and #116
}
return list;
}
}
return delegate.<E> query(ms, parameterObject, rowBounds, resultHandler, key, boundSql);
}
flushCacheIfRequired:
private void flushCacheIfRequired(MappedStatement ms) {
Cache cache = ms.getCache();
if (cache != null && ms.isFlushCacheRequired()) {
tcm.clear(cache);
}
}