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

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

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

Introduction

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

Prototype

BasicDataSource

Source Link

Usage

From source file:org.karsha.lucene.jdbc.JDBCDatabaseUtil.java

/**
 * Gets the data source./*  w w  w. ja  v  a 2  s.  com*/
 * 
 * @return the data source
 */
public synchronized static DataSource getDataSource() {

    // String url = "jdbc:mysql://rss1.stratoslive.wso2.com/karsha_annotate_karsha_opensource_lk";
    //            String username = "adm_ann_lQrhzZUK";
    //           String password = "admin@lsf";
    //MysqlDataSource dataSource = new MysqlDataSource();
    BasicDataSource dataSource = new BasicDataSource();
    //                dataSource.setUser("adm_ann_lQrhzZUK");             
    //      dataSource.setPassword("admin@lsf");
    //      dataSource.setUrl("jdbc:mysql://rss1.stratoslive.wso2.com/karsha_annotate_karsha_opensource_lk");

    dataSource.setUsername("admin_i+APQovg");
    dataSource.setPassword("admin");

    //emulateLocators=true&useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
    dataSource.setUrl(
            "jdbc:mysql://rss1.stratoslive.wso2.com/karshaindex_kasunperera_com?emulateLocators=true&useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false");

    //                dataSource.setUsername("root");                
    //      dataSource.setPassword("nbuser");
    //                dataSource.setUrl("jdbc:mysql://localhost:3306/karshaindex?emulateLocators=true&useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false");
    // dataSource.setEmulateLocators(true);
    return dataSource;
}

From source file:org.kiy0taka.dbunit.DbUnitRunner.java

protected DataSource createDataSource() {
    BasicDataSource result = new BasicDataSource();
    result.setUsername(username);/*from   w  ww . j  a va  2s  . c  o  m*/
    result.setPassword(password);
    result.setUrl(jdbcUrl);
    return result;
}

From source file:org.kuali.rice.krad.data.jpa.eclipselink.KradEclipseLinkEntityManagerFactoryBeanTest.java

/**
 * Verifies that it's not permitted to configure with both a JTA and Non-JTA datasource.
 *///  w  w w  .j  ava  2s.c  o  m
@Test(expected = IllegalStateException.class)
public void testInvalidDataSourceConfiguration() throws Exception {
    // kind of a random addition to throw the superclass in here, but allows me to get some
    // coverage on some of the other methods from the superclass without having to write a separate test
    KradEntityManagerFactoryBean factoryBean = new KradEntityManagerFactoryBean();
    factoryBean.setDataSource(new BasicDataSource());
    factoryBean.setJtaDataSource(new BasicDataSource());
    factoryBean.afterPropertiesSet();
}

From source file:org.kuali.rice.krad.data.jpa.eclipselink.KradEclipseLinkEntityManagerFactoryBeanTest.java

@Test
public void testGetDataSource() throws Exception {
    KradEclipseLinkEntityManagerFactoryBean factoryBean = new KradEclipseLinkEntityManagerFactoryBean();

    BasicDataSource dataSourceNonJta = new BasicDataSource();
    factoryBean.setDataSource(dataSourceNonJta);
    assertEquals(dataSourceNonJta, factoryBean.getDataSource());

    BasicDataSource dataSourceJta = new BasicDataSource();
    factoryBean.setJtaDataSource(dataSourceJta);
    assertEquals(dataSourceJta, factoryBean.getDataSource());
}

From source file:org.lucane.server.database.DatabaseAbstractionLayer.java

/**
 * DatabaseLayer Factory/*from ww w. j  a  v a 2s  .c o m*/
 * Get the layer corresponding to the driver
 */
public static DatabaseAbstractionLayer createLayer(ServerConfig config) throws Exception {
    Class.forName(config.getDbDriver());

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(config.getDbDriver());
    ds.setUsername(config.getDbLogin());
    ds.setPassword(config.getDbPassword());
    ds.setUrl(config.getDbUrl());

    ds.setPoolPreparedStatements(true);
    ds.setInitialSize(config.getDbPoolInitialSize());
    ds.setMaxActive(config.getDbPoolMaxActive());
    ds.setMaxIdle(config.getDbPoolMaxIdle());
    ds.setMinIdle(config.getDbPoolMinIdle());
    ds.setMaxWait(config.getDbPoolMaxWait());

    Logging.getLogger()
            .info("Pool initialized (" + "initial size=" + config.getDbPoolInitialSize() + ", max active="
                    + config.getDbPoolMaxActive() + ", max idle=" + config.getDbPoolMaxIdle() + ", min idle="
                    + config.getDbPoolMinIdle() + ", max wait=" + config.getDbPoolMaxWait() + ")");

    //-- dynamic layer loading
    Class klass = Class.forName(config.getDbLayer());
    Class[] types = { DataSource.class };
    Object[] values = { ds };
    Constructor constr = klass.getConstructor(types);
    return (DatabaseAbstractionLayer) constr.newInstance(values);
}

