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:cz.muni.fi.pv168.project.hotelmanager.TestReservationManagerImpl.java

@Before
public void setUp() throws SQLException {
    BasicDataSource bds = new BasicDataSource();
    //set JDBC driver and URL
    bds.setDriverClassName(EmbeddedDriver.class.getName());
    bds.setUrl("jdbc:derby:memory:TestReservationManagerDB;create=true");
    this.dataSource = bds;
    //populate db with tables and data
    new ResourceDatabasePopulator(new ClassPathResource("schema-javadb.sql")).execute(bds);
    guestManager = new GuestManagerImpl(bds);
    roomManager = new RoomManagerImpl(bds);
    reservationManager = new ReservationManagerImpl(prepareClockMock(now), bds);
}

From source file:io.druid.metadata.SQLFirehoseDatabaseConnector.java

protected BasicDataSource getDatasource(MetadataStorageConnectorConfig connectorConfig) {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUsername(connectorConfig.getUser());
    dataSource.setPassword(connectorConfig.getPassword());
    String uri = connectorConfig.getConnectURI();
    dataSource.setUrl(uri);/*from  w  ww .j a  v a  2s .  com*/
    dataSource.setTestOnBorrow(true);
    dataSource.setValidationQuery(getValidationQuery());

    return dataSource;
}

From source file:com.cfitzarl.cfjwed.core.config.DatabaseConfigurationContainer.java

@Bean(name = "dataSource")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driver);
    dataSource.setPassword(password);/*from  ww w. j a va2s.  co  m*/
    dataSource.setUsername(username);
    dataSource.setUrl(url);

    return dataSource;
}

From source file:com.ebay.pulsar.analytics.metricstore.db.RDMBSTest.java

@Test
public void testRDBMS2() {
    String driver2 = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://locahost:3306/test";
    String userName = "root";
    String userPwd = "";
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(driver2);/*from w  ww  .  java 2  s. com*/
    bds.setUrl(url);
    bds.setUsername(userName);
    bds.setPassword(userPwd);
    DBFactory.setDs(bds);
    List<String> result = new ArrayList<String>();
    result.add("result");
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(bds);
    RDBMS db = new RDBMS(bds);
    db.setDriver(driver2);
    db.setNamedParameterJdbcTemplate(namedParameterJdbcTemplate);
    db.setUrl(url);
    db.setUserName(userName);
    db.setUserPwd(userPwd);
    assertEquals(userName, db.getUserName());
    assertEquals(url, db.getUrl());
    assertEquals(userPwd, db.getUserPwd());

}

From source file:com.magnet.mmx.server.plugin.mmxmgmt.api.user.MMXUsersResourceTest.java

public static void setupDatabase() throws Exception {
    InputStream inputStream = DeviceDAOImplTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);/*from   w w  w. j  a v  a 2 s.c o  m*/

    String host = testProperties.getProperty("db.host");
    String port = testProperties.getProperty("db.port");
    String user = testProperties.getProperty("db.user");
    String password = testProperties.getProperty("db.password");
    String driver = testProperties.getProperty("db.driver");
    String schema = testProperties.getProperty("db.schema");

    String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(user);
    ds.setPassword(password);
    ds.setUrl(url);

    DBTestUtil.setBasicDataSource(ds);
    new MockUp<AppDAOImpl>() {
        @Mock
        protected String getEncrypted(String value) {
            return value;
        }
    };
    new MockUp<DefaultOpenfireEncryptor>() {
        @Mock
        public String getDecrypted(String value) {
            return value;
        }

        @Mock
        public String getEncrypted(String value) {
            return value;
        }
    };
    DBTestUtil.setupMockDBUtil();
    MMXUsersResourceTest.appEntity = createRandomApp();
    for (int i = 0; i < 10; i++) {
        userEntityList.add(createRandomUser(appEntity, i));
    }
}

From source file:com.graphaware.importer.data.access.DbDataReader.java

/**
 * Create a {@link javax.sql.DataSource} used for talking to the database.
 *
 * @return data source./*from   w  ww . j  a  v  a  2s . c  o  m*/
 */
