org.apache.jackrabbit.core.util.db.DbUtility Maven / Gradle / Ivy
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You 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.apache.jackrabbit.core.util.db;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
* This class contains some database utility methods.
*/
public final class DbUtility {
private static final Logger LOG = LoggerFactory.getLogger(DbUtility.class);
/**
* Private constructor for utility class pattern.
*/
private DbUtility() {
}
/**
* This is a utility method which closes the given resources without throwing exceptions. Any exceptions
* encountered are logged instead.
*
* @param rs the {@link ResultSet} to close, may be null
*/
public static void close(ResultSet rs) {
close(null, null, rs);
}
/**
* This is a utility method which closes the given resources without throwing exceptions. Any exceptions
* encountered are logged instead.
*
* @param con the {@link Connection} to close, may be null
* @param stmt the {@link Statement} to close, may be null
* @param rs the {@link ResultSet} to close, may be null
*/
public static void close(Connection con, Statement stmt, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
logException("failed to close ResultSet", e);
} finally {
try {
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
logException("failed to close Statement", e);
} finally {
try {
if (con != null && !con.isClosed()) {
con.close();
}
} catch (SQLException e) {
logException("failed to close Connection", e);
}
}
}
}
/**
* Logs an SQL exception on error level, and debug level (more detail).
*
* @param message the message
* @param e the exception
*/
public static void logException(String message, SQLException e) {
if (message != null) {
LOG.error(message);
}
LOG.error(" Reason: " + e.getMessage());
LOG.error(" State/Code: " + e.getSQLState() + "/" + e.getErrorCode());
LOG.debug(" dump:", e);
}
}