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

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

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

Introduction

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

Prototype

public synchronized String getDriverClassName()

Source Link

Document

Returns the jdbc driver class name.

Usage

From source file:com.qut.middleware.esoemanager.DynamicSqlMapClientFactoryBean.java

public DynamicSqlMapClientFactoryBean(BasicDataSource dataSource, OracleLobHandler oracleLobHandler,
        DefaultLobHandler defaultLobHandler) {
    if (dataSource == null)
        throw new IllegalArgumentException("Invalid data source");

    if (oracleLobHandler == null)
        throw new IllegalArgumentException("Invalid oracleLobHandler");

    if (defaultLobHandler == null)
        throw new IllegalArgumentException("Invalid defaultLobHandler");

    if (dataSource.getDriverClassName().contains("oracle")) {
        this.logger.info("Setting database LOB handler to ORACLE");
        setDataSource(dataSource);/*from   w ww .ja  v a 2s. c  o  m*/
        setLobHandler(oracleLobHandler);
        return;
    }

    this.logger.info("Setting database LOB handler to DEFAULT");
    setDataSource(dataSource);
    setLobHandler(defaultLobHandler);
    return;
}

From source file:com.qut.middleware.esoe.sessions.data.ResourceLoaderSqlMapClientFactoryBean.java

public ResourceLoaderSqlMapClientFactoryBean(BasicDataSource dataSource, OracleLobHandler oracleLobHandler,
        DefaultLobHandler defaultLobHandler) {
    if (dataSource == null)
        throw new IllegalArgumentException("Invalid data source");

    if (oracleLobHandler == null)
        throw new IllegalArgumentException("Invalid oracleLobHandler");

    if (defaultLobHandler == null)
        throw new IllegalArgumentException("Invalid defaultLobHandler");

    if (dataSource.getDriverClassName().contains("oracle")) {
        setDataSource(dataSource);//ww  w  .j  a  v  a  2 s.  c o  m
        setLobHandler(oracleLobHandler);
        return;
    }

    setDataSource(dataSource);
    setLobHandler(defaultLobHandler);
    return;
}

From source file:com.funambol.server.db.DataSourceContextHelperTest.java

