List of usage examples for org.apache.commons.dbcp2 BasicDataSource setUsername
public void setUsername(String username)
Sets the #username .
Note: this method currently has no effect once the pool has been initialized.
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(); }