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:com.bt.aloha.sipstone.MaintenanceDao.java

public MaintenanceDao(String driver, String url, String uname, String pwd) {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driver);/*from w w w  .j a  v  a2s.c  o  m*/
    ds.setUrl(url);
    ds.setUsername(uname);
    ds.setPassword(pwd);
    this.jdbcTemplate = new JdbcTemplate(ds);
    testConnection();
}

From source file:com.gnizr.core.GnizrCoreTestBase.java

private void init() {
    if (dataSource == null) {
        dataSource = new BasicDataSource();
        dataSource.setUsername("gnizr");
        dataSource.setPassword("gnizr");
        dataSource.setUrl("jdbc:mysql://localhost/gnizr_test");
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.addConnectionProperty("characterEncoding", "UTF-8");
        dataSource.addConnectionProperty("useUnicode", "TRUE");
    }/*from   w  w w.j a  va2 s  . c  o m*/

    gnizrDBDao = GnizrDao.getInstance(dataSource);
}

From source file:com.tedexis.commons.db.DBSinglePool.java

/**
 * Crea el pool de conexiones/*from   w ww  .  jav a  2  s  .  c  o m*/
 *
 * @param configurationDB
 * @return
 * @throws ClassNotFoundException
 */
private BasicDataSource getBasicDataSource(ConfigurationDB configurationDB) throws ClassNotFoundException {
    BasicDataSource ds = null;
    if (dataSource == null) {

        ds = new BasicDataSource();

        Class.forName(configurationDB.driverClass);

        ds.setUrl(configurationDB.url);
        ds.setDriverClassName(configurationDB.driverClass);
        ds.setUsername(configurationDB.user);
        ds.setPassword(configurationDB.password);
        ds.setInitialSize(configurationDB.poolSize);
        ds.setMaxActive(configurationDB.poolMaxAct);
        ds.setMaxIdle(configurationDB.poolMaxIdle);
        ds.setMaxWait(configurationDB.poolWait);

        return ds;
    }
    return dataSource;
}

From source file:com.gnizr.db.dao.GnizrDBTestBase.java

private void init() {
    if (dataSource == null) {
        dataSource = new BasicDataSource();
        dataSource.setUsername("gnizr");
        dataSource.setPassword("gnizr");
        dataSource.setUrl("jdbc:mysql://localhost/gnizr_test");
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.addConnectionProperty("characterEncoding", "UTF-8");
        dataSource.addConnectionProperty("useUnicode", "TRUE");
    }/*w ww .  j a v  a  2s.  c o m*/
}

From source file:com.surveypanel.form.config.LoadConfigTest.java

public void testRbs() {

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.h2.Driver");
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setUrl("jdbc:h2:mem:surveypanel");

    JDBCFormDAO jdbcFormDAO = new JDBCFormDAO();
    jdbcFormDAO.setDataSource(ds);//from ww w .  j av a2s.  com

    RDBSFormFactory formFactory = new RDBSFormFactory("/form/", jdbcFormDAO);
    formFactory.init(0);
    Form form = formFactory.create(0, false);
    System.out.println(form.getId());
    JSManager jsManager = new JSManager(formFactory);
    Result execute = (Result) jsManager.execute(form, "flow.next();save();");

    System.out.println(form.getId());

    formFactory.load(form.getId(), 0, false);

    System.out.println(execute.getLogs());
    System.out.println(execute.getError());
    assertFalse(execute.hasError());
}

From source file:com.example.dbflute.spring.JdbcBeansJavaConfig.java

@Bean(name = { "dataSource" })
public DataSource createDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.h2.Driver");
    ds.setUrl(exampleDbUrl);/*from w ww . j  av  a  2  s.  com*/
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setMaxActive(20);
    return ds;
}

From source file:com.dangdang.ddframe.job.example.config.JobEventConfig.java

@Bean
public JobEventConfiguration jobEventConfiguration(@Value("${jobEventConfig.url}") final String url,
        @Value("${jobEventConfig.driverClassName}") final String driverClassName,
        @Value("${jobEventConfig.username}") final String username,
        @Value("${jobEventConfig.password}") final String password) {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(url);/*from  w  ww .  j  a va2s. c o m*/
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    return new JobEventRdbConfiguration(dataSource);
}

From source file:com.surveypanel.form.TestHelper.java

public static DataSource getDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername("root");
    ds.setPassword("halflife");
    ds.setUrl(/*  w  w w . ja va 2  s. c o m*/
            "jdbc:mysql://localhost:3306/surveypanel?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8");
    return ds;
}

From source file:jp.classmethod.aws.brian.config.DataSourceConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUrl(url);/*from   ww w  . ja  v a  2 s.c o m*/
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);
    basicDataSource.setValidationQuery("SELECT 1");
    basicDataSource.setMaxActive(50);
    basicDataSource.setMaxIdle(10);
    basicDataSource.setMinIdle(5);
    return basicDataSource;
}

From source file:com.gantzgulch.sharing.configuration.DataSourceContextTest.java

@Bean(name = "sharingDS")
public DataSource sharingDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUrl("jdbc:hsqldb:mem:sharing_db");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}