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:agency.AgencyManagerImplTest.java

private static DataSource prepareDataSource() throws SQLException, IOException {
    Properties myconf = new Properties();
    myconf.load(Agency.class.getResourceAsStream("/myconf.properties"));

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(myconf.getProperty("jdbc.url"));
    ds.setUsername(myconf.getProperty("jdbc.user"));
    ds.setPassword(myconf.getProperty("jdbc.password"));

    return ds;/*from  w  ww .j  a  v a2  s .  c  o  m*/
}

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:edu.secprog.db.DBPool.java

private DBPool() {
    dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUsername(username);/*from   www  .  j a  v a 2  s .co  m*/
    dataSource.setPassword(password);
    dataSource.setUrl(url);
}

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.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.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:com.teradata.tempto.internal.query.JdbcUtils.java

private static DataSource createPoolingDataSource(JdbcConnectivityParamsState jdbcParamsState) {

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(jdbcParamsState.driverClass);
    dataSource.setUrl(jdbcParamsState.url);
    dataSource.setUsername(jdbcParamsState.user);
    dataSource.setPassword(jdbcParamsState.password);
    dataSource.setDriverClassLoader(getDriverClassLoader(jdbcParamsState));
    return dataSource;
}

From source file:app.config.DatabaseConfig.java

@Bean
public BasicDataSource dataSource() throws URISyntaxException {
    String dbUrl = System.getenv("JDBC_DATABASE_URL");
    String username = System.getenv("JDBC_DATABASE_USERNAME");
    String password = System.getenv("JDBC_DATABASE_PASSWORD");

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

    return basicDataSource;
}

From source file:de.unibayreuth.bayceer.bayeos.xmlrpc.ConnectionPool.java

public static Connection getPooledConnection(int userId) throws SQLException {
    logger.debug("Trying to get connection from pool");

    if (ds == null) {
        logger.info("Initialize datasource:" + url);
        ds = new BasicDataSource();
        ds.setDriverClassName("org.postgresql.Driver");
        ds.setUrl(url);//from   w  w  w .  j  a  v  a2 s .  c  o  m
        ds.setUsername(user);
        ds.setPassword(password);
        ds.setMaxTotal(50);
    }
    Connection con = ds.getConnection();
    setUserId(con, userId);
    return con;
}

From source file:edu.neu.webtoolsfinal.config.RepositoryConfiguration.java

@Bean(name = "dataSource")
public DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/deliverydb");
    dataSource.setUsername("root");
    dataSource.setPassword("");

    return dataSource;
}