Examples of org.springframework.jdbc.datasource.lookup.IsolationLevelDataSourceRouter

Package org.springframework.jdbc.datasource.lookup

Examples of org.springframework.jdbc.datasource.lookup.IsolationLevelDataSourceRouter

org.springframework.jdbc.datasource.lookup.IsolationLevelDataSourceRouter
DataSource that routes to one of various target DataSources based on the current transaction isolation level. The target DataSources need to be configured with the isolation level name as key, as defined on the {@link org.springframework.transaction.TransactionDefinition TransactionDefinition interface}.
This is particularly useful in combination with JTA transaction management (typically through Spring's {@link org.springframework.transaction.jta.JtaTransactionManager}). Standard JTA does not support transaction-specific isolation levels. Some JTA providers support isolation levels as a vendor-specific extension (e.g. WebLogic), which is the preferred way of addressing this. As alternative (e.g. on WebSphere), the target database can be represented through multiple JNDI DataSources, each configured with a different isolation level (for the entire DataSource). The present DataSource router allows to transparently switch to the appropriate DataSource based on the current transaction's isolation level.
The configuration can for example look like this, assuming that the target DataSources are defined as individual Spring beans with names "myRepeatableReadDataSource", "mySerializableDataSource" and "myDefaultDataSource":
```
 <bean id="dataSourceRouter" class="org.springframework.jdbc.datasource.lookup.IsolationLevelDataSourceRouter"> <property name="targetDataSources"> <map> <entry key="ISOLATION_REPEATABLE_READ" value-ref="myRepeatableReadDataSource"/> <entry key="ISOLATION_SERIALIZABLE" value-ref="mySerializableDataSource"/> </map> </property> <property name="defaultTargetDataSource" ref="myDefaultDataSource"/> </bean>
```
Alternatively, the keyed values can also be data source names, to be resolved through a {@link #setDataSourceLookup DataSourceLookup}: by default, JNDI names for a standard JNDI lookup. This allows for a single concise definition without the need for separate DataSource bean definitions.
```
 <bean id="dataSourceRouter" class="org.springframework.jdbc.datasource.lookup.IsolationLevelDataSourceRouter"> <property name="targetDataSources"> <map> <entry key="ISOLATION_REPEATABLE_READ" value="java:comp/env/jdbc/myrrds"/> <entry key="ISOLATION_SERIALIZABLE" value="java:comp/env/jdbc/myserds"/> </map> </property> <property name="defaultTargetDataSource" value="java:comp/env/jdbc/mydefds"/> </bean>
```
Note: If you are using this router in combination with Spring's {@link org.springframework.transaction.jta.JtaTransactionManager}, don't forget to switch the "allowCustomIsolationLevels" flag to "true". (By default, JtaTransactionManager will only accept a default isolation level because of the lack of isolation level support in standard JTA itself.)
```
 <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"> <property name="allowCustomIsolationLevels" value="true"/> </bean>
```
@author Juergen Hoeller @since 2.0.1 @see #setTargetDataSources @see #setDefaultTargetDataSource @see org.springframework.transaction.TransactionDefinition#ISOLATION_READ_UNCOMMITTED @see org.springframework.transaction.TransactionDefinition#ISOLATION_READ_COMMITTED @see org.springframework.transaction.TransactionDefinition#ISOLATION_REPEATABLE_READ @see org.springframework.transaction.TransactionDefinition#ISOLATION_SERIALIZABLE @see org.springframework.transaction.jta.JtaTransactionManager

    con2.close();
    con2Control.setVoidCallable(1);
    con2Control.replay();
    ds2Control.replay();


    final IsolationLevelDataSourceRouter dsToUse = new IsolationLevelDataSourceRouter();
    Map targetDataSources = new HashMap();
    if (dataSourceLookup) {
      targetDataSources.put("ISOLATION_REPEATABLE_READ", "ds2");
      dsToUse.setDefaultTargetDataSource("ds1");
      StaticListableBeanFactory beanFactory = new StaticListableBeanFactory();
      beanFactory.addBean("ds1", ds1);
      beanFactory.addBean("ds2", ds2);
      dsToUse.setDataSourceLookup(new BeanFactoryDataSourceLookup(beanFactory));
    }
    else {
      targetDataSources.put("ISOLATION_REPEATABLE_READ", ds2);
      dsToUse.setDefaultTargetDataSource(ds1);
    }
    dsToUse.setTargetDataSources(targetDataSources);
    dsToUse.afterPropertiesSet();


    JtaTransactionManager ptm = new JtaTransactionManager(ut);
    ptm.setAllowCustomIsolationLevels(true);


    TransactionTemplate tt = new TransactionTemplate(ptm);

View Full Code Here


    final DataSource dataSource2 = mock(DataSource.class);
    final Connection connection2 = mock(Connection.class);
    given(dataSource2.getConnection()).willReturn(connection2);


    final IsolationLevelDataSourceRouter dsToUse = new IsolationLevelDataSourceRouter();
    Map<Object, Object> targetDataSources = new HashMap<Object, Object>();
    if (dataSourceLookup) {
      targetDataSources.put("ISOLATION_REPEATABLE_READ", "ds2");
      dsToUse.setDefaultTargetDataSource("ds1");
      StaticListableBeanFactory beanFactory = new StaticListableBeanFactory();
      beanFactory.addBean("ds1", dataSource1);
      beanFactory.addBean("ds2", dataSource2);
      dsToUse.setDataSourceLookup(new BeanFactoryDataSourceLookup(beanFactory));
    }
    else {
      targetDataSources.put("ISOLATION_REPEATABLE_READ", dataSource2);
      dsToUse.setDefaultTargetDataSource(dataSource1);
    }
    dsToUse.setTargetDataSources(targetDataSources);
    dsToUse.afterPropertiesSet();


    JtaTransactionManager ptm = new JtaTransactionManager(userTransaction);
    ptm.setAllowCustomIsolationLevels(true);


    TransactionTemplate tt = new TransactionTemplate(ptm);

View Full Code Here

TOP

Related Classes of org.springframework.jdbc.datasource.lookup.IsolationLevelDataSourceRouter

org.springframework.jdbc.datasource.DataSourceJtaTransactionTests

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.