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:edu.neu.webtoolsfinal.config.RepositoryConfiguration.java

@Bean(name = "dataSource")
public DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/deliverydb");
    dataSource.setUsername("root");
    dataSource.setPassword("");

    return dataSource;
}

From source file:com.samovich.service.blueprint.App.java

/**
 * Data source configuration with dbcp/*from   w  w  w.jav a 2 s  . c  o  m*/
 * @return dataSource
 */
@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://HOST:PORT/DATABASE_NAME");
    dataSource.setUsername("DB_USER");
    dataSource.setPassword("RB_PW");
    dataSource.setValidationQuery("select 1");
    dataSource.setMaxTotal(50);
    dataSource.setTestOnBorrow(true);
    dataSource.setMaxWaitMillis(10000);
    dataSource.setRemoveAbandonedOnBorrow(true);
    dataSource.setDefaultAutoCommit(false);
    dataSource.setNumTestsPerEvictionRun(3);
    dataSource.setTimeBetweenEvictionRunsMillis(1800000);
    dataSource.setMinEvictableIdleTimeMillis(1800000);
    return dataSource;
}

From source file:hu.fnf.devel.wishbox.persistence.ConfigData.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://sql01x/wishbox");
    dataSource.setUsername(System.getProperty("SQLUser"));
    dataSource.setPassword(System.getProperty("SQLPass"));
    return dataSource;
}

From source file:io.github.bibekshakya35.ehealth.configuration.EhealthCofiguration.java

@Bean(name = "dataSource")
public javax.sql.DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.postgresql.Driver");
    dataSource.setUrl("jdbc:postgresql://localhost:5432/ehealth");
    dataSource.setUsername("test");
    dataSource.setPassword("test123");
    return dataSource;
}

From source file:com.ebay.pulsar.analytics.metricstore.db.RDMBSTest.java

@Test
public void testRDBMS2() {
    String driver2 = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://locahost:3306/test";
    String userName = "root";
    String userPwd = "";
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(driver2);// w ww. j av  a 2  s  . c  o  m
    bds.setUrl(url);
    bds.setUsername(userName);
    bds.setPassword(userPwd);
    DBFactory.setDs(bds);
    List<String> result = new ArrayList<String>();
    result.add("result");
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(bds);
    RDBMS db = new RDBMS(bds);
    db.setDriver(driver2);
    db.setNamedParameterJdbcTemplate(namedParameterJdbcTemplate);
    db.setUrl(url);
    db.setUserName(userName);
    db.setUserPwd(userPwd);
    assertEquals(userName, db.getUserName());
    assertEquals(url, db.getUrl());
    assertEquals(userPwd, db.getUserPwd());

}

From source file:com.ebay.pulsar.analytics.metricstore.db.RDMBSTest.java

@SuppressWarnings("unchecked")
@Test//from ww  w  .j av a 2 s  .  c  om
public void testRDBMS() {
    String driver2 = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://locahost:3306/test";
    String userName = "root";
    String userPwd = "";
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(driver2);
    bds.setUrl(url);
    bds.setUsername(userName);
    bds.setPassword(userPwd);
    DBFactory.setDs(bds);
    List<String> result = new ArrayList<String>();
    result.add("result");
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = Mockito.mock(NamedParameterJdbcTemplate.class);
    when(namedParameterJdbcTemplate.query(Matchers.anyString(), Matchers.any(Map.class),
            Matchers.any(ResultSetExtractor.class))).thenReturn(result);
    RDBMS db = new RDBMS(driver2, url, userName, userPwd);
    db.setDriver(driver2);
    db.setNamedParameterJdbcTemplate(namedParameterJdbcTemplate);
    db.setUrl(url);
    db.setUserName(userName);
    db.setUserPwd(userPwd);
    assertEquals(namedParameterJdbcTemplate, db.getNamedParameterJdbcTemplate());
    Map<String, String> map = new HashMap<String, String>();
    assertTrue(result.equals(db.queryForList("test", map, 10)));

}

From source file:com.graphaware.importer.data.access.DbDataReader.java

/**
 * Create a {@link javax.sql.DataSource} used for talking to the database.
 *
 * @return data source.//  w ww .jav a 2s .  c  o m
 */
protected DataSource createDataSource() {
    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setUrl(getUrl(dbHost, dbPort));
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setDefaultReadOnly(true);
    dataSource.setDefaultAutoCommit(false);

    dataSource.setDriverClassName(getDriverClassName());

    additionalConfig(dataSource);

    return dataSource;
}

From source file:com.zettsy.serverping.dao.PingDataImpl.java

@Override
@Transactional/*from   w  w  w  .java2  s. c o m*/
public SessionFactory addDataBase(String sid, HashMap myMap) {

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/" + "hrdtechn_" + sid);
    dataSource.setUsername("hrdtechn_javaapp");
    dataSource.setPassword("root123");

    LocalSessionFactoryBuilder sessionBuilder = new LocalSessionFactoryBuilder(dataSource);
    sessionBuilder.addProperties(applicationContextConfig.getHibernateProperties());
    sessionBuilder.addAnnotatedClasses(PingData.class);
    SessionFactory sessionFactory = sessionBuilder.buildSessionFactory();

    myMap.put(sid, sessionFactory);

    return sessionFactory;
}

From source file:ApplicationContextConfig.java

@Bean
public DataSource getDataSource() {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUrl("jdbc:mysql://localhost:3306/raphael");
    basicDataSource.setUsername("root");
    basicDataSource.setPassword("root");
    return basicDataSource;
}

From source file:com.alehuo.wepas2016projekti.configuration.ProductionConfiguration.java

/**
 * Heroku -palvelussa kytetn PostgreSQL -tietokantaa tiedon
 * tallentamiseen. Tm metodi hakee herokusta tietokantayhteyden
 * mahdollistavat ympristmuuttujat./*from   w ww . ja va2 s .co  m*/
 *
 * @return @throws URISyntaxException
 */
@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);

    //Autocommit pois plt
    basicDataSource.setDefaultAutoCommit(false);

    return basicDataSource;
}