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

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

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

Introduction

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

Prototype

public synchronized String getPassword()

Source Link

Document

Returns the password passed to the JDBC driver to establish connections.

Usage

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

public static void main(String[] args) throws Throwable {
    try {/*from  ww w  .j  a v  a 2 s.c om*/
        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:com.funambol.server.db.DataSourceContextHelperTest.java

public void testconfigureAndBindDataSources() throws Throwable {
    DataSourceContextHelper.configureAndBindDataSources();

    BasicDataSource dsFnblds = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblds");
    assertNotNull(dsFnblds);//from   w  ww  . java 2  s . 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: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());
}

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);/*from  w  w  w  .  j  ava  2 s  .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  ww  w  . j a v a  2 s .c  om

    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());
}

From source file:org.apache.ddlutils.task.CreateDatabaseCommand.java

/**
 * {@inheritDoc}//  w  w w  .j  a  v a 2s .co m
 */
public void execute(DatabaseTaskBase task, Database model) throws BuildException {
    BasicDataSource dataSource = getDataSource();

    if (dataSource == null) {
        throw new BuildException("No database specified.");
    }

    Platform platform = getPlatform();

    try {
        platform.createDatabase(dataSource.getDriverClassName(), dataSource.getUrl(), dataSource.getUsername(),
                dataSource.getPassword(), getFilteredParameters(platform.getName()));

        _log.info("Created database");
    } catch (UnsupportedOperationException ex) {
        _log.error("Database platform " + platform.getName() + " does not support database creation "
                + "via JDBC or there was an error while creating it.", ex);
    } catch (Exception ex) {
        handleException(ex, ex.getMessage());
    }
}

From source file:org.apache.ddlutils.task.DropDatabaseCommand.java

/**
 * {@inheritDoc}/* w ww .  jav a 2 s  . co  m*/
 */
public void execute(DatabaseTaskBase task, Database model) throws BuildException {
    BasicDataSource dataSource = getDataSource();

    if (dataSource == null) {
        throw new BuildException("No database specified.");
    }

    Platform platform = getPlatform();

    try {
        platform.dropDatabase(dataSource.getDriverClassName(), dataSource.getUrl(), dataSource.getUsername(),
                dataSource.getPassword());

        _log.info("Dropped database");
    } catch (UnsupportedOperationException ex) {
        _log.error("Database platform " + platform.getName() + " does not support database dropping via JDBC",
                ex);
    } catch (Exception ex) {
        handleException(ex, ex.getMessage());
    }
}

From source file:org.apache.kylin.query.QueryDataSourceTest.java

@Test
public void testCreateDataSourceWithProps() {
    KylinConfig config = KylinConfig.getInstanceFromEnv();
    Properties props = new Properties();
    props.setProperty("username", "ADMIN");
    props.setProperty("password", "KYLIN");
    BasicDataSource ds = (BasicDataSource) QueryDataSource.create("default", config, props);

    Assert.assertNotNull(ds);//from  w ww  .  j  a  va 2  s .c  om
    Assert.assertTrue(ds instanceof BasicDataSource);
    Assert.assertTrue(ds.getUrl().startsWith("jdbc:calcite:model="));
    Assert.assertEquals(ds.getDriverClassName(), Driver.class.getName());
    Assert.assertEquals(ds.getUsername(), "ADMIN");
    Assert.assertEquals(ds.getPassword(), "KYLIN");
}

From source file:org.apache.openejb.assembler.classic.DataSourceDefinitionPlaceHolderTest.java

private void check(final DataSource ds) throws NoSuchFieldException, IllegalAccessException {
    assertNotNull(ds);// w ww.  ja v a  2  s. co m
    assertThat(ds, instanceOf(BasicDataSource.class));

    final BasicDataSource bds = (BasicDataSource) ds;
    assertEquals("sa", bds.getUsername());
    assertEquals("", bds.getPassword());

    final Field fieldDs = bds.getClass().getDeclaredField("ds");
    fieldDs.setAccessible(true);
    final JDBCDataSource realDs = (JDBCDataSource) fieldDs.get(bds);
    assertEquals("jdbc:hsqldb:mem:superDS", realDs.getUrl());
    assertEquals("sa", realDs.getUser());
}

From source file:org.apache.openejb.assembler.classic.OpenEJBXmlByModuleTest.java

@Test
public void test() throws Exception {
    assertNotNull(bean.datasource());//from  ww  w . j a va2s. c  o m
    assertTrue(bean.datasource() instanceof BasicDataSource);
    final BasicDataSource ds = (BasicDataSource) bean.datasource();
    assertEquals("org.hsqldb.jdbcDriver", ds.getDriverClassName());
    assertEquals("not:used:url", ds.getUrl());
    assertEquals("foo", ds.getUsername());
    assertEquals("bar", ds.getPassword());

    assertNotNull(bean.resource());
    assertEquals("ok", bean.resource().attr);
}