org.apache.tomcat.dbcp.dbcp.BasicDataSource Java Examples

The following examples show how to use org.apache.tomcat.dbcp.dbcp.BasicDataSource. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example #1

Source File: TestJdbcWrapper.java From javamelody with Apache License 2.0

6 votes

/** Test.
 * @throws Exception e */
@Test
public void testRewrapDataSource() throws Exception {
	final BasicDataSource tomcatDataSource = new BasicDataSource();
	tomcatDataSource.setUrl(H2_DATABASE_URL);
	rewrapDataSource(tomcatDataSource);
	final org.apache.commons.dbcp.BasicDataSource dbcpDataSource = new org.apache.commons.dbcp.BasicDataSource();
	dbcpDataSource.setUrl(H2_DATABASE_URL);
	rewrapDataSource(dbcpDataSource);
	final org.apache.tomcat.dbcp.dbcp2.BasicDataSource tomcat2DataSource = new org.apache.tomcat.dbcp.dbcp2.BasicDataSource();
	tomcat2DataSource.setUrl(H2_DATABASE_URL);
	rewrapDataSource(tomcat2DataSource);
	final org.apache.commons.dbcp2.BasicDataSource dbcp2DataSource = new org.apache.commons.dbcp2.BasicDataSource();
	dbcp2DataSource.setUrl(H2_DATABASE_URL);
	rewrapDataSource(dbcp2DataSource);
	final DataSource dataSource = createNiceMock(DataSource.class);
	rewrapDataSource(dataSource);
}

Example #2

Source File: JdbcWrapperHelper.java From javamelody with Apache License 2.0

6 votes

static void pullDataSourceProperties(String name, DataSource dataSource) {
	// CHECKSTYLE:ON
	final String dataSourceClassName = dataSource.getClass().getName();
	if ("org.apache.tomcat.dbcp.dbcp.BasicDataSource".equals(dataSourceClassName)
			&& dataSource instanceof BasicDataSource) {
		pullTomcatDbcpDataSourceProperties(name, dataSource);
	} else if ("org.apache.tomcat.dbcp.dbcp2.BasicDataSource".equals(dataSourceClassName)
			&& dataSource instanceof org.apache.tomcat.dbcp.dbcp2.BasicDataSource) {
		pullTomcatDbcp2DataSourceProperties(name, dataSource);
	} else if ("org.apache.commons.dbcp.BasicDataSource".equals(dataSourceClassName)
			&& dataSource instanceof org.apache.commons.dbcp.BasicDataSource) {
		pullCommonsDbcpDataSourceProperties(name, dataSource);
	} else if ("org.apache.commons.dbcp2.BasicDataSource".equals(dataSourceClassName)
			&& dataSource instanceof org.apache.commons.dbcp2.BasicDataSource) {
		pullCommonsDbcp2DataSourceProperties(name, dataSource);
	} else if ("org.apache.tomcat.jdbc.pool.DataSource".equals(dataSourceClassName)
			&& dataSource instanceof org.apache.tomcat.jdbc.pool.DataSource) {
		pullTomcatJdbcDataSourceProperties(name, dataSource);
	}
}

Example #3

Source File: DataSourceFactory.java From Oceanus with Apache License 2.0

5 votes

@Override
public Object create(DataNodeConfig config) {
	if (config.getId() == null) {
		return null;
	}
	BasicDataSource dataSource = new BasicDataSource();
	dataSource.setMinEvictableIdleTimeMillis(1000 * 60 * 10);
	dataSource.setNumTestsPerEvictionRun(5);
	dataSource.setRemoveAbandoned(true);
	dataSource.setRemoveAbandonedTimeout(10);
	dataSource.setTimeBetweenEvictionRunsMillis(1000 * 60 * 5);
	dataSource.setTestOnBorrow(false);
	dataSource.setTestOnReturn(false);
	dataSource.setTestWhileIdle(true);
	dataSource.setValidationQuery("SELECT 1");
	
	Map<String, String> properties=getProperties(config);
	if(logger.isDebugEnabled()){
		logger.debug("datanode id=["+config.getId()+"] properties="+properties);
	}
	for (Map.Entry<String, String> entry :properties .entrySet()) {
		try {
			BeanUtils.setProperty(dataSource,
					entry.getKey(), entry.getValue());
		} catch (Exception e) {
			logger.error("create DataSource error!", e);
		}

	}
	
	return dataSource;
}

