org.jumpmind.db.sql.SqlUtils Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of symmetric-db Show documentation

This library is a fork of Apache DdlUtils. DdlUtils is a small, easy-to-use component for working with Database Definition (DDL) files.

There is a newer version: 3.5.19

Show newest version

/**
 * Licensed to JumpMind Inc under one or more contributor
 * license agreements.  See the NOTICE file distributed
 * with this work for additional information regarding
 * copyright ownership.  JumpMind Inc licenses this file
 * to you under the GNU General Public License, version 3.0 (GPLv3)
 * (the "License"); you may not use this file except in compliance
 * with the License.
 *
 * You should have received a copy of the GNU General Public License,
 * version 3.0 (GPLv3) along with this library; if not, see
 * .
 *
 * 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.jumpmind.db.sql;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

abstract public class SqlUtils {
    
    private static Logger log = LoggerFactory.getLogger(SqlUtils.class);

    private static boolean captureOwner = false;

    private static List sqlTransactions = new ArrayList();

    private static List> sqlReadCursors = new ArrayList>();

    private static Map sqlTransactionsOwnerMap = new HashMap();

    private static Map, Exception> sqlReadCursorsOwnerMap = new HashMap, Exception>();

    protected static void addSqlTransaction(ISqlTransaction transaction) {
        sqlTransactions.add(transaction);
        if (captureOwner) {
            sqlTransactionsOwnerMap.put(transaction, new Exception());
        }
    }

    protected static void addSqlReadCursor(ISqlReadCursor cursor) {
        sqlReadCursors.add(cursor);
        if (captureOwner) {
            sqlReadCursorsOwnerMap.put(cursor, new Exception());
        }
    }

    protected static void removeSqlReadCursor(ISqlReadCursor cursor) {
        sqlReadCursors.remove(cursor);
        if (captureOwner) {
            sqlReadCursorsOwnerMap.remove(cursor);
        }
    }

    protected static void removeSqlTransaction(ISqlTransaction transaction) {
        sqlTransactions.remove(transaction);
        if (captureOwner) {
            sqlTransactionsOwnerMap.remove(transaction);
        }
    }

    public static List getOpenTransactions() {
        return new ArrayList(sqlTransactions);
    }

    public static List> getOpenSqlReadCursors() {
        return new ArrayList>(sqlReadCursors);
    }

    
    public static void logOpenResources() {
        List> cursors = SqlUtils.getOpenSqlReadCursors();
        for (ISqlReadCursor cursor : cursors) {
            Exception ex = sqlReadCursorsOwnerMap.get(cursor);
            if (ex != null) {
                log.error("The following stack contains the owner of an open read cursor", ex);
            }
        }
        
        List transactions = SqlUtils.getOpenTransactions();
        for (ISqlTransaction transaction : transactions) {
            Exception ex = sqlTransactionsOwnerMap.get(transaction);
            if (ex != null) {
                log.error("The following stack contains the owner of an open database transaction", ex);
            }
        }
    }
    

    public static void setCaptureOwner(boolean captureOwner) {
        SqlUtils.captureOwner = captureOwner;
    }

}