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

Introduction

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

Prototype

public synchronized void setDriverClassName(String driverClassName)

Source Link

Document

Sets the jdbc driver class name.

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

Usage

From source file:com.tukaloff.customers.Config.java

@Bean
public BasicDataSource dataSource() {
    BasicDataSource dbcp = new BasicDataSource();
    dbcp.setDriverClassName("com.mysql.jdbc.Driver");
    dbcp.setInitialSize(5);/*from   w ww.j a  v a2s  .c  o  m*/
    dbcp.setMaxIdle(10);
    return dbcp;
}

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.bc.fiduceo.db.DatabaseConfig.java

public BasicDataSource getDataSource() {
    if (properties.isEmpty()) {
        throw new RuntimeException("database.properties not loaded");
    }/*from  w w w.jav  a  2 s  .co m*/

    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName(properties.getProperty("driverClassName"));
    dataSource.setUrl(properties.getProperty("url"));
    dataSource.setUsername(properties.getProperty("username"));
    dataSource.setPassword(properties.getProperty("password"));

    return dataSource;
}

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

@Override
@Transactional//from w  w w. j av  a 2 s.co 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.mycompany.configuration.SpringDateConfigMySQL.java

@Bean
//? ? /*  w  w w  . j  a  va  2  s .  co  m*/
public DataSource dataSource() {
    //MySQL
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    //? 
    ds.setUrl("jdbc:mysql://localhost:3306/dateexam");
    ds.setUsername("root");
    ds.setPassword("root");
    /* ds.setUsername("exam");
    ds.setPassword("exam68");*/
    //
    ds.setInitialSize(5);
    ds.setMaxIdle(5);
    ds.setMaxTotal(15);

    return ds;
}

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);
    bds.setUrl(url);/*www .j  av  a2s  . co m*/
    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//www. ja v  a  2 s. c o m
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.cfitzarl.cfjwed.core.config.DatabaseConfigurationContainer.java

@Bean(name = "dataSource")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driver);
    dataSource.setPassword(password);//  w  w  w . j a  v  a  2 s  .  c o m
    dataSource.setUsername(username);
    dataSource.setUrl(url);

    return dataSource;
}