Example #4

Source File: Cause3PersistenceConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #5

Source File: Cause2PersistenceConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #6

Source File: Cause1PersistenceConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #7

Source File: Cause1NonTransientConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #8

Source File: Cause4NonTransientConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #9

Source File: Cause5NonTransientConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #10

Source File: PersistenceConfig.java From tutorials with MIT License

5 votes

@Bean
public DataSource restDataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("jdbc.driverClassName")));
    dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc.url")));
    dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("jdbc.user")));
    dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("jdbc.pass")));

    return dataSource;
}

Example #11

Source File: DataSourceWrapper.java From Oceanus with Apache License 2.0

5 votes

public DataSourceWrapper(Properties properties){
	BasicDataSource dbcpDataSource = new BasicDataSource();
	for (Map.Entry<Object, Object> entry : properties .entrySet()) {
		try {
			BeanUtils.setProperty(dbcpDataSource,
					entry.getKey().toString(), entry.getValue().toString());
		} catch (Exception e) {
			e.printStackTrace();
		}

	}
	this.datasource = dbcpDataSource;
}

Example #12

Source File: JdbcWrapperHelper.java From javamelody with Apache License 2.0

5 votes

private static void pullCommonsDbcp2DataSourceProperties(String name, DataSource dataSource) {
	// si dbcp et si dataSource standard, alors on récupère des infos
	final org.apache.commons.dbcp2.BasicDataSource dbcp2DataSource = (org.apache.commons.dbcp2.BasicDataSource) dataSource;
	final BasicDataSourcesProperties properties = DBCP_BASIC_DATASOURCES_PROPERTIES;
	// basicDataSource.getNumActive() est en théorie égale à USED_CONNECTION_COUNT à un instant t,
	// numIdle + numActive est le nombre de connexions ouvertes dans la bdd pour ce serveur à un instant t

	// les propriétés généralement importantes en premier (se méfier aussi de testOnBorrow)
	properties.put(name, MAX_ACTIVE_PROPERTY_NAME, dbcp2DataSource.getMaxTotal());
	properties.put(name, "poolPreparedStatements", dbcp2DataSource.isPoolPreparedStatements());

	properties.put(name, "defaultCatalog", dbcp2DataSource.getDefaultCatalog());
	properties.put(name, "defaultAutoCommit", dbcp2DataSource.getDefaultAutoCommit());
	properties.put(name, "defaultReadOnly", dbcp2DataSource.getDefaultReadOnly());
	properties.put(name, "defaultTransactionIsolation",
			dbcp2DataSource.getDefaultTransactionIsolation());
	properties.put(name, "driverClassName", dbcp2DataSource.getDriverClassName());
	properties.put(name, "initialSize", dbcp2DataSource.getInitialSize());
	properties.put(name, "maxIdle", dbcp2DataSource.getMaxIdle());
	properties.put(name, "maxOpenPreparedStatements",
			dbcp2DataSource.getMaxOpenPreparedStatements());
	properties.put(name, "maxWait", dbcp2DataSource.getMaxWaitMillis());
	properties.put(name, "minEvictableIdleTimeMillis",
			dbcp2DataSource.getMinEvictableIdleTimeMillis());
	properties.put(name, "minIdle", dbcp2DataSource.getMinIdle());
	properties.put(name, "numTestsPerEvictionRun", dbcp2DataSource.getNumTestsPerEvictionRun());
	properties.put(name, "testOnBorrow", dbcp2DataSource.getTestOnBorrow());
	properties.put(name, "testOnReturn", dbcp2DataSource.getTestOnReturn());
	properties.put(name, "testWhileIdle", dbcp2DataSource.getTestWhileIdle());
	properties.put(name, "timeBetweenEvictionRunsMillis",
			dbcp2DataSource.getTimeBetweenEvictionRunsMillis());
	properties.put(name, "validationQuery", dbcp2DataSource.getValidationQuery());
}

Example #13

Source File: JdbcWrapperHelper.java From javamelody with Apache License 2.0

5 votes

