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

Introduction

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

Prototype

public synchronized void setPassword(String password)

Source Link

Document

Sets the #password .

Note: this method currently has no effect once the pool has been initialized.

Usage

From source file:io.syndesis.connector.sql.stored.SqlStoredConnectorComponentTest.java

@Test
public void camelConnectorTest() throws Exception {

    BasicDataSource ds = new BasicDataSource();
    ds.setUsername(properties.getProperty("sql-stored-connector.user"));
    ds.setPassword(properties.getProperty("sql-stored-connector.password"));
    ds.setUrl(properties.getProperty("sql-stored-connector.url"));

    SimpleRegistry registry = new SimpleRegistry();
    registry.put("dataSource", ds);
    CamelContext context = new DefaultCamelContext(registry);

    String jsonBody = "{\"a\":20,\"b\":30}";
    CountDownLatch latch = new CountDownLatch(1);

    final Result result = new Result();

    try {/*from   w w w .  j a va2 s  .  com*/
        context.addRoutes(new RouteBuilder() {
            @Override
            public void configure() throws Exception {
                from("timer://myTimer?period=2000").setBody().constant(jsonBody).to(
                        "sql-stored-connector:DEMO_ADD( INTEGER ${body[a]}, INTEGER ${body[b]}, OUT INTEGER c)")
                        .process(new Processor() {
                            @Override
                            public void process(Exchange exchange) throws Exception {
                                String jsonBean = (String) exchange.getIn().getBody();
                                result.setResult(jsonBean);
                                latch.countDown();
                            }
                        });
            }
        });
        context.start();
        latch.await(5l, TimeUnit.SECONDS);
        Assert.assertEquals("{\"c\":50}", result.getJsonBean());
    } finally {
        context.stop();
    }
}

From source file:io.syndesis.connector.sql.stored.SqlStoredStartConnectorComponentTest.java

@Test
public void camelConnectorTest() throws Exception {

    BasicDataSource ds = new BasicDataSource();
    ds.setUsername(properties.getProperty("sql-stored-start-connector.user"));
    ds.setPassword(properties.getProperty("sql-stored-start-connector.password"));
    ds.setUrl(properties.getProperty("sql-stored-start-connector.url"));

    SimpleRegistry registry = new SimpleRegistry();
    registry.put("dataSource", ds);
    CamelContext context = new DefaultCamelContext(registry);

    CountDownLatch latch = new CountDownLatch(1);

    final Result result = new Result();

    try {/*from w w w.j  ava2s. c  om*/
        context.addRoutes(new RouteBuilder() {
            @Override
            public void configure() throws Exception {
                from("sql-stored-start-connector:DEMO_OUT( OUT INTEGER c)").process(new Processor() {
                    @Override
                    public void process(Exchange exchange) throws Exception {
                        String jsonBean = (String) exchange.getIn().getBody();
                        result.setResult(jsonBean);
                        latch.countDown();
                    }
                }).to("stream:out");
            }
        });
        context.start();
        latch.await(5l, TimeUnit.SECONDS);
        Assert.assertEquals("{\"c\":60}", result.getJsonBean());
    } finally {
        context.stop();
    }
}

From source file:com.gantzgulch.sharing.configuration.DataSourceContextTest.java

@Bean(name = "sharingDS")
public DataSource sharingDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUrl("jdbc:hsqldb:mem:sharing_db");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}

From source file:app.Mysqlconector.java

public DataSource Connection() {
    if (DataSource == null) {
        BasicDataSource basicDataSource = new BasicDataSource();
        basicDataSource.setDriverClassName(mysql);
        basicDataSource.setUrl(Url);/*from  w ww. j av  a 2s.  c  o  m*/
        basicDataSource.setUsername(User);
        basicDataSource.setPassword(Pass);
        basicDataSource.setMaxActive(50);
        DataSource = basicDataSource;
    }
    return DataSource;
    //  return conexion;
}

From source file:com.open.license.config.ContextConfig.java

@Bean
public DataSource dataSource() {
    log.info("[START:Set DataSource]");
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(DATASOURCE_URL);
    basicDataSource.setUsername(DATABASE_USERNAME);
    basicDataSource.setPassword(DATABASE_PASSWORD);
    log.info("[END:Set DataSource]");
    return basicDataSource;

}

From source file:com.mycompany.geocoordinate.config.DataConfig.java

@Bean
public DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/Mybatis");
    dataSource.setUsername("root");
    dataSource.setPassword("");

    return dataSource;

}

From source file:database.DataSourceBase.java

public DataSource initDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driver);/*ww w.ja v a2 s .  c  o  m*/
    ds.setUsername(username);
    ds.setPassword(password);
    ds.setUrl(url);
    ds.setMaxActive(maxActive);

    datasource = ds;
    return ds;
}

From source file:com.abixen.platform.module.configuration.PlatformModuleDataSourceConfiguration.java

@Profile("dev")
@Bean(destroyMethod = "close")
public DataSource devDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(databaseUrl);// w w  w  .  ja  v a  2 s  .c  o m
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    return dataSource;
}

From source file:com.abixen.platform.module.configuration.PlatformModuleDataSourceConfiguration.java

@Profile("cloud")
@Bean(destroyMethod = "close")
public DataSource cloudDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(databaseUrl);//from   w  w  w  . j ava2s. co  m
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    return dataSource;
}

From source file:com.abixen.platform.module.configuration.PlatformModuleDataSourceConfiguration.java

@Profile("test")
@Bean(destroyMethod = "close")
public DataSource testDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(databaseUrl);/*from  w w w .j a  va 2 s  . co  m*/
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    // DatabasePopulatorUtils.execute(databasePopulator(), dataSource);
    return dataSource;
}