public void testconfigureAndBindDataSources() throws Throwable {
    DataSourceContextHelper.configureAndBindDataSources();

    BasicDataSource dsFnblds = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblds");
    assertNotNull(dsFnblds);//from w  w w .  ja  v  a2  s  .  c o  m
    assertEquals("jdbc:hsqldb:hsql://localhost/funambol", dsFnblds.getUrl());
    assertEquals("db", dsFnblds.getUsername());
    assertEquals("", dsFnblds.getPassword());
    assertEquals("org.hsqldb.jdbcDriver", dsFnblds.getDriverClassName());

    BasicDataSource dsCore = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblcore");
    assertNotNull(dsCore);
    assertEquals("jdbc:hsqldb:hsql://localhost/funambol", dsCore.getUrl());
    assertEquals("db", dsCore.getUsername());
    assertEquals("ss", dsCore.getPassword());
    assertEquals("org.hsqldb.jdbcDriver", dsCore.getDriverClassName());

    BasicDataSource dsUser = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnbluser");
    assertNotNull(dsUser);
    assertEquals("jdbc:hsqldb:hsql://localhost/user", dsUser.getUrl());
    assertEquals("fnbluserpwd", dsUser.getUsername());
    assertEquals("fnblpwd", dsUser.getPassword());
    assertEquals("org.fnbluser", dsUser.getDriverClassName());

    //
    // This test is to verify that the case (lower or upper) of the configuration 
    // file is taken in consideration
    //
    boolean found = true;
    BasicDataSource dsUserds2 = null;
    try {
        dsUserds2 = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/fnblUSER");
    } catch (NameNotFoundException e) {
        found = false;
    }

    assertFalse(found);

    BasicDataSource dsUPPER = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/UPPERCASE");
    assertNotNull(dsUPPER);
    assertEquals("jdbc:hsqldb:hsql://localhost/user", dsUPPER.getUrl());
    assertEquals("fnbluserpwd", dsUPPER.getUsername());
    assertEquals("fnblpwd", dsUPPER.getPassword());
    assertEquals("org.fnbluser", dsUPPER.getDriverClassName());
    //
    // This test is to verify that the case of the configuration file is taken
    // in consideration
    //
    found = true;
    BasicDataSource dsUPPER2 = null;
    try {
        dsUPPER2 = (BasicDataSource) DataSourceTools.lookupDataSource("jdbc/uppercase");
    } catch (NameNotFoundException e) {
        found = false;
    }
    assertFalse(found);

    RoutingDataSource routingDS = (RoutingDataSource) DataSourceTools
            .lookupDataSource("jdbc/fnbluser-routing-with-partition");
    routingDS.init();
    routingDS.configure();

    assertNotNull(routingDS);
    assertTrue(routingDS.getPartitioningCriteria() instanceof MockPartitioningCriteria);

    Map<String, DataSource> dataSources = (Map<String, DataSource>) PrivateAccessor.getField(routingDS,
            "dataSources");
    assertTrue(dataSources.size() == 3);

    org.apache.tomcat.dbcp.dbcp.BasicDataSource ds1 = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) dataSources
            .get("user_part1");

    assertNotNull("user_part1 must be not null", ds1);
    assertEquals("sa", ds1.getUsername());
    assertEquals("", ds1.getPassword());
    assertEquals("jdbc:hsqldb:mem:user_part1", ds1.getUrl());
    assertEquals(15, ds1.getNumTestsPerEvictionRun()); // from db.xml

    org.apache.tomcat.dbcp.dbcp.BasicDataSource ds2 = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) dataSources
            .get("user_part2");

    assertNotNull("user_part2 must be not null", ds2);
    assertEquals("sa", ds2.getUsername());
    assertEquals("", ds2.getPassword());
    assertEquals("jdbc:hsqldb:mem:user_part2", ds2.getUrl());
    assertEquals(15, ds2.getNumTestsPerEvictionRun()); // from db.xml

    org.apache.tomcat.dbcp.dbcp.BasicDataSource ds3 = (org.apache.tomcat.dbcp.dbcp.BasicDataSource) dataSources
            .get("user_part3");

    assertNotNull("user_part3 must be not null", ds3);
    assertEquals("sa", ds3.getUsername());
    assertEquals("", ds3.getPassword());
    assertEquals("jdbc:hsqldb:mem:user_part3", ds3.getUrl());
    assertEquals(15, ds3.getNumTestsPerEvictionRun()); // from db.xml

}

From source file:net.risesoft.soa.asf.web.controller.SystemController.java

private List<SysInfo> getDBInfo() {
    List list = new ArrayList();
    String group = "4. ??";
    try {//from ww w  .j a v  a  2s  .  co  m
        Connection conn = this.basicDataSource.getConnection();
        try {
            DatabaseMetaData dbmd = conn.getMetaData();
            list.add(new SysInfo("DatabaseProductName", dbmd.getDatabaseProductName(), group));
            list.add(new SysInfo("DatabaseProductVersion", dbmd.getDatabaseProductVersion(), group));
            list.add(new SysInfo("DatabaseMajorVersion", Integer.valueOf(dbmd.getDatabaseMajorVersion()),
                    group));
            list.add(new SysInfo("DatabaseMinorVersion", Integer.valueOf(dbmd.getDatabaseMinorVersion()),
                    group));
            list.add(new SysInfo("DriverName", dbmd.getDriverName(), group));
            list.add(new SysInfo("DriverVersion", dbmd.getDriverVersion(), group));
            list.add(new SysInfo("DriverMajorVersion", Integer.valueOf(dbmd.getDriverMajorVersion()), group));
            list.add(new SysInfo("DriverMinorVersion", Integer.valueOf(dbmd.getDriverMinorVersion()), group));
        } finally {
            conn.close();
        }
        group = "5. ?";
        BasicDataSource bds = this.basicDataSource;
        list.add(new SysInfo("InitialSize", Integer.valueOf(bds.getInitialSize()), group));
        list.add(new SysInfo("MaxActive", Integer.valueOf(bds.getMaxActive()), group));
        list.add(new SysInfo("MaxIdle", Integer.valueOf(bds.getMaxIdle()), group));
        list.add(new SysInfo("MinIdle", Integer.valueOf(bds.getMinIdle()), group));
        list.add(new SysInfo("MaxWait", Long.valueOf(bds.getMaxWait()), group));
        list.add(new SysInfo("NumActive", Integer.valueOf(bds.getNumActive()), group));
        list.add(new SysInfo("NumIdle", Integer.valueOf(bds.getNumIdle()), group));
        list.add(new SysInfo("DriverClass", bds.getDriverClassName(), group));
        list.add(new SysInfo("URL", bds.getUrl(), group));
        list.add(new SysInfo("Username", bds.getUsername(), group));
        list.add(new SysInfo("Password", "******", group));
    } catch (Exception ex) {
        log.warn("???: " + ex.getMessage(), ex);
    }
    return list;
}

