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

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

View Full Code Here

  private void doExecuteScript(final Resource scriptResource) {
    if (scriptResource == null || !scriptResource.exists()) {
      throw new IllegalArgumentException("Script resource is null or does not exist");
    }


    TransactionTemplate transactionTemplate = new TransactionTemplate(new DataSourceTransactionManager(dataSource));
    transactionTemplate.execute(new TransactionCallback<Void>() {


      @Override
      public Void doInTransaction(TransactionStatus status) {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

View Full Code Here


    final SkipWriterStub<String> writer = new SkipWriterStub<String>();
    FaultTolerantStepFactoryBean<String, String> factory = new FaultTolerantStepFactoryBean<String, String>();
    factory.setItemWriter(writer);


    @SuppressWarnings("serial")
    DataSourceTransactionManager transactionManager = new DataSourceTransactionManager(dataSource) {
      private boolean failed = false;
      @Override
      protected void doCommit(DefaultTransactionStatus status) throws TransactionException {
        if (writer.getWritten().isEmpty() || failed || !isExistingTransaction(status.getTransaction())) {
          super.doCommit(status);

View Full Code Here

    when(con.prepareStatement("select foo from bar", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
        ResultSet.HOLD_CURSORS_OVER_COMMIT)).thenReturn(ps);
    when(ds.getConnection()).thenReturn(con);
    when(ds.getConnection()).thenReturn(con);
    con.commit();
    PlatformTransactionManager tm = new DataSourceTransactionManager(ds);
    TransactionTemplate tt = new TransactionTemplate(tm);
    final JdbcCursorItemReader<String> reader = new JdbcCursorItemReader<String>();
    reader.setDataSource(new ExtendedConnectionDataSourceProxy(ds));
    reader.setUseSharedExtendedConnection(true);
    reader.setSql("select foo from bar");

View Full Code Here

    PreparedStatement ps = mock(PreparedStatement.class);
    when(con.prepareStatement("select foo from bar", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)).thenReturn(ps);
    when(ds.getConnection()).thenReturn(con);
    when(ds.getConnection()).thenReturn(con);
    con.commit();
    PlatformTransactionManager tm = new DataSourceTransactionManager(ds);
    TransactionTemplate tt = new TransactionTemplate(tm);
    final JdbcCursorItemReader<String> reader = new JdbcCursorItemReader<String>();
    reader.setDataSource(ds);
    reader.setSql("select foo from bar");
    final ExecutionContext ec = new ExecutionContext();

View Full Code Here

    con.close();




    final ExtendedConnectionDataSourceProxy csds = new ExtendedConnectionDataSourceProxy();
    csds.setDataSource(ds);
    PlatformTransactionManager tm = new DataSourceTransactionManager(csds);
    TransactionTemplate tt = new TransactionTemplate(tm);
    final TransactionTemplate tt2 = new TransactionTemplate(tm);
    tt2.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRES_NEW);
    final JdbcTemplate template = new JdbcTemplate(csds);

View Full Code Here

  private JobExplorer jobExplorer;


  @Autowired(required = false)
  public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.transactionManager = new DataSourceTransactionManager(dataSource);
  }

View Full Code Here

  private void doExecuteScript(final Resource scriptResource) {
    if (scriptResource == null || !scriptResource.exists())
      return;
    final JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);


    TransactionTemplate transactionTemplate = new TransactionTemplate(new DataSourceTransactionManager(dataSource));
    transactionTemplate.execute(new TransactionCallback<Void>() {


            @Override
      @SuppressWarnings("unchecked")
      public Void doInTransaction(TransactionStatus status) {

View Full Code Here

    when(con.prepareCall("{call foo_bar()}", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
        ResultSet.HOLD_CURSORS_OVER_COMMIT)).thenReturn(cs);
    when(ds.getConnection()).thenReturn(con);
    when(ds.getConnection()).thenReturn(con);
    con.commit();
    PlatformTransactionManager tm = new DataSourceTransactionManager(ds);
    TransactionTemplate tt = new TransactionTemplate(tm);
    final StoredProcedureItemReader<String> reader = new StoredProcedureItemReader<String>();
    reader.setDataSource(new ExtendedConnectionDataSourceProxy(ds));
    reader.setUseSharedExtendedConnection(true);
    reader.setProcedureName("foo_bar");

View Full Code Here

    CallableStatement cs = mock(CallableStatement.class);
    when(con.prepareCall("{call foo_bar()}", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)).thenReturn(cs);
    when(ds.getConnection()).thenReturn(con);
    when(ds.getConnection()).thenReturn(con);
    con.commit();
    PlatformTransactionManager tm = new DataSourceTransactionManager(ds);
    TransactionTemplate tt = new TransactionTemplate(tm);
    final StoredProcedureItemReader<String> reader = new StoredProcedureItemReader<String>();
    reader.setDataSource(ds);
    reader.setProcedureName("foo_bar");
    final ExecutionContext ec = new ExecutionContext();

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.