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:general.conexion.Pool.java

public void inicializarDataSource() {
    BasicDataSource basic = new BasicDataSource();
    basic.setDriverClassName(driver);//w w w.java  2  s  . c om
    basic.setUsername(usuario);
    basic.setPassword(contrasena);
    basic.setUrl(url);
    basic.setMaxActive(5);
    this.dataSource = basic;
}

From source file:br.com.shopcarpet.test.db.TestConnectDataBase.java

private DataSource getConnection() {
    final BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUrl("jdbc:mysql://localhost/carpet");
    ds.setUsername("carpet");
    ds.setPassword("carpet123");
    return ds;/*from   www .j av a  2  s .  co  m*/
}

From source file:app.Mysqlconector.java

public DataSource Connection() {
    if (DataSource == null) {
        BasicDataSource basicDataSource = new BasicDataSource();
        basicDataSource.setDriverClassName(mysql);
        basicDataSource.setUrl(Url);/*from   w ww . jav  a  2s .c  o m*/
        basicDataSource.setUsername(User);
        basicDataSource.setPassword(Pass);
        basicDataSource.setMaxActive(50);
        DataSource = basicDataSource;
    }
    return DataSource;
    //  return conexion;
}

From source file:mx.com.pixup.portal.db.DBConecta.java

public static BasicDataSource getDataSource() {
    DBConecta db = DBConecta.getInstance();

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(db.dbProp.getProperty("dataSource.className"));
    dataSource.setUsername(db.dbProp.getProperty("dataSource.username"));
    dataSource.setPassword(db.dbProp.getProperty("dataSource.password"));
    dataSource.setUrl(db.dbProp.getProperty("dataSource.url"));

    return dataSource;
}

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

@BeforeClass
public static void setUpClass() throws SQLException {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.h2.Driver.class.getName());
    dataSource.setUrl("jdbc:h2:mem:");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    storage = new JobEventRdbStorage(dataSource);
    repository = new JobEventRdbSearch(dataSource);
    initStorage();/*from   www . ja  v a 2  s . c om*/
}

From source file:com.alibaba.druid.pool.DBCPTest.java

public void test_dbcp() throws Exception {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(MockDriver.class.getName());
    dataSource.setUrl("jdbc:mock:xxx");
    dataSource.setMaxOpenPreparedStatements(100);
    dataSource.setPoolPreparedStatements(true);

    final String sql = "selelct 1";
    {//from   w  w  w  . ja v  a2s  . c om
        Connection conn = dataSource.getConnection();
        CallableStatement stmt = conn.prepareCall(sql);
        stmt.close();
        conn.close();
    }
    {
        Connection conn = dataSource.getConnection();
        CallableStatement stmt = conn.prepareCall(sql);
        stmt.close();
        conn.close();
    }
}

From source file:de.mendelson.comm.as2.database.DBDriverManager.java

/**Setup the driver manager, initialize the connection pool
 * //  w  w  w.j  a v a 2 s  .c o  m
 */
public static synchronized void setupConnectionPool() {
    String driverName = "org.hsqldb.jdbcDriver";
    String dbHost = "localhost";
    //in client-server environment this may be called from client and server in the same VM
    if (dataSourceConfig == null) {
        dataSourceConfig = new BasicDataSource();
        dataSourceConfig.setDriverClassName(driverName);
        dataSourceConfig.setUrl(getConnectionURI(dbHost, DB_CONFIG));
        dataSourceConfig.setUsername(DB_USER_NAME);
        dataSourceConfig.setPassword(DB_PASSWORD);
        dataSourceConfig.setDefaultAutoCommit(true);
        dataSourceConfig.setDefaultReadOnly(false);
        dataSourceConfig.setPoolPreparedStatements(false);
    }
    //in client-server environment this may be called from client and server in the same VM
    if (dataSourceRuntime == null) {
        dataSourceRuntime = new BasicDataSource();
        dataSourceRuntime.setDriverClassName(driverName);
        dataSourceRuntime.setUrl(getConnectionURI(dbHost, DB_RUNTIME));
        dataSourceRuntime.setUsername(DB_USER_NAME);
        dataSourceRuntime.setPassword(DB_PASSWORD);
        dataSourceRuntime.setDefaultAutoCommit(true);
        dataSourceRuntime.setDefaultReadOnly(false);
        dataSourceRuntime.setPoolPreparedStatements(false);
    }
}

From source file:mx.com.pixup.portal.dao.ArtistaGenerateDaoJdbc.java

public ArtistaGenerateDaoJdbc() throws IOException {
    BasicDataSource dataSource = new BasicDataSource();

    //seccion de la DB
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUsername("root");
    dataSource.setPassword("admin");
    //dataSource.setPassword("mysqlroot");
    dataSource.setUrl("jdbc:mysql://localhost:3306/pixup");
    this.dataSource = dataSource;

    //seccion XML
    this.xmlLogico = new Document();
    this.xmlFisico = new XMLOutputter();
    this.archivoFisico = new FileWriter(
            "C:\\Users\\JAVA-08\\Documents\\VOSS\\Modulo 5\\pixup-dao-xml\\src\\testXML\\artistasNuevo.xml");
}

From source file:mx.com.pixup.portal.dao.MunicipioGenerateDaoJdbc.java

public MunicipioGenerateDaoJdbc() throws IOException {
    BasicDataSource dataSource = new BasicDataSource();

    //seccion de la DB
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUsername("root");
    dataSource.setPassword("admin");
    //dataSource.setPassword("mysqlroot");
    dataSource.setUrl("jdbc:mysql://localhost:3306/pixup");
    this.dataSource = dataSource;

    //seccion XML
    this.xmlLogico = new Document();
    this.xmlFisico = new XMLOutputter();
    this.archivoFisico = new FileWriter(
            "C:\\Users\\JAVA-08\\Documents\\VOSS\\Modulo 5\\pixup-dao-xml\\src\\testXML\\municipio1.xml");
}

From source file:com.alibaba.druid.pool.dbcp.Test0.java

public void test_idle() throws Exception {
    MockDriver driver = MockDriver.instance;

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:mock:xxx");
    dataSource.setDriverClassName("com.alibaba.druid.mock.MockDriver");
    dataSource.setInitialSize(0);//from   w w w .  j av a 2  s . c  o m
    dataSource.setMaxActive(4);
    dataSource.setMaxIdle(4);
    dataSource.setMinIdle(1);
    dataSource.setMinEvictableIdleTimeMillis(5000 * 1);
    dataSource.setTimeBetweenEvictionRunsMillis(10);
    dataSource.setTestWhileIdle(false);
    dataSource.setTestOnBorrow(false);
    dataSource.setValidationQuery("SELECT 1");

    {
        Connection conn = dataSource.getConnection();

        // Assert.assertEquals(dataSource.getInitialSize(), driver.getConnections().size());
        System.out.println("raw size : " + driver.getConnections().size());

        conn.close();
        System.out.println("raw size : " + driver.getConnections().size());
    }

    {
        Connection conn = dataSource.getConnection();

        // Assert.assertEquals(dataSource.getInitialSize(), driver.getConnections().size());
        System.out.println("raw size : " + driver.getConnections().size());

        conn.close();
        System.out.println("raw size : " + driver.getConnections().size());
    }

    dataSource.close();
}