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:pcconfigurator.ComponentManagerImplTest.java

private DataSource setDataSource() {
    BasicDataSource ds = new BasicDataSource();
    if (name != null && password != null && dbURL != null) {
        ds.setUrl(dbURL);/*from   w  w w .j  a v  a 2 s.  co m*/
        ds.setUsername(name);
        ds.setPassword(password);
    } else
        throw new InternalFailureException("cannot create DataSource, properties are empty");

    return ds;
}

---

From source file:pcconfigurator.ConfigurationManagerImplTest.java

private DataSource setDataSource() {
    BasicDataSource ds = new BasicDataSource();
    if (name != null && password != null && dbUrl != null) {
        ds.setUrl(dbUrl);/* w w w  .  j av a 2  s.  com*/
        ds.setUsername(name);
        ds.setPassword(password);
    } else
        throw new InternalFailureException("cannot create DataSource, properties are empty");

    return ds;
}

---

From source file:philaman.cput.cardealer.app.config.AppConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    ds.setUrl("jdbc:derby://localhost:1527/LimaCarDealers");
    ds.setUsername("app");
    ds.setPassword("app");
    return ds;/*from   w w w .j  a va 2s.  c om*/
}

---

From source file:qa.qcri.nadeef.core.util.sql.DBConnectionPool.java

/**
 * Create a connection pool./*from  w  w w  . j a  va  2 s  .  co m*/
 * @param dbconfig input DB config.
 * @return connection pool instance.
 */
public BasicDataSource createConnectionPool(DBConfig dbconfig) {
    tracer.verbose("Creating connection pool for " + dbconfig.getUrl());
    BasicDataSource result;
    result = new BasicDataSource();
    result.setUrl(dbconfig.getUrl());
    result.setDriverClassName(SQLDialectTools.getDriverName(dbconfig.getDialect()));

    String username = dbconfig.getUserName();
    if (!Strings.isNullOrEmpty(username)) {
        result.setUsername(username);
    }

    String password = dbconfig.getPassword();
    if (!Strings.isNullOrEmpty(password)) {
        result.setPassword(password);
    }

    result.setMaxActive(MAX_ACTIVE);
    result.setMaxIdle(MAX_ACTIVE * 3);
    result.setDefaultAutoCommit(false);
    return result;
}

---

From source file:qa.qcri.nadeef.core.utils.sql.DBConnectionPool.java

/**
 * Create a connection pool./*from w w w.j  av a2s.co m*/
 * @param dbconfig input DB config.
 * @return connection pool instance.
 */
public BasicDataSource createConnectionPool(DBConfig dbconfig) {
    tracer.fine("Creating connection pool for " + dbconfig.getUrl());
    BasicDataSource result;
    result = new BasicDataSource();
    result.setUrl(dbconfig.getUrl());
    result.setDriverClassName(SQLDialectTools.getDriverName(dbconfig.getDialect()));

    String username = dbconfig.getUserName();
    if (!Strings.isNullOrEmpty(username)) {
        result.setUsername(username);
    }

    String password = dbconfig.getPassword();
    if (!Strings.isNullOrEmpty(password)) {
        result.setPassword(password);
    }

    result.setMaxActive(MAX_ACTIVE);
    result.setMaxIdle(MAX_ACTIVE * 3);
    result.setDefaultAutoCommit(false);
    return result;
}

---

From source file:ro.zg.scriptdao.core.DbCommandTest.java

public void testDbCommand() throws Exception {
    DefaultCommandManager commandManager = new DefaultCommandManager("TestCommandManager");

    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName("com.mysql.jdbc.Driver");
    bds.setUrl("jdbc:mysql://127.0.0.1:3306/test");
    bds.setUsername("test");
    bds.setPassword("test");

    commandManager.setCommandLoader(new ClasspathCommandLoader(""));
    commandManager.setCommandExecutor(new DbCommandExecutor(bds));
    commandManager.setCommandBuilder(new VelocityCommandBuilder());
    commandManager.load();//from   w  w w. j av  a 2  s. com
    System.out.println(commandManager.getAvailableCommands().length);

    System.out.println("Found " + commandManager.getAvailableCommands().length + " commands.");

    System.out.println("Reloading..");
    commandManager.load();
    System.out.println("After reload " + commandManager.getAvailableCommands().length);

    //      Map args = new HashMap();
    //      args.put("message_id", "3");
    //      args.put("text", "Si mesaju trei... ce fac cu viata mea?");
    //      Object resp = commandManager.executeCommand("InsertIntoMessages", args);
    //      System.out.println(resp);

    //      Map args = new HashMap();
    //      args.put("message_id", 1);
    //      args.put("service","PREPAID.EO310");
    //      args.put("exit_point", "Success");
    //      args.put("input_channel", "SMS");
    //      args.put("output_channel", "SMS");
    //      args.put("order_idx", 1);
    //      args.put("start_date", "2008-04-20");
    //      args.put("end_date", "2008-06-01");
    //      Object resp = commandManager.executeCommand("InsertIntoServicesMessages", args);
    //      System.out.println(resp);

    Map args = new HashMap();
    args.put("service", "PREPAID.EO310");
    args.put("exit_point", "Success");
    args.put("input_channel", "SMS");
    Object resp = commandManager.executeCommand("GetMessagesForService", args);
    System.out.println(resp);
}

