List of usage examples for org.apache.commons.dbcp BasicDataSource getUsername
public synchronized String getUsername()
From source file:com.hotinno.feedmonitor.batch.Main.java
public static void main(String[] args) throws Throwable { try {/* w w w . ja v a 2s .c o m*/ log.error("Entering batch..."); String env = System.getenv("VCAP_SERVICES"); log.error("************************************************************************"); log.error("VCAP_SERVICES is: " + env); log.error("************************************************************************"); AnnotationConfigApplicationContext applicationContext = new AnnotationConfigApplicationContext( BuffaloBatchConfiguration.class); org.apache.commons.dbcp.BasicDataSource ds = (org.apache.commons.dbcp.BasicDataSource) applicationContext .getBean("myDataSource"); log.error(String.format("URL: %s", ds.getUrl())); log.error(String.format("Username: %s", ds.getUsername())); log.error(String.format("Password: %s", ds.getPassword())); applicationContext.start(); log.error("Running..."); } catch (Throwable t) { System.err.println(t); t.printStackTrace(); log.error("Error occurred.", t); } }
From source file:ch.tatool.app.service.impl.UserAccountDAO.java
public void setAccountPassword(final UserAccountImpl account, final String password) { getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) { // find the username BasicDataSource dataSource = (BasicDataSource) account.getBeanFactory() .getBean("userAccountDataSource"); String username = dataSource.getUsername(); String newPassword = password != null ? password : ""; //String driver = dataSource.getDriverClassName(); // update the password using an alter user sql query (every db except mysql) try { StringBuilder sql = new StringBuilder(); sql.append("ALTER USER '").append(username).append("' SET PASSWORD '").append(newPassword) .append("'"); SQLQuery query = session.createSQLQuery(sql.toString()); query.executeUpdate();/* w ww. j a v a 2 s . c o m*/ // update the current account object dataSource.setPassword(newPassword); account.setPassword(newPassword); account.setPasswordProtected(!newPassword.isEmpty()); } catch (HibernateException hb) { //TODO: Add something } return null; } }); }
From source file:com.pactera.edg.am.metamanager.extractor.dao.impl.TargetDBInfoDaoImpl.java
public void getTargetDBInfo() { log.info(//w w w. jav a 2 s . co m "???(??,??,?)."); try { BasicDataSource ds = (BasicDataSource) super.getJdbcTemplate().getDataSource(); DatabaseMetaData metaData = ds.getConnection().getMetaData(); int maxMetadataCodeSize = getColumnSize(metaData, ds.getUsername().toUpperCase(), "T_MD_INSTANCE", "INSTANCE_CODE"); if (maxMetadataCodeSize != -1) AdapterExtractorContext.getInstance().setMaxMetadataCodeSize(maxMetadataCodeSize); int maxMetadataNameSize = getColumnSize(metaData, ds.getUsername().toUpperCase(), "T_MD_INSTANCE", "INSTANCE_NAME"); if (maxMetadataNameSize != -1) AdapterExtractorContext.getInstance().setMaxMetadataNameSize(maxMetadataNameSize); int maxMetadataAttrSize = getColumnSize(metaData, ds.getUsername().toUpperCase(), "T_MD_INSTANCE", "STRING_3"); if (maxMetadataAttrSize != -1) AdapterExtractorContext.getInstance().setMaxMetadataAttrSize(maxMetadataAttrSize); int maxLogSize = getColumnSize(metaData, ds.getUsername().toUpperCase(), "T_TASK_INSTANCE_DESC", "DESCRIPTION"); if (maxLogSize != -1) AdapterExtractorContext.getInstance().setMaxLogSize(maxLogSize); // ----------------------------------- print(); } catch (SQLException e) { log.error("??", e); } }
From source file:fr.cnes.sitools.datasource.jdbc.DataSourceMonitoringResource.java
/** * Trace informations for a sitoolsDataSource * //from w ww .j av a2s . c o m * @param sitoolsDataSource * SitoolsDataSource * @param messages * ArrayList<String> messages */ private void traceStatus(SitoolsSQLDataSource sitoolsDataSource, ArrayList<String> messages) { DataSource concreteDs = sitoolsDataSource.getDs(); if ((concreteDs != null) && (concreteDs instanceof BasicDataSource)) { BasicDataSource bds = (BasicDataSource) concreteDs; messages.add("--------------------------------------------------"); messages.add("Url: " + bds.getUrl()); messages.add("User: " + bds.getUsername()); messages.add("DefaultCatalog: " + bds.getDefaultCatalog()); messages.add("InitialSize: " + bds.getInitialSize()); messages.add("NumActive: " + bds.getNumActive()); messages.add("MaxActive: " + bds.getMaxActive()); messages.add("MaxIdl: " + bds.getMaxIdle()); messages.add("MinIdl: " + bds.getMinIdle()); messages.add("NumIdle: " + bds.getNumIdle()); } }
From source file:de.knurt.fam.template.model.ViewSystemConfigurationModelFactory.java
public Properties getProperties(TemplateResource templateResource) { Properties result = new Properties(); result.put("configuration_reloaded", templateResource.configurationReloadIsRequested()); Properties props = new Properties(); props.put("config_dir", FamConnector.getConfigDirectory()); props.putAll(FamConnector.getGlobalProperties()); List<KeyValue> kvs = FamDaoProxy.keyValueDao().getAll(); for (KeyValue kv : kvs) { props.put("kv_" + kv.key(), kv.value()); }/*from www . j a va 2 s .c om*/ props.put("dao_booking_class", FamDaoProxy.bookingDao().getClass()); props.put("dao_facility_availability_class", FamDaoProxy.facilityDao().getClass()); props.put("dao_logbook_class", FamDaoProxy.logbookEntryDao().getClass()); props.put("dao_user_class", FamDaoProxy.userDao().getClass()); props.put("dao_kv_class", FamDaoProxy.keyValueDao().getClass()); props.put("role_standard", RoleConfigDao.getInstance().getStandardId()); props.put("role_admin", RoleConfigDao.getInstance().getAdminId()); props.put("authentication_module", FamAuth.me().getUserAuthentication().getClass()); // put in cronjobs List<CronjobAction> cronjobs = CronjobActionContainer.getInstance().getAllCronjobActions(); int i = 0; for (CronjobAction cronjob : cronjobs) { props.put(++i + "_cronjob_desc", cronjob.getDescription()); props.put(i + "_cronjob_class", cronjob.getClass()); props.put(i + "_cronjob_every", durationAdapter.getText(cronjob.resolveEvery())); } try { BasicDataSource bds = ((BasicDataSource) RequestContextUtils .getWebApplicationContext(templateResource.getRequest()).getBean("dataSource")); props.put("sql_url", bds.getUrl()); props.put("sql_username", bds.getUsername()); } catch (Exception e) { props.put("sql_ERROR", e.getMessage()); } props.put("password_encoding_algorithm", FamEncoder.getInstance().getEncoder().getAlgorithm()); boolean couchdb_test_query_succ = false; try { props.put("couchdb_real_name", FamCouchDBDao.getInstance().databaseName()); props.put("couchdb_document_count", FamCouchDBDao.getInstance().documentCount()); couchdb_test_query_succ = true; } catch (Exception e) { } props.put("couchdb_test_query_succ", couchdb_test_query_succ); result.put("props", props); return result; }
From source file:com.googlecode.psiprobe.beans.DbcpDatasourceAccessor.java
public DataSourceInfo getInfo(Object resource) throws Exception { DataSourceInfo dataSourceInfo = null; if (canMap(resource)) { BasicDataSource source = (BasicDataSource) resource; dataSourceInfo = new DataSourceInfo(); dataSourceInfo.setBusyConnections(source.getNumActive()); dataSourceInfo.setEstablishedConnections(source.getNumIdle() + source.getNumActive()); dataSourceInfo.setMaxConnections(source.getMaxActive()); dataSourceInfo.setJdbcURL(source.getUrl()); dataSourceInfo.setUsername(source.getUsername()); dataSourceInfo.setResettable(false); dataSourceInfo.setType("commons-dbcp"); }/*from w w w . ja va2s. com*/ return dataSourceInfo; }
From source file:com.funambol.server.db.DataSourceContextHelperTest.java
public void testconfigureAndBindDataSources() throws Throwable { DataSourceContextHelper.configureAndBindDataSources(); BasicDataSource dsFnblds = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblds"); assertNotNull(dsFnblds);/*from w w w .ja v a 2s. com*/ assertEquals("jdbc:hsqldb:hsql://localhost/funambol", dsFnblds.getUrl()); assertEquals("db", dsFnblds.getUsername()); assertEquals("", dsFnblds.getPassword()); assertEquals("org.hsqldb.jdbcDriver", dsFnblds.getDriverClassName()); BasicDataSource dsCore = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblcore"); assertNotNull(dsCore); assertEquals("jdbc:hsqldb:hsql://localhost/funambol", dsCore.getUrl()); assertEquals("db", dsCore.getUsername()); assertEquals("ss", dsCore.getPassword()); assertEquals("org.hsqldb.jdbcDriver", dsCore.getDriverClassName()); BasicDataSource dsUser = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnbluser"); assertNotNull(dsUser); assertEquals("jdbc:hsqldb:hsql://localhost/user", dsUser.getUrl()); assertEquals("fnbluserpwd", dsUser.getUsername()); assertEquals("fnblpwd", dsUser.getPassword()); assertEquals("org.fnbluser", dsUser.getDriverClassName()); // // This test is to verify that the case (lower or upper) of the configuration // file is taken in consideration // boolean found = true; BasicDataSource dsUserds2 = null; try { dsUserds2 = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblUSER"); } catch (NameNotFoundException e) { found = false; } assertFalse(found); BasicDataSource dsUPPER = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/UPPERCASE"); assertNotNull(dsUPPER); assertEquals("jdbc:hsqldb:hsql://localhost/user", dsUPPER.getUrl()); assertEquals("fnbluserpwd", dsUPPER.getUsername()); assertEquals("fnblpwd", dsUPPER.getPassword()); assertEquals("org.fnbluser", dsUPPER.getDriverClassName()); // // This test is to verify that the case of the configuration file is taken // in consideration // found = true; BasicDataSource dsUPPER2 = null; try { dsUPPER2 = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/uppercase"); } catch (NameNotFoundException e) { found = false; } assertFalse(found); RoutingDataSource routingDS = (RoutingDataSource) DataSourceTools .lookupDataSource("jdbc/fnbluser-routing-with-partition"); routingDS.init(); routingDS.configure(); assertNotNull(routingDS); assertTrue(routingDS.getPartitioningCriteria() instanceof MockPartitioningCriteria); Map<String, DataSource> dataSources = (Map<String, DataSource>) PrivateAccessor.getField(routingDS, "dataSources"); assertTrue(dataSources.size() == 3); org.apache.tomcat.dbcp.dbcp.BasicDataSource ds1 = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) dataSources .get("user_part1"); assertNotNull("user_part1 must be not null", ds1); assertEquals("sa", ds1.getUsername()); assertEquals("", ds1.getPassword()); assertEquals("jdbc:hsqldb:mem:user_part1", ds1.getUrl()); assertEquals(15, ds1.getNumTestsPerEvictionRun()); // from db.xml org.apache.tomcat.dbcp.dbcp.BasicDataSource ds2 = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) dataSources .get("user_part2"); assertNotNull("user_part2 must be not null", ds2); assertEquals("sa", ds2.getUsername()); assertEquals("", ds2.getPassword()); assertEquals("jdbc:hsqldb:mem:user_part2", ds2.getUrl()); assertEquals(15, ds2.getNumTestsPerEvictionRun()); // from db.xml org.apache.tomcat.dbcp.dbcp.BasicDataSource ds3 = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) dataSources .get("user_part3"); assertNotNull("user_part3 must be not null", ds3); assertEquals("sa", ds3.getUsername()); assertEquals("", ds3.getPassword()); assertEquals("jdbc:hsqldb:mem:user_part3", ds3.getUrl()); assertEquals(15, ds3.getNumTestsPerEvictionRun()); // from db.xml }
From source file:net.risesoft.soa.asf.web.controller.SystemController.java
private List<SysInfo> getDBInfo() { List list = new ArrayList(); String group = "4. ??"; try {// www. j a v a2 s . c o m Connection conn = this.basicDataSource.getConnection(); try { DatabaseMetaData dbmd = conn.getMetaData(); list.add(new SysInfo("DatabaseProductName", dbmd.getDatabaseProductName(), group)); list.add(new SysInfo("DatabaseProductVersion", dbmd.getDatabaseProductVersion(), group)); list.add(new SysInfo("DatabaseMajorVersion", Integer.valueOf(dbmd.getDatabaseMajorVersion()), group)); list.add(new SysInfo("DatabaseMinorVersion", Integer.valueOf(dbmd.getDatabaseMinorVersion()), group)); list.add(new SysInfo("DriverName", dbmd.getDriverName(), group)); list.add(new SysInfo("DriverVersion", dbmd.getDriverVersion(), group)); list.add(new SysInfo("DriverMajorVersion", Integer.valueOf(dbmd.getDriverMajorVersion()), group)); list.add(new SysInfo("DriverMinorVersion", Integer.valueOf(dbmd.getDriverMinorVersion()), group)); } finally { conn.close(); } group = "5. ?"; BasicDataSource bds = this.basicDataSource; list.add(new SysInfo("InitialSize", Integer.valueOf(bds.getInitialSize()), group)); list.add(new SysInfo("MaxActive", Integer.valueOf(bds.getMaxActive()), group)); list.add(new SysInfo("MaxIdle", Integer.valueOf(bds.getMaxIdle()), group)); list.add(new SysInfo("MinIdle", Integer.valueOf(bds.getMinIdle()), group)); list.add(new SysInfo("MaxWait", Long.valueOf(bds.getMaxWait()), group)); list.add(new SysInfo("NumActive", Integer.valueOf(bds.getNumActive()), group)); list.add(new SysInfo("NumIdle", Integer.valueOf(bds.getNumIdle()), group)); list.add(new SysInfo("DriverClass", bds.getDriverClassName(), group)); list.add(new SysInfo("URL", bds.getUrl(), group)); list.add(new SysInfo("Username", bds.getUsername(), group)); list.add(new SysInfo("Password", "******", group)); } catch (Exception ex) { log.warn("???: " + ex.getMessage(), ex); } return list; }
From source file:net.testdriven.psiprobe.beans.DbcpDatasourceAccessor.java
public DataSourceInfo getInfo(Object resource) throws Exception { DataSourceInfo dataSourceInfo = null; if (canMap(resource)) { BasicDataSource source = (BasicDataSource) resource; dataSourceInfo = new DataSourceInfo(); dataSourceInfo.setBusyConnections(source.getNumActive()); dataSourceInfo.setEstablishedConnections(source.getNumIdle() + source.getNumActive()); dataSourceInfo.setMaxConnections(source.getMaxActive()); dataSourceInfo.setJdbcURL(source.getUrl()); dataSourceInfo.setUsername(source.getUsername()); dataSourceInfo.setResettable(false); }//from www . j ava2s . c om return dataSourceInfo; }
From source file:org.alfresco.repo.tenant.TenantBasicDataSource.java
public TenantBasicDataSource(BasicDataSource bds, String tenantUrl, int tenantMaxActive) throws SQLException { // tenant-specific this.setUrl(tenantUrl); this.setMaxActive(tenantMaxActive == -1 ? bds.getMaxActive() : tenantMaxActive); // defaults/overrides - see also 'baseDefaultDataSource' (core-services-context.xml + repository.properties) this.setDriverClassName(bds.getDriverClassName()); this.setUsername(bds.getUsername()); this.setPassword(bds.getPassword()); this.setInitialSize(bds.getInitialSize()); this.setMinIdle(bds.getMinIdle()); this.setMaxIdle(bds.getMaxIdle()); this.setDefaultAutoCommit(bds.getDefaultAutoCommit()); this.setDefaultTransactionIsolation(bds.getDefaultTransactionIsolation()); this.setMaxWait(bds.getMaxWait()); this.setValidationQuery(bds.getValidationQuery()); this.setTimeBetweenEvictionRunsMillis(bds.getTimeBetweenEvictionRunsMillis()); this.setMinEvictableIdleTimeMillis(bds.getMinEvictableIdleTimeMillis()); this.setNumTestsPerEvictionRun(bds.getNumTestsPerEvictionRun()); this.setTestOnBorrow(bds.getTestOnBorrow()); this.setTestOnReturn(bds.getTestOnReturn()); this.setTestWhileIdle(bds.getTestWhileIdle()); this.setRemoveAbandoned(bds.getRemoveAbandoned()); this.setRemoveAbandonedTimeout(bds.getRemoveAbandonedTimeout()); this.setPoolPreparedStatements(bds.isPoolPreparedStatements()); this.setMaxOpenPreparedStatements(bds.getMaxOpenPreparedStatements()); this.setLogAbandoned(bds.getLogAbandoned()); }