Java PoolingDataSource.setUniqueName方法代码示例

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包/类
@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 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;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入方法依赖的package包/类
@Bean(destroyMethod = "close")
public DataSource actualDataSource() {
    PoolingDataSource poolingDataSource = new PoolingDataSource();
    poolingDataSource.setClassName(dataSourceClassName);
    poolingDataSource.setUniqueName(getClass().getName());
    poolingDataSource.setMinPoolSize(0);
    poolingDataSource.setMaxPoolSize(5);
    poolingDataSource.setAllowLocalTransactions(true);
    poolingDataSource.setDriverProperties(new Properties());
    poolingDataSource.getDriverProperties().put("user", jdbcUser);
    poolingDataSource.getDriverProperties().put("password", jdbcPassword);
    poolingDataSource.getDriverProperties().put("url", jdbcUrl);
    return poolingDataSource;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入方法依赖的package包/类
public DataSource actualDataSource() {
    PoolingDataSource poolingDataSource = new PoolingDataSource();
    poolingDataSource.setClassName(dataSourceClassName);
    poolingDataSource.setUniqueName(getClass().getName());
    poolingDataSource.setMinPoolSize(0);
    poolingDataSource.setMaxPoolSize(5);
    poolingDataSource.setAllowLocalTransactions(true);
    poolingDataSource.setDriverProperties(new Properties());
    poolingDataSource.getDriverProperties().put("user", jdbcUser);
    poolingDataSource.getDriverProperties().put("password", jdbcPassword);
    poolingDataSource.getDriverProperties().put("url", jdbcUrl);
    return poolingDataSource;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入方法依赖的package包/类
public DataSource actualDataSource() {
    PoolingDataSource poolingDataSource = new PoolingDataSource();
    poolingDataSource.setClassName(dataSourceClassName);
    poolingDataSource.setUniqueName(getClass().getName());
    poolingDataSource.setMinPoolSize(0);
    poolingDataSource.setMaxPoolSize(5);
    poolingDataSource.setAllowLocalTransactions(true);
    poolingDataSource.setDriverProperties(new Properties());
    poolingDataSource.getDriverProperties().put("user", jdbcUser);
    poolingDataSource.getDriverProperties().put("password", jdbcPassword);
    poolingDataSource.getDriverProperties().put("databaseName", jdbcDatabase);
    poolingDataSource.getDriverProperties().put("serverName", jdbcHost);
    poolingDataSource.getDriverProperties().put("portNumber", jdbcPort);
    return poolingDataSource;
}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入方法依赖的package包/类
@Bean
	public javax.sql.DataSource dataSource() {
		// TODO: make it as configurable
		PoolingDataSource dataSource0 = new PoolingDataSource();
		dataSource0.setClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource");
		try {
			//Each datasource must be assigned a unique name. This is required for distributed crash recovery.
			dataSource0.setUniqueName(InetAddress.getLocalHost().getHostAddress());
		} catch (UnknownHostException e) {
		}
		dataSource0.setAutomaticEnlistingEnabled(true);
		dataSource0.setAllowLocalTransactions(true);
		dataSource0.setShareTransactionConnections(true);
		dataSource0.setUseTmJoin(true);
		dataSource0.setMinPoolSize(1);
		dataSource0.setMaxPoolSize(100);
		
		Properties driverProperties = new Properties();
		driverProperties.put("url", this.getDataSource().getUrl());
		driverProperties.put("user", this.getDataSource().getUsername());
		driverProperties.put("password", this.getDataSource().getPassword());
		driverProperties.put("password", this.getDataSource().getPassword());
//		driverProperties.put("journal", this.getDataSource().getPassword());
//		driverProperties.put("log-part1-filename", "btm1.tlog");
//		driverProperties.put("log-part2-filename", "btm2.tlog");
		
		dataSource0.setDriverProperties(driverProperties);
		dataSource0.init();
		return dataSource0;
	}
 

import bitronix.tm.resource.jdbc.PoolingDataSource; //导入方法依赖的package包/类
/**
 * Configure a datasource for our engine use. It is configured for MySQL
 */
private static void setupPoolingDataSource() {
	PoolingDataSource pds = new PoolingDataSource();
	pds.setMaxPoolSize(10);
	pds.setMinPoolSize(10);
	pds.setUniqueName(DS_NAME);
	pds.setClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource");
	pds.setAllowLocalTransactions(true);
	pds.getDriverProperties().put("user", USER);
	pds.getDriverProperties().put("password", PASSWORD);
	pds.getDriverProperties().put("url", URL);
	pds.getDriverProperties().put("databaseName", DB_NAME);
	pds.init();
}