Example usage for org.apache.commons.dbcp BasicDataSource BasicDataSource

Introduction

In this page you can find the example usage for org.apache.commons.dbcp BasicDataSource BasicDataSource.

Prototype

BasicDataSource

Source Link

Usage

From source file:cn.vlabs.umt.common.datasource.DatabaseUtil.java

public DatabaseUtil(Config config) {
    BasicDataSource ds = new BasicDataSource();

    ds.setMaxActive(config.getInt("database.maxconn", 10));
    ds.setMaxIdle(config.getInt("database.maxidle", 3));
    ds.setMaxWait(100);/* www .j  av a2s .c  om*/

    ds.setUsername(config.getStringProp("database.username", null));
    ds.setPassword(config.getStringProp("database.password", null));
    ds.setDriverClassName(config.getStringProp("database.driver", null));
    ds.setUrl(config.getStringProp("database.conn-url", null));
    ds.setTimeBetweenEvictionRunsMillis(3600000);
    ds.setMinEvictableIdleTimeMillis(1200000);
    datasource = ds;
}

From source file:com.kerjapraktek.dataalumni.SpringConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:hsqldb:mem:test");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}

From source file:com.dangdang.ddframe.job.event.rdb.JobEventRdbConfigurationTest.java

@Test
public void assertGetDataSource() throws JobEventListenerConfigurationException {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.h2.Driver.class.getName());
    dataSource.setUrl("jdbc:h2:mem:job_event_storage");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    assertThat((BasicDataSource) (new JobEventRdbConfiguration(dataSource).getDataSource()), is(dataSource));
}

From source file:edu.ncsa.uiuc.rdfrepo.testing.USeekMSailFac.java

public static IndexingSail getIndexingSail(String dburl, String dbuser, String password,
        String capturepredicate, Sail sail) throws SailException {
    //set tup the postgis datasource for indexer
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.postgresql.Driver");
    dataSource.setUrl(dburl);// w  w  w  .  ja v a2  s.co  m
    dataSource.setUsername(dbuser);
    dataSource.setPassword(password);
    PostgisIndexerSettings indexerSettings = new PostgisIndexerSettings();

    //        String patternString =
    //            "?observation <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?time." +
    //                "?time  <http://www.w3.org/2006/time#inXSDDateTime> ?timevalue. " +
    //                "?loc <http://www.opengis.net/rdf#hasWKT> ?coord. " +
    //                "?sensor <http://www.loa-cnr.it/ontologies/DUL.owl#hasLocation> ?loc." +
    //                "?observation <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?sensor. ";

    String patternString = "?geometry <http://www.opengis.net/rdf#hasWKT> ?wkt.";

    sail.initialize();
    indexerSettings.setMatchSatatments(createPatternFromString(patternString, sail));
    indexerSettings.setDataSource(dataSource);

    //a matcher decides which object should be indexed by its associated predicate, we can use "http://www.opengis.net/rdf#hasWKT"
    PostgisIndexMatcher matcher = new PostgisIndexMatcher();
    matcher.setPredicate(capturepredicate);

    //create a IndexingSail from the basic sail and the indexer
    indexerSettings.setMatchers(Arrays.asList(new PostgisIndexMatcher[] { matcher }));

    //        PartitionDef p = new P
    //        IndexingSail indexingSail = new IndexingSail(sail, indexerSettings);
    //        indexingSail.getConnection().

    //        indexingSail.initialize();
    return null;
}

From source file:com.jxva.dao.connection.DBCPConnectionProvider.java

public DBCPConnectionProvider() {
    try {//w w  w .j a  v  a  2  s .  com
        bds = new BasicDataSource();
        bds.setDriverClassName(env.getDriverClass());
        bds.setUrl(env.getUrl());
        bds.setUsername(env.getUsername());
        bds.setPassword(env.getPassword());
        bds.setMaxActive(env.getMaxSize());
        bds.setMaxIdle(10);
        bds.setMaxWait(100000);
    } catch (Exception e) {
        e.printStackTrace();
    }
    log.info("DBCP Connection Provider initializing...");
}

From source file:com.sample.JavaSQLApplication.java

@Override
protected void init() throws Exception {
    logger.info("Adapter initialized!");

    dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(configurationAPI.getPropertyValue("DB_url"));
    dataSource.setUsername(configurationAPI.getPropertyValue("DB_username"));
    dataSource.setPassword(configurationAPI.getPropertyValue("DB_password"));
}

From source file:cn.edu.hfut.dmic.webcollector.util.MysqlHelper.java

public MysqlHelper(String url, String username, String password, int initialSize, int maxActive) {
    dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(url);//w  ww .  ja  va2 s .  c o m
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);
    template = new JdbcTemplate(dataSource);
}

From source file:com.abixen.platform.common.configuration.AbstractPlatformDataSourceConfiguration.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(platformJdbcConfiguration.getDriverClassName());
    dataSource.setUrl(platformJdbcConfiguration.getDatabaseUrl());
    dataSource.setUsername(platformJdbcConfiguration.getUsername());
    dataSource.setPassword(platformJdbcConfiguration.getPassword());
    return dataSource;
}

From source file:datasource.DataSourceProvider.java

@Override
BasicDataSource getDataSource() {
    return new BasicDataSource();
}

From source file:de.knurt.fam.connector.BasicDataSourceFactory.java

/**
 * create a basic data source. if the url has not a autoReconnect=true.
 *//*from   www. j a v  a2 s  .  co  m*/
public BasicDataSourceFactory() {
    super();
    this.bds = new BasicDataSource();
    this.bds.setDriverClassName(FamConnector.getGlobalProperty("sql_driver_class_name"));
    String url = FamConnector.getGlobalProperty("sql_url");
    String autoReconnect = "autoReconnect=true";
    if (url.matches(".*" + autoReconnect + ".*") == false) {
        if (url.matches(".+\\?.+")) {
            // there is already a query
            url += "&" + autoReconnect;
        } else {
            // no query so far
            url += "?" + autoReconnect;
        }
    }
    this.bds.setUrl(url);
    this.bds.setUsername(FamConnector.getGlobalProperty("sql_username"));
    this.bds.setPassword(FamConnector.getGlobalProperty("sql_password"));
}