private static void pullTomcatDbcp2DataSourceProperties(String name, DataSource dataSource) {
	// si tomcat et si dataSource standard, alors on récupère des infos
	final org.apache.tomcat.dbcp.dbcp2.BasicDataSource tomcatDbcp2DataSource = (org.apache.tomcat.dbcp.dbcp2.BasicDataSource) dataSource;
	final BasicDataSourcesProperties properties = TOMCAT_BASIC_DATASOURCES_PROPERTIES;
	// basicDataSource.getNumActive() est en théorie égale à USED_CONNECTION_COUNT à un instant t,
	// numIdle + numActive est le nombre de connexions ouvertes dans la bdd pour ce serveur à un instant t

	// les propriétés généralement importantes en premier (se méfier aussi de testOnBorrow)
	properties.put(name, MAX_ACTIVE_PROPERTY_NAME, tomcatDbcp2DataSource.getMaxTotal());
	properties.put(name, "poolPreparedStatements",
			tomcatDbcp2DataSource.isPoolPreparedStatements());

	properties.put(name, "defaultCatalog", tomcatDbcp2DataSource.getDefaultCatalog());
	properties.put(name, "defaultAutoCommit", tomcatDbcp2DataSource.getDefaultAutoCommit());
	properties.put(name, "defaultReadOnly", tomcatDbcp2DataSource.getDefaultReadOnly());
	properties.put(name, "defaultTransactionIsolation",
			tomcatDbcp2DataSource.getDefaultTransactionIsolation());
	properties.put(name, "driverClassName", tomcatDbcp2DataSource.getDriverClassName());
	properties.put(name, "initialSize", tomcatDbcp2DataSource.getInitialSize());
	properties.put(name, "maxIdle", tomcatDbcp2DataSource.getMaxIdle());
	properties.put(name, "maxOpenPreparedStatements",
			tomcatDbcp2DataSource.getMaxOpenPreparedStatements());
	properties.put(name, "maxWait", tomcatDbcp2DataSource.getMaxWaitMillis());
	properties.put(name, "minEvictableIdleTimeMillis",
			tomcatDbcp2DataSource.getMinEvictableIdleTimeMillis());
	properties.put(name, "minIdle", tomcatDbcp2DataSource.getMinIdle());
	properties.put(name, "numTestsPerEvictionRun",
			tomcatDbcp2DataSource.getNumTestsPerEvictionRun());
	properties.put(name, "testOnBorrow", tomcatDbcp2DataSource.getTestOnBorrow());
	properties.put(name, "testOnReturn", tomcatDbcp2DataSource.getTestOnReturn());
	properties.put(name, "testWhileIdle", tomcatDbcp2DataSource.getTestWhileIdle());
	properties.put(name, "timeBetweenEvictionRunsMillis",
			tomcatDbcp2DataSource.getTimeBetweenEvictionRunsMillis());
	properties.put(name, "validationQuery", tomcatDbcp2DataSource.getValidationQuery());
}

Example #14

Source File: JdbcWrapperHelper.java From javamelody with Apache License 2.0

5 votes

