com.jn.agileway.jdbc.datasource.c3p0.C3p0DataSources Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of agileway-jdbc-datasource Show documentation

Provide an unified jdbc datasource factory

There is a newer version: 2.2.3

Show newest version

package com.jn.agileway.jdbc.datasource.c3p0;

import com.jn.agileway.jdbc.datasource.DataSourceProperties;
import com.jn.langx.util.Maths;
import com.jn.langx.util.Throwables;
import com.mchange.v2.c3p0.DataSources;

import javax.sql.DataSource;
import java.util.Properties;

import static com.jn.agileway.jdbc.datasource.c3p0.C3p0PropertyNames.*;


/**
 * https://www.mchange.com/projects/c3p0/#using_datasources_factory
 */
public class C3p0DataSources {
    private C3p0DataSources() {
    }

    public static DataSource createDataSource(final DataSourceProperties properties) {
        try {
            DataSource ds_unpooled = DataSources.unpooledDataSource(properties.getUrl(), properties.getUsername(), properties.getPassword());
            Properties props = properties.getDriverProps();

            if (props == null) {
                props = new Properties();
            }

            String username = properties.getUsername();
            if (username != null) {
                props.setProperty(PROP_USER_NAME, username);
            }

            String password = properties.getPassword();
            if (password != null) {
                props.setProperty(PROP_PASSWORD, password);
            }

            String url = properties.getUrl();
            if (url != null) {
                props.setProperty(PROP_URL, url);
            }

            String driverClassName = properties.getDriverClassName();
            if (driverClassName != null) {
                props.setProperty(PROP_DRIVER_CLASS_NAME, driverClassName);
            }

            props.setProperty(PROP_DEFAULT_AUTO_COMMIT, "" + properties.isAutoCommit());
            props.setProperty(PROP_DEFAULT_READ_ONLY, "" + properties.isReadOnly());
            props.setProperty(PROP_DEFAULT_TRANSACTION_ISOLATION, properties.getTransactionIsolationName());

            String catalog = properties.getCatalog();
            if (catalog != null) {
                props.setProperty(PROP_DEFAULT_CATALOG, catalog);
            }

            String schema = properties.getSchema();
            if (schema != null) {
                props.setProperty(PROP_DEFAULT_SCHEMA, schema);
            }

            props.setProperty(PROP_INITIAL_SIZE, "" + properties.getInitialSize());
            props.setProperty(PROP_MAX_POOL_SIZE, "" + Maths.max(8, properties.getMaxPoolSize()));

            return DataSources.pooledDataSource(ds_unpooled, properties.getName(), props);
        } catch (Exception ex) {
            throw Throwables.wrapAsRuntimeException(ex);
        }
    }
}