Java PoolingDataSource类代码示例

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Override
public DataSource createDataSource(IsolationLevel isolationLevel, Class<?> qualifier,
        Consumer<Closeable> closeableRegistrar) {
    Properties props = new Properties();
    initializeProperties(props);

    PoolingDataSource btmDataSource = new PoolingDataSource();
    btmDataSource.setUniqueName((qualifier == null ? "" : qualifier.getSimpleName()) + "_" + isolationLevel.name());
    btmDataSource.setClassName(databaseIntegrationInfo.getDataSourceClass().getName());
    btmDataSource.setIsolationLevel(isolationLevel.name());
    btmDataSource.setDriverProperties(props);
    btmDataSource.setShareTransactionConnections(true);
    btmDataSource.setMaxPoolSize(10);
    btmDataSource.setAllowLocalTransactions(true);
    btmDataSource.setMinPoolSize(1);
    customizeDataSource(btmDataSource);

    closeableRegistrar.accept(btmDataSource::close);
    return new P6DataSource(btmDataSource);
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Override
public DataSource actualDataSource() {
    final PoolingDataSource poolingDataSource = (PoolingDataSource) super.actualDataSource();
    com.vladmihalcea.flexypool.config.Configuration<PoolingDataSource> configuration = new com.vladmihalcea.flexypool.config.Configuration.Builder<>(
        getClass().getSimpleName(), poolingDataSource, BitronixPoolAdapter.FACTORY).build();

    FlexyPoolDataSource<PoolingDataSource> flexyPoolDataSource = new FlexyPoolDataSource<PoolingDataSource>(configuration) {
        @Override
        public void start() {
            poolingDataSource.init();
            super.start();
        }

        @Override
        public void stop() {
            super.stop();
            poolingDataSource.close();
        }
    };
    return flexyPoolDataSource;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Bean
public Configuration<PoolingDataSource> configuration() {
    return new Configuration.Builder<PoolingDataSource>(
            uniqueId,
            poolingDataSource,
            BitronixPoolAdapter.FACTORY
    )
    .setMetricsFactory(MetricsFactoryResolver.INSTANCE.resolve())
    .setConnectionProxyFactory(ConnectionDecoratorFactoryResolver.INSTANCE.resolve())
    .setMetricLogReporterMillis(TimeUnit.SECONDS.toMillis(5))
    .setJmxEnabled(true)
    .setJmxAutoStart(true)
    .setConnectionAcquireTimeThresholdMillis(50L)
    .setConnectionLeaseTimeThresholdMillis(250L)
    .setEventListenerResolver(new EventListenerResolver() {
        @Override
        public List<EventListener<? extends Event>> resolveListeners() {
            return Arrays.<EventListener<? extends Event>>asList(
                new ConnectionAcquireTimeoutEventListener(),
                new ConnectionAcquireTimeThresholdExceededEventListener(),
                new ConnectionLeaseTimeThresholdExceededEventListener()
            );
        }
    })
    .build();
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
/**
 * This method does all of the setup for the test and returns a HashMap
 * containing the persistence objects that the test might need.
 * 
 * @param persistenceUnitName
 *            The name of the persistence unit used by the test.
 * @return HashMap<String Object> with persistence objects, such as the
 *         EntityManagerFactory and DataSource
 */
public static HashMap<String, Object> setupWithPoolingDataSource(final String persistenceUnitName, String dataSourceName, final boolean testMarshalling) {
    HashMap<String, Object> context = new HashMap<String, Object>();

    // set the right jdbc url
    Properties dsProps = getDatasourceProperties();
    String jdbcUrl = dsProps.getProperty("url");
    String driverClass = dsProps.getProperty("driverClassName");

    // Setup the datasource
    PoolingDataSource ds1 = setupPoolingDataSource(dsProps, dataSourceName);
    if( driverClass.startsWith("org.h2") ) { 
        jdbcUrl += "tcp://localhost/target/drools-persistence-test";
        ds1.getDriverProperties().setProperty("url", jdbcUrl);
    }
    ds1.init();
    context.put(DATASOURCE, ds1);

    // Setup persistence
    EntityManagerFactory emf = Persistence.createEntityManagerFactory(persistenceUnitName);
    context.put(ENTITY_MANAGER_FACTORY, emf);

    return context;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
private static PoolingDataSource setupJdbcDataSource(String url,
		String userName, String password) {
	log.debug("setting up JdbcDataSource url [" + url + "] username ["
			+ userName + "] password ["
			+ StringUtils.repeat("*", password.length()) + "]");
	PoolingDataSource jdbcDataSource = new PoolingDataSource();
	jdbcDataSource.setClassName("oracle.jdbc.xa.client.OracleXADataSource");
	jdbcDataSource.setUniqueName("oracle");
	jdbcDataSource.setMaxPoolSize(5);
	jdbcDataSource.setAllowLocalTransactions(true);
	// jdbcDataSource.setTestQuery("SELECT 1 FROM DUAL");
	jdbcDataSource.getDriverProperties().setProperty("user", userName);
	jdbcDataSource.getDriverProperties().setProperty("password", password);
	jdbcDataSource.getDriverProperties().setProperty("URL", url);
	jdbcDataSource.init();
	return jdbcDataSource;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Bean(initMethod = "init", destroyMethod = "close")
public PoolingDataSource batchMetaDataDataSource() {
	PoolingDataSource ds = new PoolingDataSource();

	ds.setClassName(org.hsqldb.jdbc.pool.JDBCXADataSource.class.getName());
	ds.setUniqueName("batchdb");
	ds.setMaxPoolSize(100);

	Properties props = new Properties();
	props.setProperty("databaseName", "spring-batch-metadata");
	// props.setProperty("createDatabase", "create");
	ds.setDriverProperties(props);

	ds.setAllowLocalTransactions(true);

	final ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
	populator.addScript(batchDropSchemaScript);
	populator.addScript(batchCreateSchemaScript);
	DatabasePopulatorUtils.execute(populator, ds);

	return ds;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Bean(initMethod = "init", destroyMethod = "close")
public PoolingDataSource applicationDataSource() {
	PoolingDataSource ds = new PoolingDataSource();

	ds.setClassName(org.hsqldb.jdbc.pool.JDBCXADataSource.class.getName());
	ds.setUniqueName("appdb");
	ds.setMaxPoolSize(100);

	final Properties props = new Properties();
	props.setProperty("databaseName", "chapter09-application");
	// props.setProperty("createDatabase", "create");
	ds.setDriverProperties(props);

	ds.setAllowLocalTransactions(true);

	final ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
	populator.addScript(dropTablesScript);
	populator.addScript(createTableScript);
	DatabasePopulatorUtils.execute(populator, ds);

	return ds;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Override
protected void setUp() throws Exception {
    TransactionManagerServices.getConfiguration().setJournal("null").setGracefulShutdownInterval(2);
    TransactionManagerServices.getTransactionManager();

    MockitoXADataSource.setStaticCloseXAConnectionException(null);
    MockitoXADataSource.setStaticGetXAConnectionException(null);

    pds = new PoolingDataSource();
    pds.setMinPoolSize(1);
    pds.setMaxPoolSize(2);
    pds.setMaxIdleTime(1);
    pds.setClassName(MockitoXADataSource.class.getName());
    pds.setUniqueName("pds");
    pds.setAllowLocalTransactions(true);
    pds.setAcquisitionTimeout(1);
    pds.init();
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
public void testDefaultUserTransactionAndResources() throws Exception {
    PoolingDataSource pds = new PoolingDataSource();
    pds.setMaxPoolSize(1);
    pds.setClassName(MockitoXADataSource.class.getName());
    pds.setUniqueName("jdbc/pds");
    pds.init();

    Hashtable<String, String> env = new Hashtable<String, String>();
    env.put(Context.INITIAL_CONTEXT_FACTORY, BitronixInitialContextFactory.class.getName());
    Context ctx = new InitialContext(env);

    assertTrue(transactionManager == ctx.lookup("java:comp/UserTransaction"));

    try {
        ctx.lookup("aaa");
        fail("expected NameNotFoundException");
    } catch (NameNotFoundException ex) {
        assertEquals("unable to find a bound object at name 'aaa'", ex.getMessage());
    }

    assertTrue(pds == ctx.lookup("jdbc/pds"));

    ctx.close();

    pds.close();
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
public void testFormatErrors() throws Exception {
    ResourceLoader loader = new ResourceLoader();

    Properties p = new Properties();
    p.setProperty("resource.ds2.className", MockitoXADataSource.class.getName());
    p.setProperty("resource.ds2.uniqueName", "some.more.unique.Name");
    p.setProperty("resource.ds2.maxPoolSize", "abc"); // incorrect format

    try {
        loader.initXAResourceProducers(p);
        fail("expected ResourceConfigurationException");
    } catch (ResourceConfigurationException ex) {
        assertEquals("cannot configure resource for configuration entries with name [ds2] - failing property is [maxPoolSize]", ex.getMessage());
    }

    p.setProperty("resource.ds2.className", MockitoXADataSource.class.getName());
    p.setProperty("resource.ds2.uniqueName", "some.also.other.unique.Name");
    p.setProperty("resource.ds2.maxPoolSize", "123");
    p.setProperty("resource.ds2.useTmJoin", "unknown"); // incorrect format, will default to false
    loader.initXAResourceProducers(p);


    PoolingDataSource pds = (PoolingDataSource) loader.getResources().get("some.also.other.unique.Name");
    assertFalse(pds.getUseTmJoin());
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
public void testAcquiringConnectionAfterRecoveryDoesNotMarkAsFailed() throws Exception {
    PoolingDataSource poolingDataSource = new PoolingDataSource();
    poolingDataSource.setClassName(MockitoXADataSource.class.getName());
    poolingDataSource.setUniqueName("ds1");
    poolingDataSource.setMaxPoolSize(1);
    poolingDataSource.setMaxIdleTime(1); // set low shrink timeout
    poolingDataSource.init();

    IncrementalRecoverer.recover(poolingDataSource);

    MockitoXADataSource.setStaticGetXAConnectionException(new SQLException("creating a new connection does not work"));
    Thread.sleep(2000); // wait for shrink

    // should not work but should not mark the pool as failed as it could recover
    try {
        poolingDataSource.getConnection();
        fail("expected SQLException");
    } catch (SQLException ex) {
        assertEquals("unable to get a connection from pool of a PoolingDataSource containing an XAPool of resource ds1 with 0 connection(s) (0 still available)", ex.getMessage());
    }

    poolingDataSource.close();
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
public void testFailingRecoveryMarksAsFailed() throws Exception {
    MockitoXADataSource.setStaticGetXAConnectionException(new SQLException("creating a new connection does not work"));

    PoolingDataSource poolingDataSource = new PoolingDataSource();
    poolingDataSource.setClassName(MockitoXADataSource.class.getName());
    poolingDataSource.setUniqueName("ds1");
    poolingDataSource.setMaxPoolSize(1);
    poolingDataSource.init();

    Recoverer recoverer = new Recoverer();
    recoverer.run();
    assertEquals("a PoolingDataSource containing an XAPool of resource ds1 with 0 connection(s) (0 still available) -failed-", poolingDataSource.toString());
    // recoverer must not unregister the resource
    assertSame(poolingDataSource, ResourceRegistrar.get("ds1"));

    MockitoXADataSource.setStaticGetXAConnectionException(null);

    recoverer.run();
    assertEquals("a PoolingDataSource containing an XAPool of resource ds1 with 1 connection(s) (1 still available)", poolingDataSource.toString());
    // recoverer must not unregister the resource
    assertSame(poolingDataSource, ResourceRegistrar.get("ds1"));

    poolingDataSource.close();
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
public void testRestartWithoutLoaderNoReuseResource() throws Exception {
    for (int i=0; i<3 ;i++) {
        PoolingDataSource pds = new PoolingDataSource();
        pds.setClassName(MockitoXADataSource.class.getName());
        pds.setUniqueName("ds");
        pds.setMaxPoolSize(1);
        pds.init();

        try {
            ResourceRegistrar.register(pds);
            fail("expected IllegalStateException");
        } catch (IllegalStateException ex) {
            String expected = "A resource with uniqueName 'ds' has already been registered";
            assertEquals(expected, ex.getMessage().substring(0, expected.length()));
        }

        BitronixTransactionManager tm = TransactionManagerServices.getTransactionManager();
        tm.shutdown();
        assertEquals(1, ResourceRegistrar.getResourcesUniqueNames().size());

        pds.close();
    }
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
public void testRestartWithoutLoaderReuseResource() throws Exception {
    PoolingDataSource pds = new PoolingDataSource();
    pds.setClassName(MockitoXADataSource.class.getName());
    pds.setUniqueName("ds");
    pds.setMaxPoolSize(1);
    pds.init();

    for (int i=0; i<3 ;i++) {
        try {
            ResourceRegistrar.register(pds);
            fail("expected IllegalStateException");
        } catch (IllegalStateException ex) {
            String expected = "A resource with uniqueName 'ds' has already been registered";
            assertEquals(expected, ex.getMessage().substring(0, expected.length()));
        }

        BitronixTransactionManager tm = TransactionManagerServices.getTransactionManager();
        tm.shutdown();
        assertEquals(1, ResourceRegistrar.getResourcesUniqueNames().size());
    }

    pds.close();
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入依赖的package包/类
@Bean
public DataSource datasource() throws Exception {
    PoolingDataSource dataSource = new PoolingDataSource();
    dataSource.setClassName("bitronix.tm.resource.jdbc.lrc.LrcXADataSource");
    dataSource.setUniqueName("hsqldb");
    dataSource.setMaxPoolSize(5);
    dataSource.setAllowLocalTransactions(true);
    dataSource.getDriverProperties().setProperty("driverClassName", "org.hsqldb.jdbcDriver");
    dataSource.getDriverProperties().setProperty("url", "jdbc:hsqldb:mem:test");
    dataSource.getDriverProperties().setProperty("user", "sa");
    dataSource.getDriverProperties().setProperty("password", "theSaPassword");
    return dataSource;
}