From source file:org.alfresco.repo.tenant.TenantBasicDataSource.java

public TenantBasicDataSource(BasicDataSource bds, String tenantUrl, int tenantMaxActive) throws SQLException {
    // tenant-specific
    this.setUrl(tenantUrl);
    this.setMaxActive(tenantMaxActive == -1 ? bds.getMaxActive() : tenantMaxActive);

    // defaults/overrides - see also 'baseDefaultDataSource' (core-services-context.xml + repository.properties)

    this.setDriverClassName(bds.getDriverClassName());
    this.setUsername(bds.getUsername());
    this.setPassword(bds.getPassword());

    this.setInitialSize(bds.getInitialSize());
    this.setMinIdle(bds.getMinIdle());
    this.setMaxIdle(bds.getMaxIdle());
    this.setDefaultAutoCommit(bds.getDefaultAutoCommit());
    this.setDefaultTransactionIsolation(bds.getDefaultTransactionIsolation());
    this.setMaxWait(bds.getMaxWait());
    this.setValidationQuery(bds.getValidationQuery());
    this.setTimeBetweenEvictionRunsMillis(bds.getTimeBetweenEvictionRunsMillis());
    this.setMinEvictableIdleTimeMillis(bds.getMinEvictableIdleTimeMillis());
    this.setNumTestsPerEvictionRun(bds.getNumTestsPerEvictionRun());
    this.setTestOnBorrow(bds.getTestOnBorrow());
    this.setTestOnReturn(bds.getTestOnReturn());
    this.setTestWhileIdle(bds.getTestWhileIdle());
    this.setRemoveAbandoned(bds.getRemoveAbandoned());
    this.setRemoveAbandonedTimeout(bds.getRemoveAbandonedTimeout());
    this.setPoolPreparedStatements(bds.isPoolPreparedStatements());
    this.setMaxOpenPreparedStatements(bds.getMaxOpenPreparedStatements());
    this.setLogAbandoned(bds.getLogAbandoned());
}

From source file:org.apache.cayenne.configuration.server.DBCPDataSourceFactoryTest.java

@Test
public void testGetDataSource() throws Exception {

    String baseUrl = getClass().getPackage().getName().replace('.', '/');
    URL url = getClass().getClassLoader().getResource(baseUrl + "/");
    assertNotNull(url);/*from  ww  w .  java  2s  .  c  o m*/

    DataNodeDescriptor nodeDescriptor = new DataNodeDescriptor();
    nodeDescriptor.setConfigurationSource(new URLResource(url));
    nodeDescriptor.setParameters("testDBCP.properties");

    DBCPDataSourceFactory factory = new DBCPDataSourceFactory();
    DataSource dataSource = factory.getDataSource(nodeDescriptor);
    assertNotNull(dataSource);

    assertTrue(dataSource instanceof BasicDataSource);
    BasicDataSource basicDataSource = (BasicDataSource) dataSource;
    assertEquals("com.example.jdbc.Driver", basicDataSource.getDriverClassName());
    assertEquals("jdbc:somedb://localhost/cayenne", basicDataSource.getUrl());
    assertEquals("john", basicDataSource.getUsername());
    assertEquals("secret", basicDataSource.getPassword());
    assertEquals(20, basicDataSource.getMaxActive());
    assertEquals(5, basicDataSource.getMinIdle());
    assertEquals(8, basicDataSource.getMaxIdle());
    assertEquals(10000, basicDataSource.getMaxWait());
    assertEquals("select 1 from xyz;", basicDataSource.getValidationQuery());
}

