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

List of usage examples 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:uk.co.platosys.db.jdbc.ConnectionBroker.java

private void init() {

    List<DatabaseCredentials> databases = properties.getDatabases();
    for (DatabaseCredentials credentials : databases) {

        String name = "";
        String driver = "";
        String userName = "";
        String password = "";
        String url = "";
        try {/*from  ww w  .j  a va 2  s  .  c  o  m*/
            name = credentials.getName();
            logger.log("ConnectionBroker initialising database " + name);
            driver = credentials.getDriver();
            url = credentials.getUrl();
            userName = credentials.getUsername();
            password = credentials.getPassword();
            logger.log("ConnectionBroker credentials for " + name + " are " + driver + " " + url + " "
                    + userName + " " + password);

        } catch (Exception e) {
            logger.log("ConnectionBroker had a problem getting credentials for " + name, e);
        }
        /* try{
            //although we only use postgresql, there's no reason we couldn't use a different sql rdbms with a different driver for each
            //database.
        Class.forName(driver);
         }catch(ClassNotFoundException e){
        logger.log("ConnectionBroker couldn't load database driver", e);
         }*/
        try {
            /*connFac = new DriverManagerConnectionFactory(url, userName, password);
            PoolableConnectionFactory poolableConFac = new PoolableConnectionFactory(connFac, null);
            GenericObjectPool<PoolableConnection> connectionPool = new GenericObjectPool<PoolableConnection>(poolableConFac);
            pools.put(name, connectionPool);
            poolableConFac.setPool(connectionPool);
            PoolingDataSource<PoolableConnection> dataSource = new PoolingDataSource<PoolableConnection>(connectionPool);*/
            BasicDataSource dataSource = new BasicDataSource();
            dataSource.setDriverClassName(driver);
            dataSource.setUsername(userName);
            dataSource.setPassword(password);
            dataSource.setUrl(url);
            dataSource.setMinIdle(2);
            dataSource.setMaxTotal(MAX_ACTIVE);
            logger.log(5, "ConnectionBroker has made BasicDataSource " + dataSource.toString());
            logger.log("Datasource " + name + " has " + dataSource.getMaxTotal() + " maxConnections");
            try {
                Connection connection = dataSource.getConnection();
                connection.close();
                dataSources.put(name, dataSource);
                dataSet.add(dataSource);
                logger.log(5, "ConnectionBroker has initialised database " + name);
            } catch (PSQLException psqe) {
                logger.log("could not make a test connection to database: " + name, psqe);
            }
        } catch (Exception e) {
            logger.log("ConnectionBroker had a problem configuring the pool with " + name, e);
        }
    }
    done = true;
}

From source file:uk.org.linuxgrotto.config.JpaConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(environment.getProperty("jdbc.driverClassName"));
    dataSource.setUrl(environment.getProperty("jdbc.url"));
    dataSource.setUsername(environment.getProperty("jdbc.username"));
    dataSource.setPassword(environment.getProperty("jdbc.password"));

    return dataSource;
}

From source file:xml.cz.Parser.java

/**
 * Main class in which all data are parsed
 * @param args arguments on main class - not supported
 * @throws IOException/*from  www . ja v a  2 s.c om*/
 * @throws SQLException
 * @throws SAXException
 * @throws ParserConfigurationException 
 */
public static void main(String[] args)
        throws IOException, SQLException, SAXException, ParserConfigurationException {
    Properties pro = new Properties();
    pro.load(new FileInputStream("src/main/java/configuration/jdbc.properties"));

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(pro.getProperty("url"));
    ds.setUsername(pro.getProperty("username"));
    ds.setPassword(pro.getProperty("password"));

    SectorManagerImpl sectorManager = new SectorManagerImpl();
    sectorManager.setDataSource(ds);
    ClassificationManagerImpl classificationManager = new ClassificationManagerImpl();
    classificationManager.setDataSource(ds);
    RegionManagerImpl regionManager = new RegionManagerImpl();
    regionManager.setDataSource(ds);

    Parser parser = new Parser();
    parser.parseSector(sectorManager);
    parser.parseClassification(classificationManager);
    parser.parseRegion(regionManager);

    ds.close();
}

From source file:xml.sk.Parser.java

public static void main(String[] args) throws IOException, SQLException, ParserConfigurationException,
        SAXException, XPathExpressionException, ParseException {
    Properties pro = new Properties();
    pro.load(new FileInputStream("src/main/java/configuration/jdbc.properties"));

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(pro.getProperty("url"));
    ds.setUsername(pro.getProperty("username"));
    ds.setPassword(pro.getProperty("password"));

    SectorManagerImpl sectorManager = new SectorManagerImpl();
    sectorManager.setDataSource(ds);/*from  w ww . ja  v  a  2s  .  c  o  m*/
    ClassificationManagerImpl classificationManager = new ClassificationManagerImpl();
    classificationManager.setDataSource(ds);
    EducationManagerImpl educationManager = new EducationManagerImpl();
    educationManager.setDataSource(ds);
    AgeManagerImpl ageManager = new AgeManagerImpl();
    ageManager.setDataSource(ds);

    Parser parser = new Parser();
    parser.parseSectorSk(sectorManager);
    parser.parseClassificationSk(classificationManager);
    parser.parseEducationSk(educationManager);
    parser.parseAgeSk(ageManager);

    ds.close();
}