Example usage for org.apache.commons.dbcp2 BasicDataSource 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.my.spring.batch.java.config.demo.configuration.JobSetup.java

@Bean
public DataSource job1DataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(environment.getProperty("job1.jdbc.driver"));
    dataSource.setUrl(environment.getProperty("job1.jdbc.url"));
    dataSource.setUsername(environment.getProperty("job1.jdbc.user"));
    dataSource.setPassword(environment.getProperty("job1.jdbc.password"));
    return dataSource;
}

From source file:org.ramadda.repository.database.DatabaseManager.java

/**
 * _more_/* ww  w.j  a  v  a2s.  com*/
 *
 * @param connectionUrl _more_
 * @param userName _more_
 * @param password _more_
 *
 * @return _more_
 *
 * @throws Exception _more_
 */
public BasicDataSource makeDataSource(String connectionUrl, String userName, String password) throws Exception {
    String driverClassName = loadDriver(connectionUrl);
    BasicDataSource ds = new BasicDataSource();

    //ds.setMaxActive(getRepository().getProperty(PROP_DB_POOL_MAXACTIVE, 100));
    //ds.setMaxIdle(getRepository().getProperty(PROP_DB_POOL_MAXIDLE,100));
    ds.setMaxTotal(getRepository().getProperty(PROP_DB_POOL_MAXACTIVE, 100));
    //30 second time out
    ds.setMaxWaitMillis(1000 * 30);
    //60 seconds
    ds.setRemoveAbandonedTimeout(60);
    //ds.setRemoveAbandoned(true);
    ds.setRemoveAbandonedOnBorrow(true);
    ds.setRemoveAbandonedOnMaintenance(true);

    //        System.err.println("DatabaseManager.makeDataSource: url="  + connectionUrl);
    //        System.err.println("JDBC driver class:" + driverClassName + " db type:" + dbType);

    ds.setDriverClassName(driverClassName);
    ds.setUsername(userName);
    ds.setPassword(password);
    ds.setUrl(connectionURL);

    /*
    Logger logger = getLogManager().getLogger(LOGID);
    if (logger != null) {
    ds.setLogWriter(new Log4jPrintWriter(logger));
    }
    */

    return ds;
}

From source file:org.shaigor.rest.retro.config.PersistenceConfiguration.java

@PostConstruct
/**/*from   w  ww  . j  a va  2s.  c  o  m*/
 * Creates security data-source to be used with the sample DB 
 */
public void init() {
    securityDataSource = new BasicDataSource();
    securityDataSource.setDriverClassName(com.mysql.jdbc.Driver.class.getName());
    securityDataSource.setUrl("jdbc:mysql://localhost:3306/java_one_2014");
    securityDataSource.setUsername("java_one");
    securityDataSource.setPassword("");
    securityDataSource.setInitialSize(5);
    securityDataSource.setMaxTotal(30);
    securityDataSource.setMaxIdle(15);
    securityDataSource.setMaxWaitMillis(3000);
    securityDataSource.setLogAbandoned(true);
    securityDataSource.setTestWhileIdle(true);
    securityDataSource.setTestOnBorrow(true);
    securityDataSource.setValidationQuery("select 1");
}

From source file:org.springframework.batch.sample.remotepartitioning.DataSourceConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(url);/* w w  w  .  j a  va 2 s .c om*/
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    return dataSource;
}

From source file:org.springframework.boot.autoconfigure.jdbc.JndiDataSourceAutoConfigurationTests.java

@Test
public void dataSourceIsAvailableFromJndi() throws IllegalStateException, NamingException {
    DataSource dataSource = new BasicDataSource();
    configureJndi("foo", dataSource);

    this.context = new AnnotationConfigApplicationContext();
    EnvironmentTestUtils.addEnvironment(this.context, "spring.datasource.jndi-name:foo");
    this.context.register(JndiDataSourceAutoConfiguration.class);
    this.context.refresh();

    assertEquals(dataSource, this.context.getBean(DataSource.class));
}

From source file:org.springframework.boot.autoconfigure.jdbc.JndiDataSourceAutoConfigurationTests.java

@SuppressWarnings("unchecked")
@Test//from   w w  w. j a  v  a2  s  .c  o m
public void mbeanDataSourceIsExcludedFromExport() throws IllegalStateException, NamingException {
    DataSource dataSource = new BasicDataSource();
    configureJndi("foo", dataSource);

    this.context = new AnnotationConfigApplicationContext();
    EnvironmentTestUtils.addEnvironment(this.context, "spring.datasource.jndi-name:foo");
    this.context.register(JndiDataSourceAutoConfiguration.class, MBeanExporterConfiguration.class);
    this.context.refresh();

    assertEquals(dataSource, this.context.getBean(DataSource.class));
    MBeanExporter exporter = this.context.getBean(MBeanExporter.class);
    Set<String> excludedBeans = (Set<String>) new DirectFieldAccessor(exporter)
            .getPropertyValue("excludedBeans");
    assertThat(excludedBeans, contains("dataSource"));
}

From source file:org.wte4j.examples.showcase.server.hsql.HsqlServerBean.java

/**
 * create a new connection source as {@link DataSource} for this server
 * //ww  w.j a v  a2 s  . c om
 * @return a new {@link DataSource} object for this server with pooled
 *         connections
 * 
 */
public synchronized DataSource createDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:hsqldb:hsql://localhost/" + databaseName);
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUsername("sa");
    return dataSource;
}

From source file:pgsql.connection.PooledConnectionFactory.java

public PooledConnectionFactory(URI databaseUri) {
    this.connectionPool = new BasicDataSource();

    initializeConnectionPool(connectionPool, databaseUri);
}

From source file:ro.pippo.session.jdbc.JDBCSessionDataStorageTest.java

@BeforeClass
public static void setUpClass() {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName("org.h2.Driver");
    bds.setUrl("jdbc:h2:mem:test;INIT=runscript from 'src/test/resources/create.sql'");
    bds.setUsername("sa");
    bds.setPassword("sa");
    dataSource = bds;/*from  w ww. j  a  va 2 s.co  m*/
}

From source file:rzd.vivc.documentexamination.configuration.SpringDateConfigMySQL.java

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

    return ds;
}