From source file:org.apache.cayenne.configuration.server.DBCPDataSourceFactoryTest.java

@Test
public void testGetDataSource_LegacyConfig() throws Exception {

    String baseUrl = getClass().getPackage().getName().replace('.', '/');
    URL url = getClass().getClassLoader().getResource(baseUrl + "/");
    assertNotNull(url);/* w  w  w.j av a 2 s. c o m*/

    DataNodeDescriptor nodeDescriptor = new DataNodeDescriptor();
    nodeDescriptor.setConfigurationSource(new URLResource(url));
    nodeDescriptor.setParameters("testDBCP_legacy.properties");

    DBCPDataSourceFactory factory = new DBCPDataSourceFactory();
    DataSource dataSource = factory.getDataSource(nodeDescriptor);
    assertNotNull(dataSource);

    assertTrue(dataSource instanceof BasicDataSource);
    BasicDataSource basicDataSource = (BasicDataSource) dataSource;
    assertEquals("com.example.jdbc.Driver", basicDataSource.getDriverClassName());
    assertEquals("jdbc:somedb://localhost/cayenne", basicDataSource.getUrl());
    assertEquals("john", basicDataSource.getUsername());
    assertEquals("secret", basicDataSource.getPassword());
    assertEquals(20, basicDataSource.getMaxActive());
    assertEquals(5, basicDataSource.getMinIdle());
    assertEquals(8, basicDataSource.getMaxIdle());
    assertEquals(10000, basicDataSource.getMaxWait());
    assertEquals("select 1 from xyz;", basicDataSource.getValidationQuery());
}

From source file:org.apache.ddlutils.task.CreateDatabaseCommand.java

/**
 * {@inheritDoc}//w  w w  .  j av a  2 s.c o m
 */
public void execute(DatabaseTaskBase task, Database model) throws BuildException {
    BasicDataSource dataSource = getDataSource();

    if (dataSource == null) {
        throw new BuildException("No database specified.");
    }

    Platform platform = getPlatform();

    try {
        platform.createDatabase(dataSource.getDriverClassName(), dataSource.getUrl(), dataSource.getUsername(),
                dataSource.getPassword(), getFilteredParameters(platform.getName()));

        _log.info("Created database");
    } catch (UnsupportedOperationException ex) {
        _log.error("Database platform " + platform.getName() + " does not support database creation "
                + "via JDBC or there was an error while creating it.", ex);
    } catch (Exception ex) {
        handleException(ex, ex.getMessage());
    }
}

From source file:org.apache.ddlutils.task.DropDatabaseCommand.java

/**
 * {@inheritDoc}/*  w w  w .  j a  v a  2  s. c  om*/
 */
public void execute(DatabaseTaskBase task, Database model) throws BuildException {
    BasicDataSource dataSource = getDataSource();

    if (dataSource == null) {
        throw new BuildException("No database specified.");
    }

    Platform platform = getPlatform();

    try {
        platform.dropDatabase(dataSource.getDriverClassName(), dataSource.getUrl(), dataSource.getUsername(),
                dataSource.getPassword());

        _log.info("Dropped database");
    } catch (UnsupportedOperationException ex) {
        _log.error("Database platform " + platform.getName() + " does not support database dropping via JDBC",
                ex);
    } catch (Exception ex) {
        handleException(ex, ex.getMessage());
    }
}

From source file:org.apache.kylin.query.QueryDataSourceTest.java

@Test
public void testCreateDataSourceWithProps() {
    KylinConfig config = KylinConfig.getInstanceFromEnv();
    Properties props = new Properties();
    props.setProperty("username", "ADMIN");
    props.setProperty("password", "KYLIN");
    BasicDataSource ds = (BasicDataSource) QueryDataSource.create("default", config, props);

    Assert.assertNotNull(ds);//from   ww  w  .  j a va2  s.  c  o  m
    Assert.assertTrue(ds instanceof BasicDataSource);
    Assert.assertTrue(ds.getUrl().startsWith("jdbc:calcite:model="));
    Assert.assertEquals(ds.getDriverClassName(), Driver.class.getName());
    Assert.assertEquals(ds.getUsername(), "ADMIN");
    Assert.assertEquals(ds.getPassword(), "KYLIN");
}