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

Introduction

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

Prototype

public synchronized void setUsername(String username)

Source Link

Document

Sets the #username .

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

Usage

From source file:com.alibaba.cobar.manager.dao.delegate.DataSourceCreator.java

@Override
public DataSource createDataSource(String ip, int port, String user, String password) {
    BasicDataSource ds = new BasicDataSource();
    ds.setUsername(user);
    ds.setPassword(password);/*  www.j a  v  a  2s.  c o  m*/
    ds.setUrl(new StringBuilder().append("jdbc:mysql://").append(ip).append(":").append(port).append("/")
            .toString());
    ds.setDriverClassName(driverClassName);
    ds.setMaxActive(maxActive);
    ds.setMinIdle(minIdle);
    ds.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
    ds.setNumTestsPerEvictionRun(numTestsPerEvictionRun);
    ds.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
    return ds;
}

From source file:general.conexion.Pool.java

public void inicializarDataSource() {
    BasicDataSource basic = new BasicDataSource();
    basic.setDriverClassName(driver);//from  w w  w  . j  a  va  2  s  .co  m
    basic.setUsername(usuario);
    basic.setPassword(contrasena);
    basic.setUrl(url);
    basic.setMaxActive(5);
    this.dataSource = basic;
}

From source file:edu.infsci2560.DatabaseConfig.java

@Bean
public BasicDataSource dataSource() throws URISyntaxException {
    URI dbUri = new URI(System.getenv("DATABASE_URL"));

    String username = dbUri.getUserInfo().split(":")[0];
    String password = dbUri.getUserInfo().split(":")[1];
    String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath()
            + "?sslmode=require";

    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(dbUrl);//from  w  w  w.  ja  v a2  s .co m
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);

    return basicDataSource;
}

From source file:com.kerjapraktek.dataalumni.SpringConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:hsqldb:mem:test");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}

From source file:com.surveypanel.form.config.LoadConfigTest.java

public void testRbs() {

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.h2.Driver");
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setUrl("jdbc:h2:mem:surveypanel");

    JDBCFormDAO jdbcFormDAO = new JDBCFormDAO();
    jdbcFormDAO.setDataSource(ds);/*from   ww w  .j  ava  2  s  .  c  o  m*/

    RDBSFormFactory formFactory = new RDBSFormFactory("/form/", jdbcFormDAO);
    formFactory.init(0);
    Form form = formFactory.create(0, false);
    System.out.println(form.getId());
    JSManager jsManager = new JSManager(formFactory);
    Result execute = (Result) jsManager.execute(form, "flow.next();save();");

    System.out.println(form.getId());

    formFactory.load(form.getId(), 0, false);

    System.out.println(execute.getLogs());
    System.out.println(execute.getError());
    assertFalse(execute.hasError());
}

From source file:de.dominikschadow.javasecurity.spring.SecurityConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:hsqldb:mem:hashing");
    dataSource.setUsername("hashing");
    dataSource.setPassword("hashing");
    return dataSource;
}

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 {/*w  w w. j ava2s . co  m*/
        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:Metodos.Pool.java

private void inicializaDataSource() {

    BasicDataSource basicDataSource = new BasicDataSource();

    //basicDataSource.setDriverClassName("org.gjt.mm.mysql.Driver");
    basicDataSource.setUsername(user);
    basicDataSource.setPassword(pass);//from   www  .j av  a 2 s  .c  o  m
    basicDataSource.setUrl(url);
    basicDataSource.setMaxActive(50);

    dataSource = basicDataSource;

}

From source file:com.bt.aloha.sipstone.MaintenanceDao.java

public MaintenanceDao(String driver, String url, String uname, String pwd) {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driver);/* w w  w.  j  av a2  s  .c om*/
    ds.setUrl(url);
    ds.setUsername(uname);
    ds.setPassword(pwd);
    this.jdbcTemplate = new JdbcTemplate(ds);
    testConnection();
}

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  v a  2s.c om*/
        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();
    }
}