---

From source file:se.unlogic.hierarchy.core.utils.DBCPUtils.java

public static BasicDataSource createConnectionPool(DataSourceDescriptor dataSourceDescriptor) {

    BasicDataSource basicDataSource = new BasicDataSource();

    basicDataSource.setDriverClassName(dataSourceDescriptor.getDriver());
    basicDataSource.setUsername(dataSourceDescriptor.getUsername());
    basicDataSource.setPassword(dataSourceDescriptor.getPassword());
    basicDataSource.setUrl(dataSourceDescriptor.getUrl());
    basicDataSource.setDefaultCatalog(dataSourceDescriptor.getDefaultCatalog());
    basicDataSource.setLogAbandoned(dataSourceDescriptor.logAbandoned());
    basicDataSource.setRemoveAbandoned(dataSourceDescriptor.removeAbandoned());

    if (dataSourceDescriptor.getRemoveTimeout() != null) {
        basicDataSource.setRemoveAbandonedTimeout(dataSourceDescriptor.getRemoveTimeout());
    }//from   w w  w  .j a v a  2 s  . co m

    basicDataSource.setTestOnBorrow(dataSourceDescriptor.testOnBorrow());
    basicDataSource.setValidationQuery(dataSourceDescriptor.getValidationQuery());
    basicDataSource.setMaxWait(dataSourceDescriptor.getMaxWait());
    basicDataSource.setMaxActive(dataSourceDescriptor.getMaxActive());
    basicDataSource.setMaxIdle(dataSourceDescriptor.getMaxIdle());
    basicDataSource.setMinIdle(dataSourceDescriptor.getMinIdle());

    return basicDataSource;
}

---

From source file:sistema.Conexion.java

private void inicializaDataSource() {

    BasicDataSource basicDataSource = new BasicDataSource();

    basicDataSource.setDriverClassName("org.gjt.mm.mysql.Driver");
    basicDataSource.setUsername(login);
    basicDataSource.setPassword(pass);/*from w  w w .  j av  a2s  . co m*/
    basicDataSource.setUrl(url);
    basicDataSource.setMaxActive(50);

    dataSource = basicDataSource;

}

---

From source file:skoa.helpers.ConfiguracionGraficas.java

private void inicializaDataSource() {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUsername(user);
    basicDataSource.setPassword(pass);/*from www . j  av a  2  s.  c  o m*/
    basicDataSource.setUrl(url);
    basicDataSource.setMaxActive(4);
    // Opcional. Sentencia SQL que sirve a BasicDataSource para comprobar que la conexion es correcta.
    basicDataSource.setValidationQuery("select 1");
    dataSource = basicDataSource;
}

---

From source file:test.com.agiletec.ConfigTestUtils.java

private void createDatasource(String dsNameControlKey, SimpleNamingContextBuilder builder,
        Properties testConfig) {/*w  ww . ja  v a  2 s  . co  m*/
    String beanName = testConfig.getProperty("jdbc." + dsNameControlKey + ".beanName");
    try {
        String className = testConfig.getProperty("jdbc." + dsNameControlKey + ".driverClassName");
        String url = testConfig.getProperty("jdbc." + dsNameControlKey + ".url");
        String username = testConfig.getProperty("jdbc." + dsNameControlKey + ".username");
        String password = testConfig.getProperty("jdbc." + dsNameControlKey + ".password");
        Class.forName(className);
        BasicDataSource ds = new BasicDataSource();
        ds.setUrl(url);
        ds.setUsername(username);
        ds.setPassword(password);
        ds.setMaxActive(8);
        ds.setMaxIdle(4);
        builder.bind("java:comp/env/jdbc/" + beanName, ds);
    } catch (Throwable t) {
        throw new RuntimeException("Error on creation datasource '" + beanName + "'", t);
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• »