Examples of org.springframework.jdbc.datasource.DataSourceTransactionManager

Package org.springframework.jdbc.datasource

Examples of org.springframework.jdbc.datasource.DataSourceTransactionManager

org.springframework.jdbc.datasource.DataSourceTransactionManager
{@link org.springframework.transaction.PlatformTransactionManager}implementation for a single JDBC {@link javax.sql.DataSource}. This class is capable of working in any environment with any JDBC driver, as long as the setup uses a JDBC 2.0 Standard Extensions / JDBC 3.0 javax.sql.DataSource as its Connection factory mechanism. Binds a JDBC Connection from the specified DataSource to the current thread, potentially allowing for one thread-bound Connection per DataSource.
Note: The DataSource that this transaction manager operates on needs to return independent Connections. The Connections may come from a pool (the typical case), but the DataSource must not return thread-scoped / request-scoped Connections or the like. This transaction manager will associate Connections with thread-bound transactions itself, according to the specified propagation behavior. It assumes that a separate, independent Connection can be obtained even during an ongoing transaction.
Application code is required to retrieve the JDBC Connection via {@link DataSourceUtils#getConnection(DataSource)} instead of a standardJ2EE-style {@link DataSource#getConnection()} call. Spring classes such as{@link org.springframework.jdbc.core.JdbcTemplate} use this strategy implicitly.If not used in combination with this transaction manager, the {@link DataSourceUtils} lookup strategy behaves exactly like the nativeDataSource lookup; it can thus be used in a portable fashion.
Alternatively, you can allow application code to work with the standard J2EE-style lookup pattern {@link DataSource#getConnection()}, for example for legacy code that is not aware of Spring at all. In that case, define a {@link TransactionAwareDataSourceProxy} for your target DataSource, and passthat proxy DataSource to your DAOs, which will automatically participate in Spring-managed transactions when accessing it.
Supports custom isolation levels, and timeouts which get applied as appropriate JDBC statement timeouts. To support the latter, application code must either use {@link org.springframework.jdbc.core.JdbcTemplate}, call {@link DataSourceUtils#applyTransactionTimeout} for each created JDBC Statement,or go through a {@link TransactionAwareDataSourceProxy} which will createtimeout-aware JDBC Connections and Statements automatically.
Consider defining a {@link LazyConnectionDataSourceProxy} for your targetDataSource, pointing both this transaction manager and your DAOs to it. This will lead to optimized handling of "empty" transactions, i.e. of transactions without any JDBC statements executed. A LazyConnectionDataSourceProxy will not fetch an actual JDBC Connection from the target DataSource until a Statement gets executed, lazily applying the specified transaction settings to the target Connection.
On JDBC 3.0, this transaction manager supports nested transactions via the JDBC 3.0 {@link java.sql.Savepoint} mechanism. The{@link #setNestedTransactionAllowed "nestedTransactionAllowed"} flag defaultsto "true", since nested transactions will work without restrictions on JDBC drivers that support savepoints (such as the Oracle JDBC driver).
This transaction manager can be used as a replacement for the {@link org.springframework.transaction.jta.JtaTransactionManager} in the singleresource case, as it does not require a container that supports JTA, typically in combination with a locally defined JDBC DataSource (e.g. a Jakarta Commons DBCP connection pool). Switching between this local strategy and a JTA environment is just a matter of configuration! @author Juergen Hoeller @since 02.05.2003 @see #setNestedTransactionAllowed @see java.sql.Savepoint @see DataSourceUtils#getConnection(javax.sql.DataSource) @see DataSourceUtils#applyTransactionTimeout @see DataSourceUtils#releaseConnection @see TransactionAwareDataSourceProxy @see LazyConnectionDataSourceProxy @see org.springframework.jdbc.core.JdbcTemplate

                @Override
                public Object doInConnection(Connection con) throws SQLException, DataAccessException {
                    //This is horribly hacky but we can't rely on the main uPortal TM directly or we get
                    //into a circular dependency loop from JPA to Ehcache to jGroups and back to JPA
                    final DataSource ds = new SingleConnectionDataSource(con, true);
                    final PlatformTransactionManager ptm = new DataSourceTransactionManager(ds);
                    final TransactionOperations to = new TransactionTemplate(ptm);
                    
                    to.execute(new TransactionCallbackWithoutResult() {
                        @Override
                        protected void doInTransactionWithoutResult(TransactionStatus status) {

View Full Code Here

    return dataSource;
  }


  @Bean
  public PlatformTransactionManager transactionManager() {
    return new DataSourceTransactionManager(dataSource());
  }

View Full Code Here

  @Override
  public void afterPropertiesSet() throws Exception {
    Assert.notNull(dataSources, "data source can not be null.");
    
    for (DataSource dataSource : dataSources) {
      DataSourceTransactionManager txManager = new DataSourceTransactionManager(dataSource);
      transactionManagers.put(dataSource, txManager);
    }
    this.addShutdownHook();
  }

View Full Code Here

      try {
        commitCount.addAndGet(1);


        log.debug("Committing JDBC transaction");
        
        DataSourceTransactionManager txManager = this.transactionManagers.get(dataSource);
        
        TransactionStatus transactionStatus = ((MultiDataSourcesTransactionStatus)status).get(dataSource);
        txManager.commit(transactionStatus);


        log.debug("Commit JDBC transaction success");
      } catch (Throwable e) {
        log.debug("Could not commit JDBC transaction", e);
        ex = e;

View Full Code Here

      try {
        log.debug("Rolling back JDBC transaction");
        
        rollbackCount.addAndGet(1);
        
        DataSourceTransactionManager txManager = this.transactionManagers.get(dataSource);
        TransactionStatus currentStatus = ((MultiDataSourcesTransactionStatus)status).get(dataSource);


        txManager.rollback(currentStatus);


        log.info("Roll back JDBC transaction success");
      } catch (Throwable e) {
        log.info("Could not roll back JDBC transaction", e);
        ex = e;

View Full Code Here

@Configuration
public class PopulatedSchemaDatabaseConfig {


  @Bean
  public PlatformTransactionManager transactionManager() {
    return new DataSourceTransactionManager(dataSource());
  }

View Full Code Here

  @Configuration
  static class Config {


    @Bean
    public PlatformTransactionManager txMgr1() {
      return new DataSourceTransactionManager(dataSource1());
    }

View Full Code Here

      return new DataSourceTransactionManager(dataSource1());
    }


    @Bean
    public PlatformTransactionManager txMgr2() {
      return new DataSourceTransactionManager(dataSource2());
    }

View Full Code Here

  @Configuration
  static class Config {


    @Bean
    public PlatformTransactionManager txMgr1() {
      return new DataSourceTransactionManager(dataSource1());
    }

View Full Code Here

      return new DataSourceTransactionManager(dataSource1());
    }


    @Bean
    public PlatformTransactionManager txMgr2() {
      return new DataSourceTransactionManager(dataSource2());
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.jdbc.datasource.DataSourceTransactionManager

at.compax.bbsng.dataimport.app.DataSourceConfiguration

com.alibaba.cobar.client.transaction.MultipleDataSourcesTransactionManager

com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect

com.alibaba.otter.node.etl.load.loader.db.interceptor.operation.AbstractOperationInterceptor

com.bank.config.AppConfig

com.google.enterprise.connector.sharepoint.dao.UserDataStoreDAO

com.jpoweredcart.common.config.MainModuleConfig

com.mycila.testing.plugin.spring.MyJavaConfig

com.nurkiewicz.jdbcrepository.JdbcRepositoryTestConfig

com.nurkiewicz.jdbcrepository.StandaloneUsageTest

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.