org.frameworkset.persitent.util.SQLMissingCache Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of bboss-persistent Show documentation
bboss is a j2ee framework include aop/ioc,mvc,persistent,taglib,rpc,event ,bean-xml serializable and so on.http://www.bbossgroups.com
The newest version!
/*
 *  Copyright 2008 biaoping.yin
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */

package org.frameworkset.persitent.util;

import com.frameworkset.common.poolman.sql.PoolManResultSetMetaData;
import com.frameworkset.common.poolman.util.JDBCPool;
import com.frameworkset.util.VariableHandler.SQLStruction;
import org.frameworkset.cache.MissingStaticCache;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

/**
 * Title: SQLCache.java 
 * Description: 
 * bboss workgroup
 * Copyright (c) 2007
 * @Date 2012-12-5 下午6:15:07
 * @author biaoping.yin
 * @version 1.0
 */
public class SQLMissingCache extends SQLBaseCache{
	private static final Logger logger = LoggerFactory.getLogger(SQLMissingCache.class);
	private Map> parserTPLSQLStructions ;
	private Map> parserTPLTotalsizeSQLStructions ;

	protected  Map> missingCacheMetas ;
	public SQLMissingCache(String sqlfile, int resultMetaCacheSize, int perKeySqlStructionCacheSize) {
		super(sqlfile,resultMetaCacheSize,perKeySqlStructionCacheSize);
		parserTPLSQLStructions = new HashMap>();
		parserTPLTotalsizeSQLStructions = new HashMap>();
		missingCacheMetas = new HashMap>( );

	}


	public void clear()
	{
		missingCacheMetas.clear();
		parserTPLSQLStructions.clear();
		parserTPLTotalsizeSQLStructions.clear();
		super.clear();

	}


	public PoolManResultSetMetaData getPoolManResultSetMetaData(boolean cacheSql, JDBCPool db, String dbname, String sqlkey, ResultSetMetaData rsmetadata) throws SQLException
	{
		PoolManResultSetMetaData meta = null;
		if(cacheSql) {
			MissingStaticCache dbmetas = missingCacheMetas.get(dbname);
			if (dbmetas == null) {
				synchronized (missingCacheMetas) {
					dbmetas = missingCacheMetas.get(dbname);
					if (dbmetas == null) {
						dbmetas = new MissingStaticCache(resultMetaCacheSize);
						missingCacheMetas.put(dbname, dbmetas);
					}
				}
			}
			long missing = 0L;
			if (dbmetas.stopCache()) {
				missing = dbmetas.increamentMissing();
				meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
				if (logger.isWarnEnabled() && dbmetas.needLogWarn(missing,warnInterval)) {
					logMetaWarn(logger, sqlkey, dbmetas.getMissesMax(),missing);
				}
			} else {
				boolean newMeta = false;
				meta = dbmetas.get(sqlkey);
				if (meta == null) {
					metaLock.lock();
					try {

						meta = dbmetas.get(sqlkey);
						if (meta == null) {
							missing = dbmetas.increamentMissing();
							newMeta = true;
							meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
							if (!dbmetas.stopCache()) {
								dbmetas.put(sqlkey, meta);
							}
						}
					} finally {
						metaLock.unlock();
					}
				}
				//检测从缓冲中获取的数据是否发生变化
				if (!newMeta && needRefreshMeta(meta, rsmetadata)) {
					meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
					dbmetas.put(sqlkey, meta);

				}
				if (dbmetas.stopCache() && logger.isWarnEnabled() && dbmetas.needLogWarn(missing,warnInterval)) {
					logMetaWarn(logger, sqlkey, dbmetas.getMissesMax(),missing);
				}
			}
		}
		else
		{
			meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
		}
		return meta;

	}


	/**
	 * vtpl需要进行分级缓存
	 * @param sqlinfo
	 * @param newsql
	 * @return
	 */
	protected SQLStruction _getVTPLSQLStruction(boolean isTotalSize,
															  SQLInfo sqlinfo, String newsql, String okey,int cacheSize)
	{
		if(sqlinfo.isCacheSql()) {
			Map> _parserTPLSQLStructions = !isTotalSize ? parserTPLSQLStructions : parserTPLTotalsizeSQLStructions;
			String ikey = newsql;
			MissingStaticCache sqlstructionMap = _parserTPLSQLStructions.get(okey);
			if (sqlstructionMap == null) {
				this.vtplLock.lock();
				try {

					sqlstructionMap = _parserTPLSQLStructions.get(okey);
					if (sqlstructionMap == null) {
						sqlstructionMap = new MissingStaticCache(cacheSize);
						_parserTPLSQLStructions.put(okey, sqlstructionMap);
					}
				} finally {
					vtplLock.unlock();
				}
			}
			long missing = 0L;
			if (sqlstructionMap.stopCache()) {
				missing = sqlstructionMap.increamentMissing();
				if (logger.isWarnEnabled() && sqlstructionMap.needLogWarn(missing,warnInterval)) {
					this.logSqlStructionWarn(logger, ikey, sqlstructionMap.getMissesMax(), okey,missing);
				}
				return  evalSQLStruction(newsql);
			} else {
				SQLStruction urlStruction = sqlstructionMap.get(ikey);
				if (urlStruction == null) {
					this.vtplLock.lock();
					try {

						urlStruction = sqlstructionMap.get(ikey);
						if (urlStruction == null) {
							missing = sqlstructionMap.increamentMissing();
							urlStruction = evalSQLStruction(newsql);
							if (!sqlstructionMap.stopCache()) {
								sqlstructionMap.put(ikey, urlStruction);
							}
						}
					} finally {
						this.vtplLock.unlock();
					}
					if (sqlstructionMap.stopCache() && logger.isWarnEnabled() && sqlstructionMap.needLogWarn(missing,warnInterval)) {
						this.logSqlStructionWarn(logger, ikey, sqlstructionMap.getMissesMax(), okey,missing);
					}
				}
				return urlStruction;
			}
		}
		else{
			return  evalSQLStruction(newsql);
		}

	}

	


}