JdbcTool.java

/*
 * Copyright 2011-2013 the original author or authors.
 *
 * 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 kr.debop4j.data.jdbc;

import com.jolbox.bonecp.BoneCPDataSource;
import lombok.extern.slf4j.Slf4j;

import javax.sql.DataSource;

/**
 * Jdbc 관련 Utility class
 *
 * @author 배성혁 ( sunghyouk.bae@gmail.com )
 * @since 13. 2. 26
 */
@Slf4j
public class JdbcTool {

    private JdbcTool() {}

    /**
     * Gets data source {@link DataSource}.
     *
     * @param driverClass the driver class
     * @param url         the url
     * @param username    the username
     * @param passwd      the passwd
     * @return the data source
     */
    public static javax.sql.DataSource getDataSource(String driverClass, String url, String username, String passwd) {
        return getTomcatDataSource(driverClass, url, username, passwd);
    }

    /**
     * Bone CP DataSource 를 빌드합니다.
     *
     * @param driverClass the driver class
     * @param url         the url
     * @param username    the username
     * @param passwd      the passwd
     * @return the bone cp data source
     */
    public static javax.sql.DataSource getBoneCpDataSource(String driverClass, String url, String username, String passwd) {

        if (log.isDebugEnabled())
            log.debug("build BoneCP DataSource... driverClass=[{}], url=[{}], username=[{}], passwd=[{}]",
                      driverClass, url, username, passwd);

        BoneCPDataSource ds = new BoneCPDataSource();

        ds.setDriverClass(driverClass);
        ds.setJdbcUrl(url);
        ds.setUsername(username);
        ds.setPassword(passwd);

        ds.setPartitionCount(3);
        ds.setMaxConnectionsPerPartition(200);
        ds.setMinConnectionsPerPartition(10);
        ds.setReleaseHelperThreads(6);
        ds.setAcquireIncrement(5);

        ds.setIdleConnectionTestPeriodInMinutes(1);

        return ds;
    }

    /**
     * Tomcat DataSource 를 빌드합니다.
     *
     * @param driverClass the driver class
     * @param url         the url
     * @param username    the username
     * @param passwd      the passwd
     * @return the tomcat data source
     */
    public static DataSource getTomcatDataSource(String driverClass, String url, String username, String passwd) {

        if (log.isDebugEnabled())
            log.debug("build Tomcat pool DataSource... driverClass=[{}], url=[{}], username=[{}], passwd=[{}]",
                      driverClass, url, username, passwd);

        org.apache.tomcat.jdbc.pool.PoolProperties p = new org.apache.tomcat.jdbc.pool.PoolProperties();
        p.setUrl(url);
        p.setDriverClassName(driverClass);
        p.setUsername(username);
        p.setPassword(passwd);

        p.setJmxEnabled(true);
        p.setTestWhileIdle(true);
        p.setTestOnBorrow(true);
        p.setValidationQuery("SELECT 1");
        p.setTestOnReturn(false);
        p.setValidationInterval(30000);
        p.setTimeBetweenEvictionRunsMillis(30000);
        p.setMaxActive(200);
        p.setInitialSize(10);
        p.setMaxWait(10000);
        p.setRemoveAbandonedTimeout(60);
        p.setMinEvictableIdleTimeMillis(30000);
        p.setMinIdle(10);

        DataSource ds = new org.apache.tomcat.jdbc.pool.DataSource(p);
        return ds;
    }

    /** 테스트에 사용하기 위해 메모리를 사용하는 HSql DB 에 대한 DataSource 를 반환합니다. */
    public static DataSource getEmbeddedHsqlDataSource() {
        return getDataSource("org.hsqldb.jdbcDriver",
                             "jdbc:hsqldb:mem:test;MVCC=TRUE;",
                             "sa",
                             "");
    }

    /** 테스트에 사용하기 위해 메모리를 사용하는 H2 DB 에 대한 DataSource 를 반환합니다. */
    public static DataSource getEmbeddedH2DataSource() {
        return getDataSource("org.h2.Driver",
                             "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;MVCC=TRUE;",
                             "sa",
                             "");
    }
}