Example usage for org.apache.commons.dbcp2 BasicDataSource setUrl

Introduction

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

Prototype

public synchronized void setUrl(String url)

Source Link

Document

Sets the #url .

Note: this method currently has no effect once the pool has been initialized.

Usage

From source file:com.magnet.mmx.server.plugin.mmxmgmt.db.UnitTestDSProvider.java

/**
 * Get unit test datasource//w w w  .  j av a2 s . c om
 * @return
 */
public static BasicDataSource getDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(dsConfig.getDriver());
    ds.setUsername(dsConfig.getUser());
    ds.setPassword(dsConfig.getPassword());
    ds.setUrl(dsConfig.getUrl());
    return ds;
}

From source file:com.bc.fiduceo.TestUtil.java

public static BasicDataSource getdatasourceMongoDb() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("mongodb");
    dataSource.setUrl("mongodb://localhost:27017");
    dataSource.setUsername("fiduceo");
    dataSource.setPassword("oecudif");
    return dataSource;
}

From source file:de.rwth.dbis.acis.activitytracker.service.ActivityTrackerService.java

private static DataSource setupDataSource(String dbUrl, String dbUserName, String dbPassword) {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(dbUrl);
    dataSource.setUsername(dbUserName);/*from  w  w w  .jav  a  2 s . com*/
    dataSource.setPassword(dbPassword);
    dataSource.setValidationQuery("SELECT 1;");
    dataSource.setTestOnBorrow(true); // test each connection when borrowing from the pool with the validation query
    dataSource.setMaxConnLifetimeMillis(1000 * 60 * 60); // max connection life time 1h. mysql drops connection after 8h.
    return dataSource;
}

From source file:com.bc.fiduceo.TestUtil.java

public static BasicDataSource getDatasource_H2() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    // the following line dumps all database interactions to the console window tb 2016-02-10
    //        dataSource.setUrl("jdbc:h2:mem:fiduceo;TRACE_LEVEL_SYSTEM_OUT=2");
    dataSource.setUrl("jdbc:h2:mem:fiduceo");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}

From source file:agency.AgencyManagerImplTest.java

private static DataSource prepareDataSource() throws SQLException, IOException {
    Properties myconf = new Properties();
    myconf.load(Agency.class.getResourceAsStream("/myconf.properties"));

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(myconf.getProperty("jdbc.url"));
    ds.setUsername(myconf.getProperty("jdbc.user"));
    ds.setPassword(myconf.getProperty("jdbc.password"));

    return ds;//from  w  w  w  .j  a  v  a  2  s. co  m
}

From source file:de.anycook.db.mysql.DBHandler.java

private static BasicDataSource setupDataSource(String server, int port, String dbName, String username,
        String password, int maxActive, int maxIdle) {
    Preconditions.checkNotNull(server);//  w w  w . j  a v  a 2 s .c o  m
    Preconditions.checkNotNull(dbName);
    Preconditions.checkNotNull(username);

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername(username);

    if (password.length() > 0) {
        ds.setPassword(password);
    }

    String url = String.format("jdbc:mysql://%s:%d/%s?useConfigs=maxPerformance&useCompression=true", server,
            port, dbName);
    ds.setUrl(url);
    ds.setValidationQuery("SELECT 1;");
    ds.setTestWhileIdle(true);
    ds.setTestOnReturn(true);
    ds.setMaxTotal(maxActive);
    ds.setMaxIdle(maxIdle);
    ds.setRemoveAbandonedOnBorrow(true);
    ds.setRemoveAbandonedTimeout(60);

    if (Configuration.getInstance().isDeveloperMode()) {
        ds.setLogAbandoned(true);
    }

    sLogger.info("created new Connectionpool");
    return ds;
}

From source file:f1db.configuration.ProductionProfile.java

@Bean
public BasicDataSource dataSource() throws URISyntaxException {
    URI dbUri = new URI(System.getenv("DATABASE_URL"));
    String username = dbUri.getUserInfo().split(":")[0];
    String password = dbUri.getUserInfo().split(":")[1];
    String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath();
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(dbUrl);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);
    return basicDataSource;
}

From source file:app.config.DatabaseConfig.java

@Bean
public BasicDataSource dataSource() throws URISyntaxException {
    String dbUrl = System.getenv("JDBC_DATABASE_URL");
    String username = System.getenv("JDBC_DATABASE_USERNAME");
    String password = System.getenv("JDBC_DATABASE_PASSWORD");

    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(dbUrl);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);

    return basicDataSource;
}

From source file:bibibi.configs.ProductionProfile.java

@Bean
public BasicDataSource dataSource() throws URISyntaxException {
    URI dbUri = new URI(System.getenv("DATABASE_URL"));

    String username = dbUri.getUserInfo().split(":")[0];
    String password = dbUri.getUserInfo().split(":")[1];
    String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath();

    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(dbUrl);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);

    return basicDataSource;
}

From source file:guiPackage.AllGuestComboBoxModel.java

private List<Guest> getValues() {
    BasicDataSource mySource = new BasicDataSource();
    mySource.setUrl(ResourceBundle.getBundle("databaseConnection").getString("connection"));
    mySource.setUsername(ResourceBundle.getBundle("databaseConnection").getString("username"));
    mySource.setPassword(ResourceBundle.getBundle("databaseConnection").getString("password"));
    GuestManager mngr = new GuestManagerImpl(mySource);
    return mngr.getAllGuests();
}