DBInitializer.java

/*
 * #%L
 * Service Activity Monitoring :: Server
 * %%
 * Copyright (C) 2011 - 2012 Talend Inc.
 * %%
 * 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.
 * #L%
 */
package org.talend.esb.sam.server.persistence;

import com.ibatis.common.jdbc.ScriptRunner;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.logging.Logger;

import javax.sql.DataSource;

import org.springframework.beans.factory.InitializingBean;

/**
 * The Class DBInitializer using for initializing persistence.
 */
public class DBInitializer implements InitializingBean {

    private static final Logger LOG = Logger.getLogger(DBInitializer.class.getName());

    private DataSource dataSource;
    private String createSql;
    private String createSqlInd;

    /**
     * Sets the data source.
     * 
     * @param dataSource
     *            the new data source
     */
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }

    /**
     * Sets the database dialect.
     * 
     * @param dialect
     *            the database dialect
     */
    public void setDialect(String dialect) {
        String[] scripts = createScripts.get(dialect);
        createSql = scripts[0];
        createSqlInd = scripts[1];
    }

    @SuppressWarnings("serial")
    private final Map<String, String[]> createScripts = new HashMap<String, String[]>() {
        {
            put("derbyDialect", new String[] {"create.sql", "create_ind.sql"});
            put("h2Dialect", new String[] {"create_h2.sql", "create_h2_ind.sql"});
            put("mysqlDialect", new String[] {"create_mysql.sql", "create_mysql_ind.sql"});
            put("oracleDialect", new String[] {"create_oracle.sql", "create_oracle_ind.sql"});
            put("DB2Dialect", new String[] {"create_db2.sql", "create_db2_ind.sql"});
            put("sqlServerDialect", new String[] {"create_sqlserver.sql", "create_sqlserver_ind.sql"});
            put("postgresqlDialect", new String[] {"create_postgres.sql", "create_postgres_ind.sql"});
        }
    };

    /*
     * (non-Javadoc)
     * 
     * @see
     * org.springframework.beans.factory.InitializingBean#afterPropertiesSet()
     */
    @Override
    public void afterPropertiesSet() throws Exception {
        Connection conn = null;

        try {
            boolean createTables = true;

            try {
                conn = dataSource.getConnection();

                ResultSet rs = conn.getMetaData().getTables(conn.getCatalog(), null, "EVENTS_CUSTOMINFO", null);
                while (rs.next()) {
                    createTables = false;
                }
            } catch (SQLException e) {
                LOG.warning("The create tables parameter has not been set. Tables and indexes will not be created.");
                createTables = false;
            }

            if (createTables) {
                ScriptRunner sr = new ScriptRunner(conn, false, false);
                sr.setLogWriter(null);
                sr.setErrorLogWriter(null);
                sr.runScript(new InputStreamReader(this.getClass().getResourceAsStream("/" + createSql)));
                if (createSqlInd != null && !createSqlInd.equals("")) {
                    sr.runScript(new InputStreamReader(this.getClass().getResourceAsStream("/" + createSqlInd)));
                } else {
                    LOG.warning("The script to create indexes has not been set. Indexes will not be created.");
                }
            }
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    LOG.warning("Unable to close JDBC connection.");
                }
            }
        }
    }

}