edu.uiuc.ncsa.security.storage.sql.ConnectionPool Maven / Gradle / Ivy

Go to download
package edu.uiuc.ncsa.security.storage.sql;

import edu.uiuc.ncsa.security.core.util.DebugUtil;
import edu.uiuc.ncsa.security.core.util.Pool;
import edu.uiuc.ncsa.security.core.util.PoolException;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * A pool for jdbc connections. All this needs is configuration for the right jdbc url to use.
 * Created by Jeff Gaynor

 * on Mar 12, 2010 at  4:06:15 PM
 */
public class ConnectionPool extends Pool {
    public ConnectionParameters getConnectionParameters() {
        return connectionParameters;
    }

    ConnectionParameters connectionParameters;

    public ConnectionPool(SQLConnectionImpl connectionParameters) {
        this.connectionParameters = connectionParameters;
    }


    public Connection create() throws PoolException {
        try {
            Connection con = DriverManager.getConnection(getConnectionParameters().getJdbcUrl());
            return con;
        } catch (Exception x) {
            DebugUtil.dbg(this, "Connection failure, JDBC URL=" + getConnectionParameters().getJdbcUrl());
            x.printStackTrace();
            throw new PoolException(x);
        }
    }

    public void destroy(Connection c) throws PoolException {
        try {
            if (!c.isClosed()) {
                c.close();
            }
        } catch (SQLException x) {
            throw new PoolException(x);
        }
    }

    @Override
    public boolean isValid(Connection object) throws PoolException {
        try {
            return object.isValid(0);
        } catch (SQLException e) {
            throw new PoolException("Invalid object", e);
        }
    }
}