private static void pullCommonsDbcpDataSourceProperties(String name, DataSource dataSource) {
	// si dbcp et si dataSource standard, alors on récupère des infos
	final org.apache.commons.dbcp.BasicDataSource dbcpDataSource = (org.apache.commons.dbcp.BasicDataSource) dataSource;
	final BasicDataSourcesProperties properties = DBCP_BASIC_DATASOURCES_PROPERTIES;
	// basicDataSource.getNumActive() est en théorie égale à USED_CONNECTION_COUNT à un instant t,
	// numIdle + numActive est le nombre de connexions ouvertes dans la bdd pour ce serveur à un instant t

	// les propriétés généralement importantes en premier (se méfier aussi de testOnBorrow)
	properties.put(name, MAX_ACTIVE_PROPERTY_NAME, dbcpDataSource.getMaxActive());
	properties.put(name, "poolPreparedStatements", dbcpDataSource.isPoolPreparedStatements());

	properties.put(name, "defaultCatalog", dbcpDataSource.getDefaultCatalog());
	properties.put(name, "defaultAutoCommit", dbcpDataSource.getDefaultAutoCommit());
	properties.put(name, "defaultReadOnly", dbcpDataSource.getDefaultReadOnly());
	properties.put(name, "defaultTransactionIsolation",
			dbcpDataSource.getDefaultTransactionIsolation());
	properties.put(name, "driverClassName", dbcpDataSource.getDriverClassName());
	properties.put(name, "initialSize", dbcpDataSource.getInitialSize());
	properties.put(name, "maxIdle", dbcpDataSource.getMaxIdle());
	properties.put(name, "maxOpenPreparedStatements",
			dbcpDataSource.getMaxOpenPreparedStatements());
	properties.put(name, "maxWait", dbcpDataSource.getMaxWait());
	properties.put(name, "minEvictableIdleTimeMillis",
			dbcpDataSource.getMinEvictableIdleTimeMillis());
	properties.put(name, "minIdle", dbcpDataSource.getMinIdle());
	properties.put(name, "numTestsPerEvictionRun", dbcpDataSource.getNumTestsPerEvictionRun());
	properties.put(name, "testOnBorrow", dbcpDataSource.getTestOnBorrow());
	properties.put(name, "testOnReturn", dbcpDataSource.getTestOnReturn());
	properties.put(name, "testWhileIdle", dbcpDataSource.getTestWhileIdle());
	properties.put(name, "timeBetweenEvictionRunsMillis",
			dbcpDataSource.getTimeBetweenEvictionRunsMillis());
	properties.put(name, "validationQuery", dbcpDataSource.getValidationQuery());
}

Example #15

Source File: JdbcWrapperHelper.java From javamelody with Apache License 2.0

5 votes

private static void pullTomcatDbcpDataSourceProperties(String name, DataSource dataSource) {
	// si tomcat et si dataSource standard, alors on récupère des infos
	final BasicDataSource tomcatDbcpDataSource = (BasicDataSource) dataSource;
	final BasicDataSourcesProperties properties = TOMCAT_BASIC_DATASOURCES_PROPERTIES;
	// basicDataSource.getNumActive() est en théorie égale à USED_CONNECTION_COUNT à un instant t,
	// numIdle + numActive est le nombre de connexions ouvertes dans la bdd pour ce serveur à un instant t

	// les propriétés généralement importantes en premier (se méfier aussi de testOnBorrow)
	properties.put(name, MAX_ACTIVE_PROPERTY_NAME, tomcatDbcpDataSource.getMaxActive());
	properties.put(name, "poolPreparedStatements",
			tomcatDbcpDataSource.isPoolPreparedStatements());

	properties.put(name, "defaultCatalog", tomcatDbcpDataSource.getDefaultCatalog());
	properties.put(name, "defaultAutoCommit", tomcatDbcpDataSource.getDefaultAutoCommit());
	properties.put(name, "defaultReadOnly", tomcatDbcpDataSource.getDefaultReadOnly());
	properties.put(name, "defaultTransactionIsolation",
			tomcatDbcpDataSource.getDefaultTransactionIsolation());
	properties.put(name, "driverClassName", tomcatDbcpDataSource.getDriverClassName());
	properties.put(name, "initialSize", tomcatDbcpDataSource.getInitialSize());
	properties.put(name, "maxIdle", tomcatDbcpDataSource.getMaxIdle());
	properties.put(name, "maxOpenPreparedStatements",
			tomcatDbcpDataSource.getMaxOpenPreparedStatements());
	properties.put(name, "maxWait", tomcatDbcpDataSource.getMaxWait());
	properties.put(name, "minEvictableIdleTimeMillis",
			tomcatDbcpDataSource.getMinEvictableIdleTimeMillis());
	properties.put(name, "minIdle", tomcatDbcpDataSource.getMinIdle());
	properties.put(name, "numTestsPerEvictionRun",
			tomcatDbcpDataSource.getNumTestsPerEvictionRun());
	properties.put(name, "testOnBorrow", tomcatDbcpDataSource.getTestOnBorrow());
	properties.put(name, "testOnReturn", tomcatDbcpDataSource.getTestOnReturn());
	properties.put(name, "testWhileIdle", tomcatDbcpDataSource.getTestWhileIdle());
	properties.put(name, "timeBetweenEvictionRunsMillis",
			tomcatDbcpDataSource.getTimeBetweenEvictionRunsMillis());
	properties.put(name, "validationQuery", tomcatDbcpDataSource.getValidationQuery());
}

