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.druid.benckmark.pool.Oracle_Case0.java

public void test_1() throws Exception {
    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);/*w  ww .  j  a  v  a2s  .  com*/
    dataSource.setMinIdle(minPoolSize);
    dataSource.setMaxIdle(maxPoolSize);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery(validationQuery);
    dataSource.setTestOnBorrow(true);

    for (int i = 0; i < LOOP_COUNT; ++i) {
        p0(dataSource, "dbcp");
    }
    System.out.println();
}

---

From source file:com.mirth.connect.connectors.jdbc.JdbcConnector.java

private void setupDataSource(String address, String driver, String username, String password) {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(driver);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);
    basicDataSource.setUrl(address);/*from   ww  w.  j a va  2s. c o  m*/
    dataSource = basicDataSource;
}

---

From source file:com.headstrong.fusion.services.dbpool.impl.DbPool.java

/**
 * package level constructor to create new dbpool instance.
 * //from  w  w  w .  j  a  v a  2 s  .  c om
 * @param props
 *            properties that needs to be set for creating the pool.
 * @throws FusionException
 *             Error initializing dbpool
 */
/* package */ DbPool(Map<String, String> props, String dbcp) throws FusionException {
    BasicDataSource basicDataSource = new BasicDataSource();
    if (dbProps == null) {
        dbProps = new HashMap<String, String>(props);

    }
    if (checkMandatoryProperties(props)) {

        basicDataSource.setDriverClassName(props.get(FusionConstants.DATABASE_CLASSNAME));
        basicDataSource.setUsername(props.get(FusionConstants.DATABASE_USERNAME));
        basicDataSource.setPassword(props.get(FusionConstants.DATABASE_PASSWORD));
        basicDataSource.setUrl(props.get(FusionConstants.DATABASE_URL));

        basicDataSource.setMinEvictableIdleTimeMillis(this.MINEVICTABLEIDLETIMEMILLIS);
        basicDataSource.setTimeBetweenEvictionRunsMillis(this.TIMEBETWEENEVICTIONRUNSMILLIS);

        String JDBCINITIALSIZE = props.get(FusionConstants.JDBCINITIALSIZE) != null
                ? props.get(FusionConstants.JDBCINITIALSIZE)
                : dbProps.get(FusionConstants.JDBCINITIALSIZE);
        basicDataSource.setInitialSize(Integer.parseInt(JDBCINITIALSIZE));

        String JDBCMAXACTIVE = props.get(FusionConstants.JDBCMAXACTIVE) != null
                ? props.get(FusionConstants.JDBCMAXACTIVE)
                : dbProps.get(FusionConstants.JDBCMAXACTIVE);
        basicDataSource.setMaxActive(Integer.parseInt(JDBCMAXACTIVE));

        String JDBCMAXOPENACTIVEPREP = props.get(FusionConstants.JDBCMAXOPENACTIVEPREP) != null
                ? props.get(FusionConstants.JDBCMAXOPENACTIVEPREP)
                : dbProps.get(FusionConstants.JDBCMAXOPENACTIVEPREP);
        basicDataSource.setMaxOpenPreparedStatements(Integer.parseInt(JDBCMAXOPENACTIVEPREP));

        String MINEVICTABLEIDLETIMEMILLIS = props.get(FusionConstants.MINEVICTABLEIDLETIMEMILLIS) != null
                ? props.get(FusionConstants.MINEVICTABLEIDLETIMEMILLIS)
                : dbProps.get(FusionConstants.MINEVICTABLEIDLETIMEMILLIS);
        basicDataSource.setMinEvictableIdleTimeMillis(Integer.parseInt(MINEVICTABLEIDLETIMEMILLIS));

        String TIMEBETWEENEVICTIONRUNSMILLIS = props.get(FusionConstants.TIMEBETWEENEVICTIONRUNSMILLIS) != null
                ? props.get(FusionConstants.TIMEBETWEENEVICTIONRUNSMILLIS)
                : dbProps.get(FusionConstants.TIMEBETWEENEVICTIONRUNSMILLIS);
        basicDataSource.setTimeBetweenEvictionRunsMillis(Long.parseLong(TIMEBETWEENEVICTIONRUNSMILLIS));

        /*
         * if (props.get(FusionConstants.JDBCINITIALSIZE) == null) {
         * basicDataSource.setInitialSize(Integer.parseInt(dbProps
         * .get(FusionConstants.JDBCINITIALSIZE))); } else {
         * basicDataSource.setInitialSize(Integer.parseInt(props
         * .get(FusionConstants.JDBCINITIALSIZE))); } if
         * (props.get(FusionConstants.JDBCMAXACTIVE) == null) {
         * basicDataSource.setInitialSize(Integer.parseInt(dbProps
         * .get(FusionConstants.JDBCMAXACTIVE))); } else {
         * basicDataSource.setInitialSize(Integer.parseInt(props
         * .get(FusionConstants.JDBCMAXACTIVE))); } if
         * (props.get(FusionConstants.JDBCMAXOPENACTIVEPREP) == null) {
         * basicDataSource.setInitialSize(Integer.parseInt(dbProps
         * .get(FusionConstants.JDBCMAXOPENACTIVEPREP))); } else {
         * basicDataSource.setInitialSize(Integer.parseInt(props
         * .get(FusionConstants.JDBCMAXOPENACTIVEPREP))); }
         * 
         * if (props.get(FusionConstants.MINEVICTABLEIDLETIMEMILLIS) ==
         * null) { basicDataSource.setInitialSize(Integer.parseInt(dbProps
         * .get(FusionConstants.MINEVICTABLEIDLETIMEMILLIS))); } else {
         * basicDataSource.setInitialSize(Integer.parseInt(props
         * .get(FusionConstants.MINEVICTABLEIDLETIMEMILLIS))); } if
         * (props.get(FusionConstants.TIMEBETWEENEVICTIONRUNSMILLIS) ==
         * null) { basicDataSource.setInitialSize(Integer.parseInt(dbProps
         * .get(FusionConstants.TIMEBETWEENEVICTIONRUNSMILLIS))); } else {
         * basicDataSource.setInitialSize(Integer.parseInt(props
         * .get(FusionConstants.TIMEBETWEENEVICTIONRUNSMILLIS))); }
         */

        dataSource = basicDataSource;

    } else {
        throw new FusionException("Error initializing dbpool");
    }
}

