com.tacitknowledge.util.migration.jdbc.DataSourceMigrationContext Maven / Gradle / Ivy

Go to download
/* Copyright 2004 Tacit Knowledge
 *  
 * Licensed 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 com.tacitknowledge.util.migration.jdbc;

import com.tacitknowledge.util.migration.MigrationException;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * Provides JDBC resources to migration tasks.
 *
 * @author Scott Askew ([email protected])
 */
public class DataSourceMigrationContext implements JdbcMigrationContext
{
    /**
     * Class logger
     */
    private static Log log = LogFactory.getLog(JdbcMigrationContext.class);

    /**
     * The database connection to use
     */
    private Connection connection = null;

    /**
     * The DataSource to use
     */
    private DataSource dataSource = null;

    /**
     * The name of the system being patched
     */
    private String systemName = null;

    /**
     * The name of the system being patched
     */
    private DatabaseType databaseType = null;

    /**
     * The databasename
     */
    private String databaseName = "";

    /**
     * Returns the database connection to use
     *
     * @return the database connection to use
     * @throws SQLException if an unexpected error occurs
     */
    public Connection getConnection() throws SQLException
    {
        if ((connection == null) || connection.isClosed())
        {
            DataSource ds = getDataSource();
            if (ds != null)
            {
                connection = ds.getConnection();
            }
            else
            {
                throw new SQLException("Datasource is null");
            }
        }
        return connection;
    }

    /**
     * {@inheritDoc}
     */
    public void commit() throws MigrationException
    {
        try
        {
            if (getConnection().getAutoCommit())
            {
                // FIXME we need to set autocommit to false on connections for AutoPatch, then commit/rollback and re-set the autocommit state
                //       correctly before handing them back, then this will go away
                log.debug("AutoPatch issue - commit called on connection with autoCommit==true - would break on JBoss if it went through");
                return;
            }
            getConnection().commit();
        }
        catch (SQLException e)
        {
            throw new MigrationException("Error committing SQL transaction", e);
        }
    }

    /**
     * {@inheritDoc}
     */
    public void rollback() throws MigrationException
    {
        try
        {
            if (getConnection().getAutoCommit())
            {
                // FIXME we need to set autocommit to false on connections for AutoPatch, then commit/rollback and re-set the autocommit state
                //       correctly before handing them back, then this will go away
                log.warn("AutoPatch issue - rollback called on connection with autoCommit==true - would break in JBoss if it went through");
                return;
            }
            getConnection().rollback();
        }
        catch (SQLException e)
        {
            throw new MigrationException("Could not rollback SQL transaction", e);
        }
    }

    /**
     * Returns the type of database being patched.
     *
     * @return the type of database being patched
     */
    public DatabaseType getDatabaseType()
    {
        return databaseType;
    }

    /**
     * Returns the type of database being patched.
     *
     * @param type the type of database being patched
     */
    public void setDatabaseType(DatabaseType type)
    {
        this.databaseType = type;
    }

    /**
     * @return Returns the dataSource.
     */
    public DataSource getDataSource()
    {
        return dataSource;
    }

    /**
     * @param dataSource The dataSource to set.
     */
    public void setDataSource(DataSource dataSource)
    {
        this.dataSource = dataSource;
    }

    /**
     * @return Returns the systemName.
     */
    public String getSystemName()
    {
        return systemName;
    }

    /**
     * Sets the system name.
     *
     * @param name the name of the system to patch
     */
    public void setSystemName(String name)
    {
        if (name == null)
        {
            throw new IllegalArgumentException("systemName cannot be null");
        }
        if (name.length() > MAX_SYSTEMNAME_LENGTH)
        {
            throw new IllegalArgumentException("systemName cannot be longer than "
                    + MAX_SYSTEMNAME_LENGTH + " characters");
        }
        this.systemName = name;
    }

    /**
     * Useful for debugging
     *
     * @return String with state information
     */
    public String toString()
    {
        return
                "DataSourceMigrationContext["
                        + getDatabaseType() + "/"
                        + getSystemName() + "/"
                        + getDataSource() + "]";
    }

    /**
     * @override {@link JdbcMigrationContext#getDatabaseName()}
     */
    public String getDatabaseName()
    {
        return this.databaseName;
    }

    /**
     * Set the database name.
     *
     * @param databaseName the name
     */
    public void setDatabaseName(String databaseName)
    {
        this.databaseName = databaseName;
    }
}