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

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

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbcp.*
  5. BasicDataSource
  6. 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.widsons.spr4.conf.DataBaseConf.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(dbUrl);/*from   w  w w  . j a va 2s  .  c  om*/
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    dataSource.setDriverClassName(driverClassName);
    dataSource.setTestOnBorrow(true);
    dataSource.setTestOnReturn(true);
    dataSource.setTestWhileIdle(true);
    dataSource.setTimeBetweenEvictionRunsMillis(1800000);
    dataSource.setNumTestsPerEvictionRun(3);
    dataSource.setMinEvictableIdleTimeMillis(1800000);
    return dataSource;
}

From source file:com.alibaba.otter.node.etl.common.datasource.AbstractDbDialectTest.java

private DataSource createDataSource(String url, String userName, String password, String driverClassName,
        DataMediaType dataMediaType, String encoding) {
    BasicDataSource dbcpDs = new BasicDataSource();

    dbcpDs.setRemoveAbandoned(true);//from   w  w w. ja v a 2 s .  c o m
    dbcpDs.setLogAbandoned(true);
    dbcpDs.setTestOnBorrow(true);
    dbcpDs.setTestWhileIdle(true);

    // ??
    dbcpDs.setDriverClassName(driverClassName);
    dbcpDs.setUrl(url);
    dbcpDs.setUsername(userName);
    dbcpDs.setPassword(password);

    if (dataMediaType.isOracle()) {
        dbcpDs.addConnectionProperty("restrictGetTables", "true");
        dbcpDs.setValidationQuery("select 1 from dual");
    } else if (dataMediaType.isMysql()) {
        // open the batch mode for mysql since 5.1.8
        dbcpDs.addConnectionProperty("useServerPrepStmts", "true");
        dbcpDs.addConnectionProperty("rewriteBatchedStatements", "true");
        if (StringUtils.isNotEmpty(encoding)) {
            dbcpDs.addConnectionProperty("characterEncoding", encoding);
        }
        dbcpDs.setValidationQuery("select 1");
    }

    return dbcpDs;
}

From source file:com.javacreed.examples.app.DbHelper.java

public void init() {
    DbHelper.LOGGER.debug("Loading properties");
    final Properties properties = new Properties();
    properties.put("db.path", "target/db");
    properties.put("db.username", "sa");
    properties.put("db.password", "");
    try {/* w  w  w .java 2 s .  c  o  m*/
        properties.load(getClass().getResourceAsStream("/app.properties"));
    } catch (final IOException e) {
        DbHelper.LOGGER.error("Failed to load the properties");
    }

    DbHelper.LOGGER.debug("Creating the data source");
    ds = new BasicDataSource();
    ds.setDriverClassName("org.h2.Driver");
    ds.setUrl("jdbc:h2:" + properties.getProperty("db.path"));
    ds.setUsername(properties.getProperty("db.username"));
    ds.setPassword(properties.getProperty("db.password"));

    DbHelper.LOGGER.debug("Executing Flyway (database migration)");
    final Flyway flyway = new Flyway();
    flyway.setDataSource(ds);
    flyway.migrate();
}

From source file:com.xsb.conf.Application.java

/***
 * ??//from   www. jav  a2  s .co  m
 * @return
 */
@Bean
@Primary
@ConfigurationProperties(prefix = "database", locations = "classpath:dbcp.properties")
public BasicDataSource database() {
    BasicDataSource basicDataSource = new BasicDataSource();
    /*basicDataSource.setUrl("jdbc:mysql://localhost:3306/xsb?zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&characterEncoding=UTF-8");
    basicDataSource.setDriverClassName("org.gjt.mm.mysql.Driver");
    basicDataSource.setUsername("root");
    basicDataSource.setPassword("123456");
    basicDataSource.setMaxActive(100);
    basicDataSource.setMaxIdle(30);
    basicDataSource.setMaxWait(30);
    basicDataSource.setMinIdle(10);
    basicDataSource.setValidationQuery("select 1 from dual");
    basicDataSource.setTestOnBorrow(true);*/
    return basicDataSource;
}

From source file:hoot.services.HootServicesSpringConfig.java