From source file:org.midao.jdbc.core.pool.MjdbcPoolBinder.java

/**
 * Returns new Pooled {@link DataSource} implementation
 *
 * In case this function won't work - use {@link #createDataSource(java.util.Properties)}
 *
 * @param url Database connection url/*from  w  w  w.ja v  a2s  .  c o  m*/
 * @return new Pooled {@link DataSource} implementation
 * @throws SQLException
 */
public static DataSource createDataSource(String url) throws SQLException {
    assertNotNull(url);

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(url);

    return ds;
}

From source file:org.midao.jdbc.core.pool.MjdbcPoolBinder.java

/**
 * Returns new Pooled {@link DataSource} implementation
 *
 * In case this function won't work - use {@link #createDataSource(java.util.Properties)}
 *
 * @param url Database connection url//  w  ww .  j  av a 2  s.com
 * @param userName Database user name
 * @param password Database user password
 * @return new Pooled {@link DataSource} implementation
 * @throws SQLException
 */
public static DataSource createDataSource(String url, String userName, String password) throws SQLException {
    assertNotNull(url);
    assertNotNull(userName);
    assertNotNull(password);

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(url);
    ds.setUsername(userName);
    ds.setPassword(password);

    return ds;
}

From source file:org.midao.jdbc.core.pool.MjdbcPoolBinder.java

/**
 * Returns new Pooled {@link DataSource} implementation
 *
 * In case this function won't work - use {@link #createDataSource(java.util.Properties)}
 *
 * @param driverClassName Driver Class name
 * @param url Database connection url/*from   www. ja  v a  2  s  .  co  m*/
 * @param userName Database user name
 * @param password Database user password
 * @param initialSize initial pool size
 * @param maxActive max connection active
 * @return new Pooled {@link DataSource} implementation
 * @throws SQLException
 */
public static DataSource createDataSource(String driverClassName, String url, String userName, String password,
        int initialSize, int maxActive) throws SQLException {
    assertNotNull(driverClassName);
    assertNotNull(url);
    assertNotNull(userName);
    assertNotNull(password);

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driverClassName);
    ds.setUrl(url);
    ds.setUsername(userName);
    ds.setPassword(password);

    ds.setMaxActive(maxActive);
    ds.setInitialSize(initialSize);

    return ds;
}

From source file:org.mskcc.cbio.cgds.dao.JdbcUtil.java

/**
 * Initializes Data Source./* w w w  .  j  a  v a2  s.  c  om*/
 */
private static void initDataSource() {
    DatabaseProperties dbProperties = DatabaseProperties.getInstance();
    String host = dbProperties.getDbHost();
    String userName = dbProperties.getDbUser();
    String password = dbProperties.getDbPassword();
    String database = dbProperties.getDbName();

    String url = new String("jdbc:mysql://" + host + "/" + database + "?user=" + userName + "&password="
            + password + "&zeroDateTimeBehavior=convertToNull");

    //  Set up poolable data source
    ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername(userName);
    ds.setPassword(password);
    ds.setUrl(url);

    //  By pooling/reusing PreparedStatements, we get a major performance gain
    ds.setPoolPreparedStatements(true);
    ds.setMaxActive(MAX_JDBC_CONNECTIONS);

    activeConnectionCount = new HashMap<String, Integer>();
}

From source file:org.mskcc.cbio.dbcache.DatabaseUtil.java

/**
 * Initializes DB via the BasicDataSource instance.
 *//* ww w.  ja v a 2  s  . c  om*/
public static void initDataSource() {
    DatabaseProperties dbProperties = new DatabaseProperties("db.properties");

    String host = dbProperties.getDbHost();
    String userName = dbProperties.getDbUser();
    String password = dbProperties.getDbPassword();
    String database = dbProperties.getDbName();
    String driver = "com.mysql.jdbc.Driver";

    String url = new String("jdbc:mysql://" + host + "/" + database + "?user=" + userName + "&password="
            + password + "&zeroDateTimeBehavior=convertToNull");

    //  Set up poolable data source
    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(userName);
    ds.setPassword(password);
    ds.setUrl(url);

    //  By pooling/reusing PreparedStatements, we get a major performance gain
    ds.setPoolPreparedStatements(true);
    ds.setMaxActive(75);
}