com.mchange.v1.db.sql.ConnectionUtils Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of c3p0

c3p0 is an easy-to-use library for augmenting traditional (DriverManager-based) JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.

There is a newer version: 0.9.1.2

Show newest version

/*
 * Distributed as part of c3p0 v.0.9.1
 *
 * Copyright (C) 2005 Machinery For Change, Inc.
 *
 * Author: Steve Waldman 
 *
 * This library is free software; you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License version 2.1, as 
 * published by the Free Software Foundation.
 *
 * This software 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 software; see the file LICENSE.  If not, write to the
 * Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 * Boston, MA 02111-1307, USA.
 */


package com.mchange.v1.db.sql;

import java.sql.*;
import com.mchange.v2.log.*;

public final class ConnectionUtils
{
    private final static MLogger logger = MLog.getLogger( ConnectionUtils.class );

    /** 
     * @return false iff and Exception occurred while
     *         trying to close this object.
     */
    public static boolean attemptClose(Connection con)
    {
	try 
 	    {
 		if (con != null) con.close();
		//System.err.println("Connection [ " + con + " ] closed.");
 		return true;
 	    }
        catch (SQLException e)
	    {
		//e.printStackTrace();
		//System.err.println("Connection close FAILED.");

		if ( logger.isLoggable( MLevel.WARNING ) )
		    logger.log( MLevel.WARNING, "Connection close FAILED.", e );
 		return false;
	    }
    }

    public static boolean attemptRollback(Connection con)
    {
        try 
	    {
		if (con != null) con.rollback();
		return true;
	    }
        catch (SQLException e)
            {
		//e.printStackTrace();

		if ( logger.isLoggable( MLevel.WARNING ) )
		    logger.log( MLevel.WARNING, "Rollback FAILED.", e );
		return false;
	    }
    }

    private ConnectionUtils()
    {}
}