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

List of usage examples for org.apache.commons.dbcp2 BasicDataSource BasicDataSource

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbcp2.*
  5. BasicDataSource
  6. BasicDataSource

Introduction

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

Prototype

BasicDataSource

Source Link

Usage

From source file:org.adamkrajcik.winecellars.WineCellarsManagerImplTest.java

private DataSource prepareDataSource() {
    BasicDataSource bds = new BasicDataSource();
    bds.setUrl("jdbc:derby:memory:winecellarmanager-test;create=true");
    return bds;//from ww  w  .  jav  a2 s . c  o m
}

From source file:org.adamkrajcik.winecellars.WineManagerImplTest.java

@Before
public void setUp() throws SQLException {
    BasicDataSource bds = new BasicDataSource();
    bds.setUrl("jdbc:derby:memory:winemanager-test;create=true");
    dataSource = bds;// w w  w. ja v  a  2  s  . co  m

    try (Connection conn = dataSource.getConnection()) {
        conn.prepareStatement(
                "CREATE TABLE CELLAR (id BIGINT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, "
                        + "name VARCHAR(256) NOT NULL, address VARCHAR(256) NOT NULL, wineCapacity INTEGER NOT NULL, "
                        + "CONSTRAINT WINECAPACITY_LESS_THAN_OR_EQUAL_ZERO CHECK (wineCapacity > 0))")
                .executeUpdate();
        conn.prepareStatement("CREATE TABLE WINE (id BIGINT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, "
                + "cellarId BIGINT REFERENCES CELLAR (id), name VARCHAR(256) NOT NULL, "
                + "country VARCHAR(128) NOT NULL, productionYear INTEGER NOT NULL, "
                + "quantity INTEGER NOT NULL, type VARCHAR(5) NOT NULL, "
                + "CONSTRAINT YEAR_LESS_THAN_OR_EQUAL_ZERO CHECK (productionYear > 0), "
                + "CONSTRAINT QUANTITY_LESS_THEN_OR_EQUAL_ZERO CHECK (quantity > 0), "
                + "CONSTRAINT INVALID_TYPE CHECK (type IN ('RED', 'WHITE', 'ROSE')))").executeUpdate();
    }

    manager = new WineManagerImpl();
    manager.setDataSource(dataSource);
}

From source file:org.apache.activemq.store.jdbc.JDBCCleanupLimitedPoolTest.java

protected BrokerService createBroker() throws Exception {
    broker = new BrokerService();
    broker.setUseJmx(false);/*from   ww  w.j  av a2 s  .  com*/
    jdbcPersistenceAdapter = new JDBCPersistenceAdapter();
    jdbcPersistenceAdapter.deleteAllMessages();
    jdbcPersistenceAdapter.setCleanupPeriod(0);
    jdbcPersistenceAdapter.setUseLock(false);
    pool = new BasicDataSource();
    pool.setDriverClassName(EmbeddedDriver.class.getCanonicalName());
    pool.setUrl("jdbc:derby:derbyDb;create=false");
    pool.setUsername("uid");
    pool.setPassword("pwd");
    pool.setMaxTotal(2);
    jdbcPersistenceAdapter.setDataSource(pool);
    broker.setPersistenceAdapter(jdbcPersistenceAdapter);
    broker.addConnector("tcp://0.0.0.0:0");
    return broker;
}

From source file:org.apache.jmeter.protocol.jdbc.config.DataSourceElement.java

private BasicDataSource initPool(String maxPool) {
    BasicDataSource dataSource = new BasicDataSource();

    if (log.isDebugEnabled()) {
        StringBuilder sb = new StringBuilder(40);
        sb.append("MaxPool: ");
        sb.append(maxPool);//from  www.  ja v a 2s .  c o  m
        sb.append(" Timeout: ");
        sb.append(getTimeout());
        sb.append(" TrimInt: ");
        sb.append(getTrimInterval());
        sb.append(" Auto-Commit: ");
        sb.append(isAutocommit());
        log.debug(sb.toString());
    }
    int poolSize = Integer.parseInt(maxPool);
    dataSource.setMinIdle(0);
    dataSource.setInitialSize(poolSize);
    dataSource.setMaxIdle(poolSize);
    dataSource.setMaxTotal(poolSize);
    dataSource.setMaxWaitMillis(Long.parseLong(getTimeout()));

    dataSource.setDefaultAutoCommit(Boolean.valueOf(isAutocommit()));

    if (log.isDebugEnabled()) {
        StringBuilder sb = new StringBuilder(40);
        sb.append("KeepAlive: ");
        sb.append(isKeepAlive());
        sb.append(" Age: ");
        sb.append(getConnectionAge());
        sb.append(" CheckQuery: ");
        sb.append(getCheckQuery());
        log.debug(sb.toString());
    }
    dataSource.setTestOnBorrow(false);
    dataSource.setTestOnReturn(false);
    dataSource.setTestOnCreate(false);
    dataSource.setTestWhileIdle(false);

    if (isKeepAlive()) {
        dataSource.setTestWhileIdle(true);
        dataSource.setValidationQuery(getCheckQuery());
        dataSource.setSoftMinEvictableIdleTimeMillis(Long.parseLong(getConnectionAge()));
        dataSource.setTimeBetweenEvictionRunsMillis(Integer.parseInt(getTrimInterval()));
    }

    int transactionIsolation = DataSourceElementBeanInfo.getTransactionIsolationMode(getTransactionIsolation());
    if (transactionIsolation >= 0) {
        dataSource.setDefaultTransactionIsolation(transactionIsolation);
    }

    String _username = getUsername();
    if (log.isDebugEnabled()) {
        StringBuilder sb = new StringBuilder(40);
        sb.append("Driver: ");
        sb.append(getDriver());
        sb.append(" DbUrl: ");
        sb.append(getDbUrl());
        sb.append(" User: ");
        sb.append(_username);
        log.debug(sb.toString());
    }
    dataSource.setDriverClassName(getDriver());
    dataSource.setUrl(getDbUrl());

    if (_username.length() > 0) {
        dataSource.setUsername(_username);
        dataSource.setPassword(getPassword());
    }

    // log is required to ensure errors are available
    //source.enableLogging(new LogKitLogger(log));
    if (log.isDebugEnabled()) {
        log.debug("PoolConfiguration:" + this.dataSource);
    }
    return dataSource;
}