Example #16

Source File: TestJdbcWrapper.java From javamelody with Apache License 2.0

4 votes

/** Test.
 * @throws Exception e */
@Test
public void testCreateDataSourceProxy() throws Exception {
	// on fait le ménage au cas où TestMonitoringSpringInterceptor ait été exécuté juste avant
	cleanUp();

	assertTrue("getBasicDataSourceProperties0",
			JdbcWrapper.getBasicDataSourceProperties().isEmpty());
	assertEquals("getMaxConnectionCount0", -1, JdbcWrapper.getMaxConnectionCount());

	final org.apache.tomcat.jdbc.pool.DataSource tomcatJdbcDataSource = new org.apache.tomcat.jdbc.pool.DataSource();
	tomcatJdbcDataSource.setUrl(H2_DATABASE_URL);
	tomcatJdbcDataSource.setDriverClassName("org.h2.Driver");
	tomcatJdbcDataSource.setMaxActive(123);
	final DataSource tomcatJdbcProxy = jdbcWrapper.createDataSourceProxy("test2",
			tomcatJdbcDataSource);
	assertNotNull("createDataSourceProxy1", tomcatJdbcProxy);
	tomcatJdbcProxy.getConnection().close();
	assertFalse("getBasicDataSourceProperties1",
			JdbcWrapper.getBasicDataSourceProperties().isEmpty());
	assertEquals("getMaxConnectionCount1", 123, JdbcWrapper.getMaxConnectionCount());

	final org.apache.commons.dbcp.BasicDataSource dbcpDataSource = new org.apache.commons.dbcp.BasicDataSource();
	dbcpDataSource.setUrl(H2_DATABASE_URL);
	dbcpDataSource.setMaxActive(456);
	final DataSource dbcpProxy = jdbcWrapper.createDataSourceProxy(dbcpDataSource);
	assertNotNull("createDataSourceProxy2", dbcpProxy);
	assertFalse("getBasicDataSourceProperties2",
			JdbcWrapper.getBasicDataSourceProperties().isEmpty());
	assertEquals("getMaxConnectionCount2", 456, JdbcWrapper.getMaxConnectionCount());

	final BasicDataSource tomcatDataSource = new BasicDataSource();
	tomcatDataSource.setUrl(H2_DATABASE_URL);
	tomcatDataSource.setMaxActive(789);
	final DataSource tomcatProxy = jdbcWrapper.createDataSourceProxy("test", tomcatDataSource);
	assertNotNull("createDataSourceProxy3", tomcatProxy);
	assertNotNull("getLogWriter2", tomcatProxy.getLogWriter());
	tomcatProxy.getConnection().close();
	assertFalse("getBasicDataSourceProperties3",
			JdbcWrapper.getBasicDataSourceProperties().isEmpty());
	assertEquals("getMaxConnectionCount3", 789, JdbcWrapper.getMaxConnectionCount());

	final org.apache.commons.dbcp2.BasicDataSource dbcp2DataSource = new org.apache.commons.dbcp2.BasicDataSource();
	dbcp2DataSource.setUrl(H2_DATABASE_URL);
	dbcp2DataSource.setMaxTotal(456);
	final DataSource dbcp2Proxy = jdbcWrapper.createDataSourceProxy(dbcp2DataSource);
	assertNotNull("createDataSourceProxy2b", dbcp2Proxy);

	final org.apache.tomcat.dbcp.dbcp2.BasicDataSource tomcat2DataSource = new org.apache.tomcat.dbcp.dbcp2.BasicDataSource();
	tomcat2DataSource.setUrl(H2_DATABASE_URL);
	tomcat2DataSource.setMaxTotal(789);
	final DataSource tomcat2Proxy = jdbcWrapper.createDataSourceProxy("test",
			tomcat2DataSource);
	assertNotNull("createDataSourceProxy3b", tomcat2Proxy);

	final DataSource dataSource2 = new MyDataSource(tomcatDataSource);
	jdbcWrapper.createDataSourceProxy(dataSource2);
}

Example #17

Source File: TestJdbcWrapper.java From javamelody with Apache License 2.0

4 votes

MyDataSource(BasicDataSource tomcatDataSource) {
	this.tomcatDataSource = tomcatDataSource;
}