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.gnizr.web.action.timeline.TestUserBookmarkTimeline.java

public TestUserBookmarkTimeline() {
    dataSource = new BasicDataSource();
    dataSource.setUsername("gnizr");
    dataSource.setPassword("gnizr");
    dataSource.setUrl("jdbc:mysql://localhost/gnizr_test");
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");

    gnizrDao = GnizrDao.getInstance(dataSource);

    userManager = new UserManager(gnizrDao);
}

From source file:com.dangdang.ddframe.rdb.transaction.soft.storage.impl.RdbTransactionLogStorageTest.java

@Before
public void setup() throws SQLException {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.h2.Driver.class.getName());
    dataSource.setUrl("jdbc:h2:mem:db_trans");
    dataSource.setUsername("sa");
    createTable(dataSource);//from ww  w .  j av a2 s  .com
    storage = new RdbTransactionLogStorage(dataSource);
}

From source file:com.abixen.platform.core.configuration.PlatformDataSourceConfiguration.java

@Profile(PlatformProfiles.DEV)
@Bean(destroyMethod = "close")
public DataSource devDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(platformJdbcConfiguration.getDriverClassName());
    dataSource.setUrl(platformJdbcConfiguration.getDatabaseUrl());
    dataSource.setUsername(platformJdbcConfiguration.getUsername());
    dataSource.setPassword(platformJdbcConfiguration.getPassword());
    //DatabasePopulatorUtils.execute(databasePopulator(), dataSource);
    return dataSource;
    //DataSource dataSource = new EmbeddedDatabaseBuilder().setType(EmbeddedDatabaseType.H2).setName("devDataBase").build();
    //return dataSource;
}

From source file:com.stratelia.silverpeas.silverStatisticsPeas.control.PerfVolumeTest.java

@BeforeClass
public static void setupDataSource() throws NamingException {
    SimpleMemoryContextFactory.setUpAsInitialContext();
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.postgresql.Driver");
    ds.setUsername("postgres");
    ds.setPassword("postgres");
    ds.setUrl("jdbc:postgresql://localhost:5432/extranet");
    InitialContext ic = new InitialContext();
    ic.bind("java:/datasources/silverpeas-jdbc", ds);
    ic.bind("java:/datasources/DocumentStoreDS", ds);
}

From source file:edu.infsci2560.DatabaseConfig.java

@Bean
public BasicDataSource dataSource() throws URISyntaxException {
    URI dbUri = new URI(System.getenv("DATABASE_URL"));

    String username = dbUri.getUserInfo().split(":")[0];
    String password = dbUri.getUserInfo().split(":")[1];
    String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath()
            + "?sslmode=require";

    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(dbUrl);//from   ww w  .j  a  va  2s  .  c o m
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);

    return basicDataSource;
}

From source file:com.oncecorp.visa3d.bridge.utility.JdbcUtils.java

/**
 * This method create and returns the client data source object.  In this class,
 * we use "Jakarta-commons-release" to create the data source object.
 * @param driverClass The JDBC driver class name.
 * @param jdbcURL The database URL./*  ww  w .  j  av  a 2 s  . c  o m*/
 * @param jdbcUID The database user id.
 * @param jdbcPW The database password.
 * @param maxConns maximum connections
 * @param timeOut  connection timeout
 * @return The data Source object.
 */
public static DataSource createPoolingDataSoruce(String driverClass, String jdbcURL, String jdbcUID,
        String jdbcPW, int maxConns, int timeOut) {
    try {
        Class.forName(driverClass);
        BasicDataSource bds = new BasicDataSource();
        bds.setDriverClassName(driverClass);
        bds.setMaxActive(maxConns);
        bds.setMaxWait(timeOut);
        bds.setUrl(jdbcURL);
        bds.setUsername(jdbcUID);
        bds.setPassword(jdbcPW);

        System.out.println("Use dbcp pool with datasource = " + bds);
        return bds;
    } catch (Exception e) {
        System.out.println("Data Source creating failed. -- " + driverClass + ", " + jdbcURL + ", " + jdbcUID
                + ", " + jdbcPW + ", ==" + e.getMessage());
        return null;
    }
}

From source file:io.pivotal.spring.xd.jdbcgpfdist.support.GreenplumDataSourceFactoryBean.java

@Override
protected BasicDataSource createInstance() throws Exception {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.postgresql.Driver");
    if (StringUtils.hasText(dbUser)) {
        ds.setUsername(dbUser);//from   w ww .j  a  va2 s.co m
    }
    if (StringUtils.hasText(dbPassword)) {
        ds.setPassword(dbPassword);
    }
    ds.setUrl("jdbc:postgresql://" + dbHost + ":" + dbPort + "/" + dbName);
    return ds;
}

From source file:herddb.jdbc.CommonsDBCPTest.java

@Test
public void test() throws Exception {
    try (Server server = new Server(new ServerConfiguration(folder.newFolder().toPath()))) {
        server.start();/*from   w ww.j a v  a2s.  co  m*/
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUrl("jdbc:herddb:server:localhost:7000?");
        dataSource.setDriverClassName(Driver.class.getName());
        try (Connection connection = dataSource.getConnection();
                Statement statement = connection.createStatement();
                ResultSet rs = statement.executeQuery("SELECT * FROM SYSTABLES")) {
            int count = 0;
            while (rs.next()) {
                System.out.println("table: " + rs.getString(1));
                count++;
            }
            assertTrue(count > 0);
        }
        dataSource.close();

    }
}

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

@Test
public void assertCreateJobEventListenerSuccess() throws JobEventListenerConfigurationException {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.h2.Driver.class.getName());
    dataSource.setUrl("jdbc:h2:mem:job_event_storage");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    assertThat(new JobEventRdbConfiguration(dataSource).createJobEventListener(),
            instanceOf(JobEventRdbListener.class));
}

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

JobRdbEventStorage(final String driverClassName, final String url, final String username, final String password,
        final LogLevel logLevel) throws SQLException {
    this.logLevel = logLevel;
    // TODO pool?
    dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(url);//ww  w.j av  a  2s  .c om
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    createJobExecutionTable();
    createJobTraceTable();
}