---

From source file:com.manpowergroup.cn.icloud.util.Case1.java

public void test_1() throws Exception {
    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);/*from ww  w  .java  2  s.co  m*/
    dataSource.setMinIdle(minPoolSize);
    dataSource.setMaxIdle(maxPoolSize);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery("SELECT 1");
    dataSource.setTestOnBorrow(false);

    for (int i = 0; i < loopCount; ++i) {
        p0(dataSource, "dbcp", threadCount);
    }
    System.out.println();
}

---

From source file:com.thinkbiganalytics.nifi.v2.thrift.RefreshableDataSource.java

private DataSource create() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setDriverClassLoader(driverClassLoader);
    dataSource.setUrl(url);//ww  w.  ja  v a 2s. c  om
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    return dataSource;
}

---

From source file:com.alibaba.druid.benckmark.pool.Case2.java

public void test_1() throws Exception {
    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);/* w  w w  . ja va2  s.  com*/
    dataSource.setMinIdle(minPoolSize);
    dataSource.setMaxIdle(maxPoolSize);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery("SELECT 1");
    dataSource.setTestOnBorrow(testOnBorrow);

    for (int i = 0; i < executeCount; ++i) {
        p0(dataSource, "dbcp", threadCount);
    }
    System.out.println();
}

---

From source file:com.alibaba.druid.benckmark.pool.Oracle_Case4.java

public void test_dbcp() throws Exception {
    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setMaxActive(maxActive);// ww  w  .  j  a  v  a2 s  . co m
    dataSource.setMaxIdle(maxIdle);
    dataSource.setMaxWait(maxWait);
    dataSource.setPoolPreparedStatements(preparedStatementCache);
    dataSource.setMaxOpenPreparedStatements(preparedStatementCacheSize);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery(validationQuery);
    dataSource.setTestOnBorrow(testOnBorrow);
    dataSource.setConnectionProperties(properties);

    //        printAV_INFO(dataSource);

    for (int i = 0; i < loopCount; ++i) {
        p0(dataSource, "dbcp", threadCount);
    }
    System.out.println();
}

---

From source file:com.alibaba.druid.benckmark.pool.Case0.java

public void f_test_1() throws Exception {
    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);//from   w w  w . jav  a  2s .  c o m
    dataSource.setMinIdle(minIdle);
    dataSource.setMaxIdle(maxIdle);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery(validationQuery);
    dataSource.setTestOnBorrow(testOnBorrow);
    dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);

    for (int i = 0; i < LOOP_COUNT; ++i) {
        p0(dataSource, "dbcp");
    }
    System.out.println();
}

---

From source file:com.ritchey.naming.InitialContextFactory.java

/**
 * Create a databaseSource for a database by using properties that are
 * formed with the jndi name (e.g. database.myCoolDatabaseNumber1.url). url,
 * user, password and driver should all be defined.
 *
 * @param database is the jndi name of the database
 * @param properties represents the values of build.properties
 * @param jdbc is the context we're going to load
 * @throws NamingException//from w  ww  . jav a 2s .c  o m
 */
public void createDs(String database, Properties properties, Context jdbc) throws NamingException {
    org.apache.commons.dbcp.BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    try {
        jdbc.bind(database, ds);
    } catch (Exception e) {
        // Quietly suppress NameAlreadyBound Exception
    }

    Boolean isDatabase = true;
    ds.setDriverClassName(getValue(isDatabase, "driver", database, properties));
    ds.setUrl(getValue(isDatabase, "url", database, properties));
    ds.setUsername(getValue(isDatabase, "user", database, properties));
    ds.setPassword(getValue(isDatabase, "password", database, properties));
}

---

From source file:com.alibaba.druid.benckmark.pool.CaseKylin_mysql.java

public void dbcp() throws Exception {
    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);//www .j a  v  a  2  s.  c om
    dataSource.setMaxIdle(maxIdle);
    dataSource.setMinIdle(minIdle);
    dataSource.setMaxWait(maxWait);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery(validationQuery);
    dataSource.setTestOnBorrow(testOnBorrow);
    dataSource.setTestOnBorrow(testWhileIdle);
    dataSource.setTestOnBorrow(testOnReturn);
    dataSource.setRemoveAbandoned(removeAbandoned);
    dataSource.setRemoveAbandonedTimeout(removeAbandonedTimeout);
    dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
    dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
    dataSource.setNumTestsPerEvictionRun(numTestsPerEvictionRun);

    for (int i = 0; i < TEST_COUNT; ++i) {
        p0(dataSource, "dbcp", threadCount);
    }
    System.out.println();
}

---

• «
• 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
• »