List of usage examples for org.apache.commons.dbcp2 BasicDataSource toString
public String toString()
From source file:org.yx.db.conn.ConnectionFactory.java
public Map<String, Map<String, Integer>> status() { Set<DataSource> set = new HashSet<>(); set.addAll(this.read.allDataSource()); set.addAll(this.write.allDataSource()); Map<String, Map<String, Integer>> statusMap = new HashMap<>(); for (DataSource datasource : set) { if (!BasicDataSource.class.isInstance(datasource)) { Log.get(this.getClass(), 25345).info("ds.class({}) is not instance form BasicDataSource", datasource.getClass().getName()); continue; }//from w ww . j a v a 2 s . c o m @SuppressWarnings("resource") BasicDataSource ds = (BasicDataSource) datasource; Map<String, Integer> map = new HashMap<>(); map.put("active", ds.getNumActive()); map.put("idle", ds.getNumIdle()); map.put("minIdle", ds.getMinIdle()); map.put("maxIdle", ds.getMaxIdle()); map.put("maxTotal", ds.getMaxTotal()); statusMap.put(ds.toString(), map); } return statusMap; }
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 www .j ava2s. co 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; }