protected DataSource createDataSource() {
    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setUrl(getUrl(dbHost, dbPort));
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setDefaultReadOnly(true);
    dataSource.setDefaultAutoCommit(false);

    dataSource.setDriverClassName(getDriverClassName());

    additionalConfig(dataSource);

    return dataSource;
}

From source file:com.magnet.mmx.server.plugin.mmxmgmt.db.TagDAOImplTest.java

@BeforeClass
public static void setupDatabase() throws Exception {
    InputStream inputStream = DeviceDAOImplTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);/*  ww w  .  j  av a 2s . co m*/

    String host = testProperties.getProperty("db.host");
    String port = testProperties.getProperty("db.port");
    String user = testProperties.getProperty("db.user");
    String password = testProperties.getProperty("db.password");
    String driver = testProperties.getProperty("db.driver");
    String schema = testProperties.getProperty("db.schema");

    String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(user);
    ds.setPassword(password);
    ds.setUrl(url);

    DBTestUtil.setBasicDataSource(ds);

    setupMocks();
    generateAppData();
    generateDeviceData();
    generateUserData();
    generateTopicData();
    tagDevices();
}

From source file:com.samovich.service.blueprint.App.java

/**
 * Data source configuration with dbcp//  w w  w. j a  va  2 s  .  co m
 * @return dataSource
 */
@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://HOST:PORT/DATABASE_NAME");
    dataSource.setUsername("DB_USER");
    dataSource.setPassword("RB_PW");
    dataSource.setValidationQuery("select 1");
    dataSource.setMaxTotal(50);
    dataSource.setTestOnBorrow(true);
    dataSource.setMaxWaitMillis(10000);
    dataSource.setRemoveAbandonedOnBorrow(true);
    dataSource.setDefaultAutoCommit(false);
    dataSource.setNumTestsPerEvictionRun(3);
    dataSource.setTimeBetweenEvictionRunsMillis(1800000);
    dataSource.setMinEvictableIdleTimeMillis(1800000);
    return dataSource;
}

From source file:com.helger.db.jdbc.AbstractConnector.java

@Nonnull
public final DataSource getDataSource() {
    return m_aLock.locked(() -> {
        if (m_aDataSource == null) {
            // build data source
            m_aDataSource = new BasicDataSource();
            m_aDataSource.setDriverClassName(getJDBCDriverClassName());
            if (getUserName() != null)
                m_aDataSource.setUsername(getUserName());
            if (getPassword() != null)
                m_aDataSource.setPassword(getPassword());
            m_aDataSource.setUrl(getConnectionUrl());

            // settings
            m_aDataSource.setDefaultAutoCommit(Boolean.valueOf(isUseDefaultAutoCommit()));
            m_aDataSource.setPoolPreparedStatements(isPoolPreparedStatements());
        }/*from   ww  w  .  ja v  a  2  s .  c om*/
        return m_aDataSource;
    });
}

From source file:com.magnet.mmx.server.plugin.mmxmgmt.api.tags.MMXDeviceTagsResourceTest.java

public static void setupDatabase() throws Exception {
    InputStream inputStream = DeviceDAOImplTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);/*from  w w  w . j a  va 2s .  c  om*/

    String host = testProperties.getProperty("db.host");
    String port = testProperties.getProperty("db.port");
    String user = testProperties.getProperty("db.user");
    String password = testProperties.getProperty("db.password");
    String driver = testProperties.getProperty("db.driver");
    String schema = testProperties.getProperty("db.schema");

    String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(user);
    ds.setPassword(password);
    ds.setUrl(url);

    DBTestUtil.setBasicDataSource(ds);
    new MockUp<AppDAOImpl>() {
        @Mock
        protected String getEncrypted(String value) {
            return value;
        }
    };
    DBTestUtil.setupMockDBUtil();
    MMXDeviceTagsResourceTest.appEntity = createRandomApp();
    for (int i = 0; i < 5; i++) {
        deviceEntityList.add(createRandomDeviceEntity(appEntity, i));
    }
}