Example usage for org.apache.commons.dbcp BasicDataSource getUrl

List of usage examples for org.apache.commons.dbcp BasicDataSource getUrl

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbcp.*
  5. BasicDataSource
  6. getUrl

Introduction

In this page you can find the example usage for org.apache.commons.dbcp BasicDataSource getUrl.

Prototype

public synchronized String getUrl()

Source Link

Document

Returns the JDBC connection #url property.

Usage

From source file:com.hotinno.feedmonitor.batch.Main.java

public static void main(String[] args) throws Throwable {
    try {/*from w  ww .j a v a  2  s .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:gsn.storage.DataSources.java

public static BasicDataSource getDataSource(DBConnectionInfo dci) {
    BasicDataSource ds = null;
    try {//from  w w w.j a va 2 s  .co m
        ds = (BasicDataSource) GSNContext.getMainContext().lookup(Integer.toString(dci.hashCode()));
        if (ds == null) {
            ds = new BasicDataSource();
            ds.setDriverClassName(dci.getDriverClass());
            ds.setUsername(dci.getUserName());
            ds.setPassword(dci.getPassword());
            ds.setUrl(dci.getUrl());
            //ds.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
            //ds.setAccessToUnderlyingConnectionAllowed(true); 
            GSNContext.getMainContext().bind(Integer.toString(dci.hashCode()), ds);
            logger.warn("Created a DataSource to: " + ds.getUrl());
        }
    } catch (NamingException e) {
        logger.error(e.getMessage(), e);
    }
    return ds;
}

From source file:fr.cnes.sitools.datasource.jdbc.DataSourceMonitoringResource.java

/**
 * Trace informations for a sitoolsDataSource
 * /*from   w w  w .  j a v a  2 s  .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   w w  w.  ja v  a2s.  co  m*/
    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");
    }/* ww  w  . j  a  v  a  2  s .  c o  m*/
    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   ww w.  j a  va 2  s.c o  m
    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 {/*from  ww w  .ja  v  a 2 s. com*/
        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);
    }//  ww  w . ja va  2  s  .  com
    return dataSourceInfo;
}

From source file:org.apache.cayenne.configuration.server.DBCPDataSourceFactoryTest.java

@Test
public void testGetDataSource() throws Exception {

    String baseUrl = getClass().getPackage().getName().replace('.', '/');
    URL url = getClass().getClassLoader().getResource(baseUrl + "/");
    assertNotNull(url);/*  w ww  .  j  a va 2s . c  o m*/

    DataNodeDescriptor nodeDescriptor = new DataNodeDescriptor();
    nodeDescriptor.setConfigurationSource(new URLResource(url));
    nodeDescriptor.setParameters("testDBCP.properties");

    DBCPDataSourceFactory factory = new DBCPDataSourceFactory();
    DataSource dataSource = factory.getDataSource(nodeDescriptor);
    assertNotNull(dataSource);

    assertTrue(dataSource instanceof BasicDataSource);
    BasicDataSource basicDataSource = (BasicDataSource) dataSource;
    assertEquals("com.example.jdbc.Driver", basicDataSource.getDriverClassName());
    assertEquals("jdbc:somedb://localhost/cayenne", basicDataSource.getUrl());
    assertEquals("john", basicDataSource.getUsername());
    assertEquals("secret", basicDataSource.getPassword());
    assertEquals(20, basicDataSource.getMaxActive());
    assertEquals(5, basicDataSource.getMinIdle());
    assertEquals(8, basicDataSource.getMaxIdle());
    assertEquals(10000, basicDataSource.getMaxWait());
    assertEquals("select 1 from xyz;", basicDataSource.getValidationQuery());
}

From source file:org.apache.cayenne.configuration.server.DBCPDataSourceFactoryTest.java

@Test
public void testGetDataSource_LegacyConfig() throws Exception {

    String baseUrl = getClass().getPackage().getName().replace('.', '/');
    URL url = getClass().getClassLoader().getResource(baseUrl + "/");
    assertNotNull(url);/*from w w  w  .j av  a2 s .c  o m*/

    DataNodeDescriptor nodeDescriptor = new DataNodeDescriptor();
    nodeDescriptor.setConfigurationSource(new URLResource(url));
    nodeDescriptor.setParameters("testDBCP_legacy.properties");

    DBCPDataSourceFactory factory = new DBCPDataSourceFactory();
    DataSource dataSource = factory.getDataSource(nodeDescriptor);
    assertNotNull(dataSource);

    assertTrue(dataSource instanceof BasicDataSource);
    BasicDataSource basicDataSource = (BasicDataSource) dataSource;
    assertEquals("com.example.jdbc.Driver", basicDataSource.getDriverClassName());
    assertEquals("jdbc:somedb://localhost/cayenne", basicDataSource.getUrl());
    assertEquals("john", basicDataSource.getUsername());
    assertEquals("secret", basicDataSource.getPassword());
    assertEquals(20, basicDataSource.getMaxActive());
    assertEquals(5, basicDataSource.getMinIdle());
    assertEquals(8, basicDataSource.getMaxIdle());
    assertEquals(10000, basicDataSource.getMaxWait());
    assertEquals("select 1 from xyz;", basicDataSource.getValidationQuery());
}