@Bean(name = "dataSource")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.postgresql.Driver");
    dataSource.setUrl("jdbc:postgresql://" + env.getProperty("DB_HOST") + ":" + env.getProperty("DB_PORT") + "/"
            + env.getProperty("DB_NAME"));
    dataSource.setUsername(env.getProperty("DB_USER"));
    dataSource.setPassword(env.getProperty("DB_PASSWORD"));
    dataSource.setInitialSize(25);// ww  w .  j  a  va  2s . c om
    dataSource.setMaxActive(90);
    dataSource.setMaxIdle(30);
    dataSource.setDefaultAutoCommit(false);
    dataSource.setRemoveAbandoned(true);
    dataSource.setLogAbandoned(true);
    return dataSource;
}

From source file:com.cyclopsgroup.tornado.sql.DBCPDataSourceService.java

/**
 * Override method DBCPDataSourceFactory in supper class
 *
 * @see org.apache.avalon.framework.activity.Initializable#initialize()
 *///from   w ww  .j  a  va  2  s .  com
public void initialize() throws Exception {
    BasicDataSource bds = new BasicDataSource();
    BeanUtils.populate(bds, properties);
    dataSource = bds;
}

From source file:de.topicmapslab.majortom.database.jdbc.core.SessionImpl.java

/**
 * Constructor//from   w ww  . j  av a  2  s. com
 * 
 * @param connectionProvider
 *            the parent connection provider
 * @param url
 *            the URL
 * @param user
 *            the user
 * @param password
 *            the password
 */
public <T extends IConnectionProvider> SessionImpl(final T connectionProvider, final String url,
        final String user, final String password) {
    // this.url = url;
    // this.user = user;
    // this.password = password;
    this.connectionProvider = connectionProvider;
    this.autoCommit = true;
    bds = new BasicDataSource();
    bds.setDriverClassName(connectionProvider.getDriverClassName());
    bds.setUsername(user);
    bds.setPassword(password);
    bds.setUrl(url);
    bds.setDefaultAutoCommit(isAutoCommit());
    bds.setMaxActive(20);
    bds.setPoolPreparedStatements(true);
    // processors = new HashMap<Connection, IQueryProcessor>();
}

From source file:com.ianzepp.logging.jms.service.BasicDaoTest.java

/**
 * TODO Method description for <code>setUpBeforeClass()</code>
 * //from w ww .  j  a v a2s  .c o  m
 * @throws SQLException
 */
@BeforeClass
public static void setUpBeforeClass() throws SQLException {
    // Create the dao mapping
    namedQueries = new HashMap<String, String>();
    namedQueries.put("FindEventById", "src/main/resources/com.ianzepp.logging.jms.service.FindEventById.sql");
    namedQueries.put("InsertEvent", "src/main/resources/com.ianzepp.logging.jms.service.InsertEvent.sql");
    namedQueries.put("InsertException",
            "src/main/resources/com.ianzepp.logging.jms.service.InsertEventException.sql");
    namedQueries.put("InsertLocation",
            "src/main/resources/com.ianzepp.logging.jms.service.InsertEventLocation.sql");
    namedQueries.put("InsertUserRequest",
            "src/main/resources/com.ianzepp.logging.jms.service.InsertEventUserRequest.sql");

    // Create and save the datasource
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(DB_DRIVER);
    basicDataSource.setUrl(DB_URI);
    basicDataSource.setUsername(DB_USERNAME);
    basicDataSource.setPassword(DB_PASSWORD);
    dataSource = basicDataSource;
}

From source file:com.bentechapps.angularcrud.config.SpringApplication.java

private DataSource localDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(env.getProperty("spring.datasource.driverClassName"));
    dataSource.setUrl(env.getProperty("spring.datasource.url"));
    dataSource.setUsername(env.getProperty("spring.datasource.username"));
    dataSource.setPassword(env.getProperty("spring.datasource.password"));

    return dataSource;
}

From source file:de.siemens.quantarch.bugs.IssueTrackerParser.java

/**
 * Build the database connection//  w w w. j  a v  a 2 s .  c  o m
 * 
 * @return
 */
private DataSource buildDataSource() {
    // create the data source for database
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://" + projectConfig.getDbHost() + ":3306/" + projectConfig.getDbName());
    dataSource.setUsername(projectConfig.getDbUser());
    dataSource.setPassword(projectConfig.getDbPassword());
    dataSource.setInitialSize(30);
    return dataSource;
}