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

        return new DaoImpl();
    }


    @org.springframework.context.annotation.Bean
    public PlatformTransactionManager myTransactionManager() {
        return new DataSourceTransactionManager(dataSource());
    }

View Full Code Here

    /**
     * Creates the transaction template
     */
    protected static TransactionTemplate createTransactionTemplate(DataSource dataSource) {
        TransactionTemplate transactionTemplate = new TransactionTemplate();
        transactionTemplate.setTransactionManager(new DataSourceTransactionManager(dataSource));
        transactionTemplate.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        return transactionTemplate;
    }

View Full Code Here

    return new CommentWithUserRepository(new TableDescription("COMMENTS", "COMMENTS JOIN USERS ON COMMENTS.user_name = USERS.user_name", "id"));
  }


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

View Full Code Here

    userRepository.setDataSource(dataSource);
    userRepository.setSqlGenerator(new SqlGenerator());


    //and
    final TransactionOperations tx = new TransactionTemplate(
        new DataSourceTransactionManager(dataSource));


    //when
    final List<User> users = tx.execute(new TransactionCallback<List<User>>() {
      @Override
      public List<User> doInTransaction(TransactionStatus status) {

View Full Code Here

        
        db = new EmbeddedDatabaseBuilder()
            .setType(EmbeddedDatabaseType.DERBY).build();
        reg.bind("testdb", db);
        
        DataSourceTransactionManager txMgr = new DataSourceTransactionManager();
        txMgr.setDataSource(db);
        reg.bind("txManager", txMgr);
        
        SpringTransactionPolicy txPolicy = new SpringTransactionPolicy();
        txPolicy.setTransactionManager(txMgr);
        txPolicy.setPropagationBehaviorName("PROPAGATION_REQUIRED");

View Full Code Here

    /**
     * Creates the transaction template
     */
    protected static TransactionTemplate createTransactionTemplate(DataSource dataSource) {
        TransactionTemplate transactionTemplate = new TransactionTemplate();
        transactionTemplate.setTransactionManager(new DataSourceTransactionManager(dataSource));
        transactionTemplate.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        return transactionTemplate;
    }

View Full Code Here

              .getProperty("db.driver");
        }
        dataSource = new SimpleDriverDataSource((Driver) Class.forName(
            dbDriver).newInstance(), dbURL);
        txTemplate = new TransactionTemplate(
            new DataSourceTransactionManager(dataSource));
      } catch (InstantiationException e) {
        throw new ResourceInitializationException(e);
      } catch (IllegalAccessException e) {
        throw new ResourceInitializationException(e);
      } catch (ClassNotFoundException e) {

View Full Code Here

   * Returns a transaction manager to be used to create transactions.
   * 
   * @return The transaction manager to be used to create transactions.
   */
  public PlatformTransactionManager getTransactionManager() {
    return new DataSourceTransactionManager(dataSource);
  }

View Full Code Here

   *         There was a problem initializing one of the DAOs.
   */
  private final void initDaos(final SqlDaoInterface... daoInterfaces) {
    // Create a transaction manager.
    PlatformTransactionManager transactionManager =
      new DataSourceTransactionManager(dataSource);
    
    // Create a new transaction definition and name it.
    DefaultTransactionDefinition transactionDefinition =
      new DefaultTransactionDefinition();
    transactionDefinition
      .setName("Initializing the Open mHealth DAO database tables.");
    
    // Create the new transaction.
    TransactionStatus transactionStatus =
      transactionManager.getTransaction(transactionDefinition);
    
    // Create the table if it does not exist.
    try {
      for(SqlDaoInterface daoInterface : daoInterfaces) {
        // Create the table if it does not exist.
        jdbcTemplate.execute(daoInterface.getSqlTableDefinition());
      }
    }
    // If creating the table fails, roll back the transaction and error
    // out.
    catch(DataAccessException e) {
      transactionManager.rollback(transactionStatus);
      throw
        new IllegalStateException(
          "There was an issue creating a DAO table definition.",
          e);
    }
    
    // TODO: This is where the DAO interface's update scripts would
    // be run.
    
    // Commit the transaction.
    try {
      transactionManager.commit(transactionStatus);
    }
    catch(TransactionException e) {
      transactionManager.rollback(transactionStatus);
      throw
        new IllegalStateException(
          "There was an error committing the transaction.",
          e);
    }

View Full Code Here

    /**
     * Creates the transaction template
     */
    protected static TransactionTemplate createTransactionTemplate(DataSource dataSource) {
        TransactionTemplate transactionTemplate = new TransactionTemplate();
        transactionTemplate.setTransactionManager(new DataSourceTransactionManager(dataSource));
        transactionTemplate.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        return transactionTemplate;
    }

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.