From source file:org.assertj.db.database.sqlite.SqliteConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.sqlite.JDBC");
    dataSource.setUrl("jdbc:sqlite:target/testDerby.db");
    dataSource.setUsername("");
    dataSource.setPassword("");

    try {//  w  w  w  .  j a  v  a  2s .  c om
        try (Connection connection = dataSource.getConnection();) {
            try (Statement statement = connection.createStatement()) {
                statement.executeUpdate("drop table if exists teSt;");
                statement.executeUpdate("create table teSt (" + " Var1 BIGINT PRIMARY KEY,\n" + " vAr2 BLOB,\n"
                        + " vaR3 CHAR,\n" + " var4 CHAR FOR BIT DATA,\n" + " var5 CLOB,\n" + " var6 DATE,\n"
                        + " var7 DECIMAL,\n" + " var8 DOUBLE,\n" + " var9 DOUBLE PRECISION,\n"
                        + " var10 FLOAT,\n" + " var11 INTEGER,\n" + " var12 LONG VARCHAR,\n"
                        + " var13 LONG VARCHAR FOR BIT DATA,\n" + " var14 NUMERIC,\n" + " var15 REAL,\n"
                        + " var16 SMALLINT,\n" + " var17 TIME,\n" + " var18 TIMESTAMP,\n" + " var19 VARCHAR,\n"
                        + " var20 VARCHAR FOR BIT DATA" + " )");
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }

    return dataSource;
}

From source file:org.axe.factory.persistence.DbcpDataSourceFactory.java

private void init() {

    try {// w w w  . java 2  s .  co  m
        DATA_SOURCE = new BasicDataSource();
        DATA_SOURCE.setDriverClassName(DRIVER);
        DATA_SOURCE.setUrl(URL);
        DATA_SOURCE.setUsername(USERNAME);
        DATA_SOURCE.setPassword(PASSWORD);
    } catch (Exception e) {
        LOGGER.error("jdbc driver : " + DRIVER);
        LOGGER.error("jdbc url : " + URL);
        LOGGER.error("jdbc username : " + USERNAME);
        LOGGER.error("jdbc password : " + PASSWORD);
        LOGGER.error("load jdbc driver failure", e);
    }

}

From source file:org.beast.project.template.config.HibernateConfig.java

@Bean(initMethod = "setup", destroyMethod = "cleanup")
@Override/*  ww  w  .  j  ava2 s . co m*/
public DataSource dataSource() {
    /*
     EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
     DataSource ds = builder.setType(EmbeddedDatabaseType.HSQL).build();
     return ds;*/
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(org.hsqldb.jdbcDriver.class.getName());
    basicDataSource.setUsername("sa");
    basicDataSource.setPassword("");
    basicDataSource.setUrl("jdbc:hsqldb:mem:mydb");
    return basicDataSource;
}

From source file:org.beast.project.template.config.MyBatisConfig.java

@Override
public DataSource dataSource() {

    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    //DataSource ds = builder.setType(EmbeddedDatabaseType.HSQL).addScript("schema.sql").build();
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(org.hsqldb.jdbcDriver.class.getName());
    basicDataSource.setUsername("sa");
    basicDataSource.setPassword("");
    basicDataSource.setUrl("jdbc:hsqldb:mem:mydb");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(basicDataSource);
    System.out.println("Creating tables");
    jdbcTemplate.execute("drop table person if exists");
    jdbcTemplate.execute("create table person(id serial, firstName varchar(50), lastName varchar(50))");
    jdbcTemplate.update("INSERT INTO users(firstName, lastName) values (?,?)", "Mike", "Lanyon");
    return basicDataSource;
}

From source file:org.brickhouse.impl.DataSourceBuilder.java

public DataSourceBuilder() {
    ds = new BasicDataSource();
}

From source file:org.cms.config.AppConfig.java

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

    return dataSource;
}