org.cloudfoundry.multiapps.controller.persistence.util.JdbcUtil Maven / Gradle / Ivy

Go to download
package org.cloudfoundry.multiapps.controller.persistence.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.cloudfoundry.multiapps.controller.persistence.Messages;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class JdbcUtil {

    private static final Logger LOGGER = LoggerFactory.getLogger(JdbcUtil.class);

    private JdbcUtil() {
    }

    public static void closeQuietly(ResultSet resultSet) {
        if (resultSet == null) {
            return;
        }
        try {
            resultSet.close();
        } catch (SQLException e) {
            logSQLException(e);
            LOGGER.warn(Messages.COULD_NOT_CLOSE_RESULT_SET, e);
        } catch (Exception e) {
            LOGGER.warn(Messages.COULD_NOT_CLOSE_RESULT_SET, e);
        }
    }

    public static void closeQuietly(Statement statement) {
        if (statement == null) {
            return;
        }
        try {
            statement.close();
        } catch (SQLException e) {
            logSQLException(e);
            LOGGER.warn(Messages.COULD_NOT_CLOSE_STATEMENT, e);
        } catch (Exception e) {
            LOGGER.warn(Messages.COULD_NOT_CLOSE_STATEMENT, e);
        }
    }

    public static void closeQuietly(Connection connection) {
        if (connection == null) {
            return;
        }
        try {
            connection.close();
        } catch (SQLException e) {
            logSQLException(e);
            LOGGER.warn(Messages.COULD_NOT_CLOSE_CONNECTION, e);
        } catch (Exception e) {
            LOGGER.warn(Messages.COULD_NOT_CLOSE_CONNECTION, e);
        }
    }

    public static void logSQLException(SQLException exception) {
        for (Throwable sameLevelException : exception) {
            LOGGER.warn(sameLevelException.getMessage(), sameLevelException);
        }
    }

    public static void commit(Connection connection) throws SQLException {
        if (!connection.getAutoCommit()) {
            connection.commit();
        }
    }

    public static void rollback(Connection connection) throws SQLException {
        if (connection == null) {
            return;
        }
        if (!connection.getAutoCommit()) {
            connection.rollback();
        }
    }

}