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

The following examples show how to use com.atomikos.jdbc.AtomikosDataSourceBean#setPoolSize() . 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: 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 2
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 3
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 4
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 5
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 6
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 7
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 8
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);
  }