Java Code Examples for com.atomikos.jdbc.AtomikosDataSourceBean#setUniqueResourceName()

The following examples show how to use com.atomikos.jdbc.AtomikosDataSourceBean#setUniqueResourceName() . 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: CustomerConfig.java    From spring-boot-jta-atomikos-sample with Apache License 2.0 6 votes vote down vote up
@Primary
	@Bean(name = "customerDataSource", initMethod = "init", destroyMethod = "close")
//	@Qualifier("customerDataSource")
	public DataSource customerDataSource() {
		MysqlXADataSource mysqlXaDataSource = new MysqlXADataSource();
		mysqlXaDataSource.setUrl(customerDatasourceProperties.getUrl());
		mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
		mysqlXaDataSource.setPassword(customerDatasourceProperties.getPassword());
		mysqlXaDataSource.setUser(customerDatasourceProperties.getUsername());
		mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);

		AtomikosDataSourceBean xaDataSource = new AtomikosDataSourceBean();
		xaDataSource.setXaDataSource(mysqlXaDataSource);
		xaDataSource.setUniqueResourceName("xads1");
		return xaDataSource;

	}
 
Example 2
Source File: JpaLocalConfig.java    From bearchoke with Apache License 2.0 6 votes vote down vote up
@Bean(initMethod = "init", destroyMethod = "close")
public DataSource dataSource() {
    AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
    ds.setUniqueResourceName(environment.getProperty("jpa.unique.resource.name"));
    ds.setXaDataSourceClassName(environment.getProperty("jpa.xa.datasource.classname"));
    ds.setMinPoolSize(environment.getProperty("jpa.ds.minpoolsize", Integer.class));
    ds.setMaxPoolSize(environment.getProperty("jpa.ds.maxpoolsize", Integer.class));

    Properties props = new Properties();
    props.put("databaseName", environment.getProperty("jpa.db.name"));
    props.put("createDatabase", environment.getProperty("jpa.db.create.strategy"));
    ds.setXaProperties(props);

    ds.setPoolSize(1);


    return ds;
}
 
Example 3
Source File: ApplicationUnitTest.java    From tutorials with MIT License 6 votes vote down vote up
private static DataSource getDataSource(String db) {

        DataSource ds;
        AtomikosDataSourceBean ads = new AtomikosDataSourceBean();
        ads.setXaDataSourceClassName("org.apache.derby.jdbc.EmbeddedXADataSource");
        Properties properties = new Properties();
        properties.put("databaseName", db);
        properties.put("createDatabase", "create");
        ads.setXaProperties(properties);
        ads.setUniqueResourceName(db);
        ads.setPoolSize(10); // optional
        ads.setBorrowConnectionTimeout(10); // optional
        ds = ads;
        return ds;

    }
 
Example 4
Source File: NodeListener.java    From JPPF with Apache License 2.0 5 votes vote down vote up
/**
 * Get or initialize the XA data source.
 * @return a {@link DataSource} instance.
 */
private static DataSource createXADataSource() {
  final AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
  final Properties props = ds.getXaProperties();
  /*
  // PostgreSQL Properties
  // !!! on PostgreSQL, the server configuration property "maxPreparedConnections"
  // must be set to a value > 0
  ds.setXaDataSourceClassName("org.postgresql.xa.PGXADataSource");
  props.setProperty("user", "jppf");
  props.setProperty("password", "jppf");
  props.setProperty("databaseName", "jppf_samples");
  props.setProperty("serverName", "localhost");
  props.setProperty("portNumber", "5432");
  // MySQL Properties
  ds.setXaDataSourceClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource");
  props.setProperty("user", "jppf");
  props.setProperty("password", "jppf");
  props.setProperty("serverName", "localhost");
  props.setProperty("port", "3306");
  props.setProperty("databaseName", "jppf_samples");
  props.setProperty("pinGlobalTxToPhysicalConnection", "true");
  */
  // H2 Properties
  ds.setXaDataSourceClassName("org.h2.jdbcx.JdbcDataSource");
  props.setProperty("user", "jppf");
  props.setProperty("password", "jppf");
  props.setProperty("URL", "jdbc:h2:tcp://localhost:9092/./jppf_samples;SCHEMA=PUBLIC");

  // common properties
  ds.setTestQuery("select count(id) from task_result");
  ds.setUniqueResourceName("jppf_samples_ds");
  ds.setPoolSize(10);
  return ds;
}
 
Example 5
Source File: DataSourceConfig.java    From mybatis.flying with Apache License 2.0 5 votes vote down vote up
@Bean("dataSource1")
@Primary
public AtomikosDataSourceBean dataSource1() {
	AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
	ds.setXaDataSource(xaDataSource1());
	ds.setUniqueResourceName("testdb");
	ds.setMinPoolSize(1);
	ds.setMaxPoolSize(3);
	ds.setMaxIdleTime(60);
	return ds;
}
 
Example 6
Source File: DataSourceConfig.java    From mybatis.flying with Apache License 2.0 5 votes vote down vote up
@Bean("dataSource2")
public DataSource dataSource2() {
	AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
	ds.setXaDataSource(xaDataSource2());
	ds.setUniqueResourceName("testdb2");
	ds.setMinPoolSize(1);
	ds.setMaxPoolSize(3);
	ds.setMaxIdleTime(60);
	return ds;
}
 
Example 7
Source File: OrderConfig.java    From spring-boot-jta-atomikos-sample with Apache License 2.0 5 votes vote down vote up
@Bean(name = "orderDataSource", initMethod = "init", destroyMethod = "close")
public DataSource orderDataSource() {
	 MysqlXADataSource mysqlXaDataSource = new MysqlXADataSource();
	 mysqlXaDataSource.setUrl(orderDatasourceProperties.getUrl());
	 mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
	 mysqlXaDataSource.setPassword(orderDatasourceProperties.getPassword());
	 mysqlXaDataSource.setUser(orderDatasourceProperties.getUsername());
	 mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
	
	 AtomikosDataSourceBean xaDataSource = new AtomikosDataSourceBean();
	 xaDataSource.setXaDataSource(mysqlXaDataSource);
	 xaDataSource.setUniqueResourceName("xads2");
	 return xaDataSource;
}
 
Example 8
Source File: OrderConfig.java    From tutorials with MIT License 5 votes vote down vote up
@Bean(initMethod = "init", destroyMethod = "close")
public AtomikosDataSourceBean orderDataSource() {
    AtomikosDataSourceBean dataSource = new AtomikosDataSourceBean();
    dataSource.setLocalTransactionMode(true);
    dataSource.setUniqueResourceName("db2");
    dataSource.setXaDataSourceClassName("org.apache.derby.jdbc.EmbeddedXADataSource");
    Properties xaProperties = new Properties();
    xaProperties.put("databaseName", "db2");
    xaProperties.put("createDatabase", "create");
    dataSource.setXaProperties(xaProperties);
    dataSource.setPoolSize(10);
    return dataSource;
}
 
Example 9
Source File: InventoryConfig.java    From tutorials with MIT License 5 votes vote down vote up
@Bean(initMethod = "init", destroyMethod = "close")
public AtomikosDataSourceBean inventoryDataSource() {
    AtomikosDataSourceBean dataSource = new AtomikosDataSourceBean();
    dataSource.setLocalTransactionMode(true);
    dataSource.setUniqueResourceName("db1");
    dataSource.setXaDataSourceClassName("org.apache.derby.jdbc.EmbeddedXADataSource");
    Properties xaProperties = new Properties();
    xaProperties.put("databaseName", "db1");
    xaProperties.put("createDatabase", "create");
    dataSource.setXaProperties(xaProperties);
    dataSource.setPoolSize(10);
    return dataSource;
}
 
Example 10
Source File: Config.java    From tutorials with MIT License 5 votes vote down vote up
@Bean(initMethod = "init", destroyMethod = "close")
public AtomikosDataSourceBean inventoryDataSource() {
    AtomikosDataSourceBean dataSource = new AtomikosDataSourceBean();
    dataSource.setLocalTransactionMode(true);
    dataSource.setUniqueResourceName("db1");
    dataSource.setXaDataSourceClassName("org.apache.derby.jdbc.EmbeddedXADataSource");
    Properties xaProperties = new Properties();
    xaProperties.put("databaseName", "db1");
    xaProperties.put("createDatabase", "create");
    dataSource.setXaProperties(xaProperties);
    dataSource.setPoolSize(10);
    return dataSource;
}
 
Example 11
Source File: Config.java    From tutorials with MIT License 5 votes vote down vote up
@Bean(initMethod = "init", destroyMethod = "close")
public AtomikosDataSourceBean orderDataSource() {
    AtomikosDataSourceBean dataSource = new AtomikosDataSourceBean();
    dataSource.setLocalTransactionMode(true);
    dataSource.setUniqueResourceName("db2");
    dataSource.setXaDataSourceClassName("org.apache.derby.jdbc.EmbeddedXADataSource");
    Properties xaProperties = new Properties();
    xaProperties.put("databaseName", "db2");
    xaProperties.put("createDatabase", "create");
    dataSource.setXaProperties(xaProperties);
    dataSource.setPoolSize(10);
    return dataSource;
}
 
Example 12
Source File: AtomikosDatasourceProvider.java    From Mycat2 with GNU General Public License v3.0 4 votes vote down vote up
@SneakyThrows
  @Override
  public JdbcDataSource createDataSource(DatasourceRootConfig.DatasourceConfig config) {
    String username = config.getUser();
    String password = config.getPassword();
    String url = config.getUrl();
    String dbType = config.getDbType();
    int maxRetryCount = config.getMaxRetryCount();
    List<String> initSQL = config.getInitSqls();
    int maxCon = config.getMaxCon();
    int minCon = config.getMinCon();

    Properties p = new Properties();
    p.setProperty("pinGlobalTxToPhysicalConnection","true");
    p.setProperty("com.atomikos.icatch.serial_jta_transactions", "false");
    AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
    ds.setXaProperties(p);
    ds.setConcurrentConnectionValidation(true);
    ds.setUniqueResourceName(config.getName());
    ds.setPoolSize(minCon);
    ds.setMaxPoolSize(maxCon);

    ds.setBorrowConnectionTimeout(60);
    ///////////////////////////////////////
    ds.setLocalTransactionMode(true);
    //////////////////////////////////////
    MysqlXADataSource mysqlXaDataSource = new MysqlXADataSource();
    mysqlXaDataSource.setUser(username);
    mysqlXaDataSource.setPassword(password);
    mysqlXaDataSource.setUrl(url);
    mysqlXaDataSource.setPinGlobalTxToPhysicalConnection(true);
    mysqlXaDataSource.setMaxReconnects(maxRetryCount);
    mysqlXaDataSource.setConnectTimeout((int) config.getMaxConnectTimeout());
//    DruidXADataSource   datasource = new DruidXADataSource();
//
//    if (maxRetryCount > 0) {
//      datasource.setConnectionErrorRetryAttempts(maxRetryCount);
//    }
//    if (dbType != null) {
//      datasource.setDbType(dbType);
//    }
//    if (initSQL != null) {
//      datasource.setConnectionInitSqls(
//          SQLParserUtils.createSQLStatementParser(initSQL, dbType).parseStatementList().stream()
//              .map(Object::toString).collect(
//              Collectors.toList()));
//    }
//    if (jdbcDriver != null) {
//      datasource.setD(jdbcDriver);
//    }
    ds.setXaDataSource(mysqlXaDataSource);
    return new JdbcDataSource(config,ds);
  }
 
Example 13
Source File: DataSourceUtils.java    From shardingsphere with Apache License 2.0 4 votes vote down vote up
private static AtomikosDataSourceBean createAtomikosDataSourceBean(final DatabaseType databaseType, final DataSource dataSource, final String databaseName) {
    AtomikosDataSourceBean result = new AtomikosDataSourceBean();
    result.setUniqueResourceName(databaseName);
    result.setXaDataSource(XADataSourceFactory.build(databaseType, dataSource));
    return result;
}