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

Introduction

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

Prototype

public synchronized void setUrl(String url)

Source Link

Document

Sets the #url .

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

Usage

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:co.id.ipb.ilkom.training.db.SpringDataJpaConfiguration.java

@Bean
DataSource dataSource() {/*from w w w  . j  a  v  a  2 s .  c  om*/
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:mysql://localhost:3306/trainingjava");
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUsername("root");
    dataSource.setPassword("root");
    dataSource.setInitialSize(20);
    dataSource.setMaxIdle(20);
    dataSource.setMaxTotal(100);
    return dataSource;
}

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.peertopark.spring.data.SpringDataConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(dataSourceConfig.getJDBCUrl());
    dataSource.setUsername(dataSourceConfig.getJDBCUser());
    dataSource.setPassword(dataSourceConfig.getJDBCPassword());
    dataSource.setDriverClassName(dataSourceConfig.getJDBCDriver());
    dataSource.setMaxTotal(dataSourceConfig.getMaxConnections());
    return dataSource;
}

From source file:com.tamnd.app.config.DataSourceConfig.java

@Bean
public DataSource h2DataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUrl("jdbc:h2:mem:test");
    dataSource.setUsername("sa");
    dataSource.setPassword("sa");
    return dataSource;
}

From source file:com.bc.fiduceo.db.StorageTest.java

@Test
public void testInitWithUnregisteredDriverUrlThrows() throws SQLException {
    final BasicDataSource weirdDataSource = new BasicDataSource();
    weirdDataSource.setUrl("stupid:unregistered:data_base:driver");

    try {//from  w w w  . j  a  va  2s  .  com
        Storage.create(weirdDataSource, geometryFactory);
        fail("IllegalArgumentException expected");
    } catch (IllegalArgumentException expected) {
    }
}

From source file:com.tamnd.app.config.DataSourceConfig.java

@Bean
public DataSource mysqlDataSource() {
    String _user = "root";
    String _password = "123456";
    String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=10&";

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(url);
    dataSource.setUsername(_user);/*from  w  ww . j  av  a2 s .c  o  m*/
    dataSource.setPassword(_password);
    return dataSource;
}

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

@Bean
public DataSource dataSource() {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    bds.setUrl(dbUrl);
    return bds;//from   ww w.jav  a  2 s.co  m
}

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;/*from  w  w  w.ja v a2s.  c o  m*/
}