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

Introduction

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

Prototype

public void setUsername(String username) 

Source Link

Document

Sets the #username .

Note: this method currently has no effect once the pool has been initialized.

Usage

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

@SuppressWarnings("unchecked")
@Test//from  w w w  .j  av a2s . c  o  m
public void testRDBMS() {
    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);
    bds.setUrl(url);
    bds.setUsername(userName);
    bds.setPassword(userPwd);
    DBFactory.setDs(bds);
    List<String> result = new ArrayList<String>();
    result.add("result");
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = Mockito.mock(NamedParameterJdbcTemplate.class);
    when(namedParameterJdbcTemplate.query(Matchers.anyString(), Matchers.any(Map.class),
            Matchers.any(ResultSetExtractor.class))).thenReturn(result);
    RDBMS db = new RDBMS(driver2, url, userName, userPwd);
    db.setDriver(driver2);
    db.setNamedParameterJdbcTemplate(namedParameterJdbcTemplate);
    db.setUrl(url);
    db.setUserName(userName);
    db.setUserPwd(userPwd);
    assertEquals(namedParameterJdbcTemplate, db.getNamedParameterJdbcTemplate());
    Map<String, String> map = new HashMap<String, String>();
    assertTrue(result.equals(db.queryForList("test", map, 10)));

}

---

From source file:guiPackage.AllGuestComboBoxModel.java

private List<Guest> getValues() {
    BasicDataSource mySource = new BasicDataSource();
    mySource.setUrl(ResourceBundle.getBundle("databaseConnection").getString("connection"));
    mySource.setUsername(ResourceBundle.getBundle("databaseConnection").getString("username"));
    mySource.setPassword(ResourceBundle.getBundle("databaseConnection").getString("password"));
    GuestManager mngr = new GuestManagerImpl(mySource);
    return mngr.getAllGuests();
}

---

From source file:guiPackage.AllRoomsComboBoxModel.java

private List<Room> getValues() {
    BasicDataSource mySource = new BasicDataSource();
    mySource.setUrl(ResourceBundle.getBundle("databaseConnection").getString("connection"));
    mySource.setUsername(ResourceBundle.getBundle("databaseConnection").getString("username"));
    mySource.setPassword(ResourceBundle.getBundle("databaseConnection").getString("password"));
    RoomManager mngr = new RoomManagerImpl(mySource);
    return mngr.getAllRooms();
}

---

From source file:cz.fi.muni.pv168.SpringConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(env.getProperty("jdbc.driver"));
    bds.setUrl(env.getProperty("jdbc.url"));
    bds.setUsername(env.getProperty("jdbc.user"));
    bds.setPassword(env.getProperty("jdbc.password"));
    return bds;//w  w w.  j  a  v a2  s .c o  m
}

---

From source file:guiPackage.AllAccomComboBoxModel.java

private List<Accomodation> getValues() {
    BasicDataSource mySource = new BasicDataSource();
    mySource.setUrl(ResourceBundle.getBundle("databaseConnection").getString("connection"));
    mySource.setUsername(ResourceBundle.getBundle("databaseConnection").getString("username"));
    mySource.setPassword(ResourceBundle.getBundle("databaseConnection").getString("password"));
    AccomManager accomMngr = new AccomManagerImpl(mySource);
    return accomMngr.getAllAccoms();
}

---

From source file:guiPackage.AllAccomComboBoxModel.java

@Override
public Object getElementAt(int index) {
    BasicDataSource mySource = new BasicDataSource();
    mySource.setUrl(ResourceBundle.getBundle("databaseConnection").getString("connection"));
    mySource.setUsername(ResourceBundle.getBundle("databaseConnection").getString("username"));
    mySource.setPassword(ResourceBundle.getBundle("databaseConnection").getString("password"));

    GuestManager guestMngr = new GuestManagerImpl(mySource);
    RoomManager roomMngr = new RoomManagerImpl(mySource);
    return (String) (myValues.get(index).getAccomId() + ": "
            + guestMngr.getGuest(myValues.get(index).getGuestId()).getName() + ", "
            + roomMngr.getRoom(myValues.get(index).getRoomId()).getRoomNumber() + " ("
            + myValues.get(index).getStartDate() + " - " + myValues.get(index).getEndDate() + ")");
}

---

From source file:com.alehuo.wepas2016projekti.configuration.ProductionConfiguration.java

/**
 * Heroku -palvelussa kytetn PostgreSQL -tietokantaa tiedon
 * tallentamiseen. Tm metodi hakee herokusta tietokantayhteyden
 * mahdollistavat ympristmuuttujat.// w w  w .j a v  a  2s .c o m
 *
 * @return @throws URISyntaxException
 */
@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();

    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(dbUrl);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);

    //Autocommit pois plt
    basicDataSource.setDefaultAutoCommit(false);

    return basicDataSource;
}

---

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 ww w. ja v a 2  s.  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:hu.fnf.devel.wishbox.persistence.ConfigData.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://sql01x/wishbox");
    dataSource.setUsername(System.getProperty("SQLUser"));
    dataSource.setPassword(System.getProperty("SQLPass"));
    return dataSource;
}

---

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

/**
 * Data source configuration with dbcp//from   www . j a  va2 s  .  c o  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;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »