xdev.db.jdbc.JDBCUtils Maven / Gradle / Ivy

Go to download
/*
 * XDEV Application Framework - XDEV Application Framework
 * Copyright © 2003 XDEV Software (https://xdev.software)
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program.  If not, see .
 */
package xdev.db.jdbc;


import java.sql.ResultSet;
import java.sql.Statement;

import xdev.lang.Nullable;


/**
 * The class {@link JDBCUtils} provides utility methods for JDBC related tasks.
 * 
 * @since 3.2
 * @author XDEV Software
 * 
 */
public class JDBCUtils
{
	/**
	 * Closes rs silently, throws no exception whether
	 * rs is null nor if an error occurs.
	 * 
	 * @param rs
	 *            {@link ResultSet} to be closed
	 */
	public static void closeSilent(final @Nullable ResultSet rs)
	{
		// 2014-08-20 (FHAE) - ensure there is no resource leak
		if(rs != null)
		{
			Statement statement = null;
			try
			{
				statement = rs.getStatement();
			}
			catch(final Throwable e)
			{
				// swallow
			}
			
			try
			{
				rs.close();
			}
			catch(final Throwable t)
			{
				// swallow
			}
			
			if(statement != null)
			{
				try
				{
					statement.close();
				}
				catch(final Throwable t)
				{
					// swallow
				}
			}
		}
		
	}
}