SpringBoot整合atomikos实现多数据源全局事务

已于 2023-06-29 16:55:13 修改
阅读量726 收藏 4
点赞数 1
文章标签： spring boot 后端
于 2023-04-24 16:48:31 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_31259663/article/details/130344077
版权

SpringBoot整合atomikos实现多数据源全局事务
atomikos官网
引入maven 依赖

        <!--引入atomikos-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jta-atomikos</artifactId>
        </dependency>

1.application.yml 配置

spring:
  datasource:
    mysql:
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: root
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8
    oracle:
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: root
      url: jdbc:mysql://localhost:3306/test2?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8

2.这里我都是使用mysql 创建个两个库 test test2
创建数据源基本配置类(两个源两个配置)

2.1 test 配置源

package org.xiaozhang.config.db;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.xa.DruidXADataSource;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import com.atomikos.jdbc.AtomikosDataSourceBean;
import com.baomidou.mybatisplus.core.MybatisConfiguration;
import com.mysql.cj.jdbc.MysqlDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.type.JdbcType;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;
import javax.sql.XADataSource;
import java.util.HashMap;

/**
 * @Author: zy
 * @Date: 2021/08/10
 * @Description: mysql数据源配置
 */
@Configuration
@EnableConfigurationProperties(MysqlProperties.class)
@MapperScan(basePackages = "org.xiaozhang.dao.mysql",sqlSessionTemplateRef = "mysqlSqlSessionTemplate")
public class MysqlDataSourceConfig {

    /**本数据源扫描的mapper路径*/
    static final String MAPPER_LOCATION = "classpath*:mapper/mysql/*.xml";


    @Autowired
    private MysqlProperties mysqlProperties;
    @Bean(name = "mysqlDataSource")
    public DataSource mysqlDataSource(){
        //配置xa数据源
        DruidXADataSource db = new DruidXADataSource();
        db.setUrl(mysqlProperties.getUrl());
        db.setPassword(mysqlProperties.getPassWord());
        db.setUsername(mysqlProperties.getUserName());
        AtomikosDataSourceBean xaDataSource = new AtomikosDataSourceBean();
        xaDataSource.setXaDataSource(db);
        xaDataSource.setUniqueResourceName("mysql");
        return xaDataSource;
    }
    @Bean("mysqlSqlSessionFactory")
    public SqlSessionFactory sqlSessionFactory(@Qualifier("mysqlDataSource") DataSource dataSource)
            throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        MybatisConfiguration configuration = new MybatisConfiguration();
        configuration.setJdbcTypeForNull(JdbcType.NULL);
        configuration.setMapUnderscoreToCamelCase(true);
        configuration.setCacheEnabled(false);
        sqlSessionFactoryBean.setConfiguration(configuration);
        sqlSessionFactoryBean.setDataSource(dataSource);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(MAPPER_LOCATION));
        return sqlSessionFactoryBean.getObject();
    }

    @Bean(name = "mysqlTransactionManager")
    @Primary
    public DataSourceTransactionManager mysqlTransactionManager(@Qualifier("mysqlDataSource")DataSource dataSource){
        DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager(dataSource);
        return dataSourceTransactionManager;
    }
    @Primary
    @Bean(name = "mysqlSqlSessionTemplate")
    public SqlSessionTemplate mysqlSqlSessionTemplate(@Qualifier("mysqlSqlSessionFactory")SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }

    @Bean(name = "mysqlJdbcTemplate")
    JdbcTemplate mysqlJdbcTemplate(@Qualifier("mysqlDataSource") DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }

}

2.2 test2 配置源

package org.xiaozhang.config.db;

import com.alibaba.druid.pool.xa.DruidXADataSource;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import com.atomikos.jdbc.AtomikosDataSourceBean;
import com.baomidou.mybatisplus.core.MybatisConfiguration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.type.JdbcType;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.context.properties.ConfigurationPropertiesScan;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * @Author: zy
 * @Date: 2021/08/10
 * @Description: oracle数据源配置
 */
@Configuration
@EnableConfigurationProperties(OracleProperties.class)
@MapperScan(basePackages = "org.xiaozhang.dao.oracle",sqlSessionTemplateRef = "oracleSqlSessionTemplate")
public class OracleDataSourceConfig {

    @Autowired
    private OracleProperties properties;

    /**本数据源扫描的mapper路径*/
    static final String MAPPER_LOCATION = "classpath*:mapper/oracle/*.xml";
    @Bean(name = "oracleDataSource")
    public DataSource oracleDataSource(){
        DruidXADataSource db = new DruidXADataSource();
        db.setUrl(properties.getUrl());
        db.setPassword(properties.getPassWord());
        db.setUsername(properties.getUserName());
        AtomikosDataSourceBean xaDataSource = new AtomikosDataSourceBean();
        xaDataSource.setXaDataSource(db);
        xaDataSource.setUniqueResourceName("oracle");
        return xaDataSource;
    }

    @Bean("oracleSqlSessionFactory")
    public SqlSessionFactory SqlSessionFactory(@Qualifier("oracleDataSource") DataSource dataSource)
            throws Exception {

        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        MybatisConfiguration configuration = new MybatisConfiguration();
        configuration.setJdbcTypeForNull(JdbcType.NULL);
        configuration.setMapUnderscoreToCamelCase(true);
        configuration.setCacheEnabled(false);
        sqlSessionFactoryBean.setConfiguration(configuration);
        sqlSessionFactoryBean.setDataSource(dataSource);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(MAPPER_LOCATION));

        return sqlSessionFactoryBean.getObject();
    }
    @Bean(name = "oracleTransactionManager")
    public DataSourceTransactionManager oracleTransactionManager(@Qualifier("oracleDataSource")DataSource dataSource){
        return new DataSourceTransactionManager(dataSource);
    }
    @Bean(name = "oracleSqlSessionTemplate")
    public SqlSessionTemplate oracleSqlSessionTemplate(@Qualifier("oracleSqlSessionFactory")SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }

    @Bean(name = "oralceJdbcTemplate")
    JdbcTemplate oralceJdbcTemplate(@Qualifier("oracleDataSource") DataSource dataSource){
        return new JdbcTemplate(dataSource);
    }

}
  1. 配置atomikos 事务管理器
package org.xiaozhang.config.db;

import com.atomikos.icatch.jta.UserTransactionImp;
import com.atomikos.icatch.jta.UserTransactionManager;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.DependsOn;
import org.springframework.context.support.PropertySourcesPlaceholderConfigurer;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.transaction.jta.JtaTransactionManager;

import javax.transaction.TransactionManager;
import javax.transaction.UserTransaction;

@Configuration
@ComponentScan
@EnableTransactionManagement
public class MainConfig {

	@Bean
	public PropertySourcesPlaceholderConfigurer propertySourcesPlaceholderConfigurer() {
		return new PropertySourcesPlaceholderConfigurer();
	}



	@Bean(name = "userTransaction")
	public UserTransaction userTransaction() throws Throwable {
		UserTransactionImp userTransactionImp = new UserTransactionImp();
		userTransactionImp.setTransactionTimeout(10000);
		return userTransactionImp;
	}

	/**
	 * atomikos 事务管理器
	 * @return
	 * @throws Throwable
	 */
	@Bean(name = "userTransactionManager")
	public TransactionManager atomikosTransactionManager() throws Throwable {
		UserTransactionManager userTransactionManager = new UserTransactionManager();
		//设置强制关闭
		userTransactionManager.setForceShutdown(false);

		return userTransactionManager;
	}

	/**
	 * atomikos 事务管理器 与spring 事务整合一起
	 * @return
	 * @throws Throwable
	 */
	@Bean(name = "platformTransactionManager")
	@DependsOn({ "userTransaction", "userTransactionManager" })
	public PlatformTransactionManager transactionManager() throws Throwable {
		UserTransaction userTransaction = userTransaction();
		TransactionManager atomikosTransactionManager = atomikosTransactionManager();
		return new JtaTransactionManager(userTransaction, atomikosTransactionManager);
	}

}
  1. 创建测试类 和业务类 进行使用并测试
    指定下atomikos全局事务管理器
    使用spring的@Transactional注解就可以 指定下我们配置的 atomikos全局事务管理器
    就可以使用啦
    ![在这里插入图片描述](https://img-blog.csdnimg.cn/f44e19e2605f4d32b9400f6522191a7c.png

这里看下输出日志

2023-04-24 16:39:03.003 DEBUG 36120 --- [           main] tractDirtiesContextTestExecutionListener : Before test method: context [DefaultTestContext@6cb107fd testClass = FileApplicationTest, testInstance = org.xiaozhang.FileApplicationTest@19d27c27, testMethod = test13@FileApplicationTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]], class annotated with @DirtiesContext [false] with mode [null], method annotated with @DirtiesContext [false] with mode [null].
2023-04-24 16:39:03.006 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:03.006 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 3, missCount = 1]
2023-04-24 16:39:03.006 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:03.006 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 4, missCount = 1]
2023-04-24 16:39:03.160 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:03.160 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 5, missCount = 1]
2023-04-24 16:39:03.168 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:03.168  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:03.243 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:03.411  INFO 36120 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited
2023-04-24 16:39:04.051  INFO 36120 --- [           main] c.a.d.xa.XATransactionalResource         : mysql: refreshed XAResource
2023-04-24 16:39:04.136 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh0')
2023-04-24 16:39:04.158 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.161 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.162 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.165  INFO 36120 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-2} inited
2023-04-24 16:39:04.180  INFO 36120 --- [           main] c.a.d.xa.XATransactionalResource         : oracle: refreshed XAResource
2023-04-24 16:39:04.233 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh0')
2023-04-24 16:39:04.234 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.236 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.240 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction commit
2023-04-24 16:39:04.250 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.250  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.251 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.251 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh1')
2023-04-24 16:39:04.252 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.253 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.253 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.253 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh1')
2023-04-24 16:39:04.254 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.256 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.257 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
回滚数据
2023-04-24 16:39:04.265 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.266  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.266 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.266 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh2')
2023-04-24 16:39:04.267 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.268 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.268 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.269 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh2')
2023-04-24 16:39:04.269 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.270 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.271 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction commit
2023-04-24 16:39:04.277 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.277  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.278 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.278 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh3')
2023-04-24 16:39:04.278 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.280 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.280 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.280 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh3')
2023-04-24 16:39:04.281 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.282 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.283 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction commit
2023-04-24 16:39:04.289 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.289  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.290 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.290 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh4')
2023-04-24 16:39:04.291 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.292 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.292 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.292 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh4')
2023-04-24 16:39:04.293 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.294 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.296 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
回滚数据
2023-04-24 16:39:04.298 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.298  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.298 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.298 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh5')
2023-04-24 16:39:04.299 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.300 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.301 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.301 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh5')
2023-04-24 16:39:04.302 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.303 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.304 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
回滚数据
2023-04-24 16:39:04.308 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.308  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.309 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.309 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh6')
2023-04-24 16:39:04.310 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.311 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.312 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.312 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh6')
2023-04-24 16:39:04.312 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.314 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.315 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
回滚数据
2023-04-24 16:39:04.319 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.319  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.320 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.320 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh7')
2023-04-24 16:39:04.321 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.322 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.323 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.323 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh7')
2023-04-24 16:39:04.325 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.327 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.328 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction commit
2023-04-24 16:39:04.336 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.336  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.336 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.337 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh8')
2023-04-24 16:39:04.338 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.339 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.339 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.340 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh8')
2023-04-24 16:39:04.340 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.341 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.342 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
回滚数据
2023-04-24 16:39:04.345 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Creating new transaction with name [org.xiaozhang.service.impl.TranscationService.add]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; 'platformTransactionManager',-java.lang.Exception
2023-04-24 16:39:04.345  WARN 36120 --- [           main] c.a.icatch.imp.TransactionServiceImp     : Attempt to create a transaction with a timeout that exceeds maximum - truncating to: 300000
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.345 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.345 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh9')
2023-04-24 16:39:04.346 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.347 DEBUG 36120 --- [           main] o.x.d.m.M.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
拦截前public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.348 DEBUG 36120 --- [           main] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2023-04-24 16:39:04.348 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==>  Preparing: insert into test(name) value('hhh9')
2023-04-24 16:39:04.349 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : ==> Parameters: 
2023-04-24 16:39:04.351 DEBUG 36120 --- [           main] o.x.d.o.O.insertCommonSql                : <==    Updates: 1
执行后public abstract int org.apache.ibatis.executor.Executor.update(org.apache.ibatis.mapping.MappedStatement,java.lang.Object) throws java.sql.SQLException
2023-04-24 16:39:04.351 DEBUG 36120 --- [           main] o.s.t.jta.JtaTransactionManager          : Initiating transaction rollback
回滚数据
成功插入4条数据
2023-04-24 16:39:04.356 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:04.356 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 6, missCount = 1]
2023-04-24 16:39:04.357 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:04.357 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 7, missCount = 1]
2023-04-24 16:39:04.357 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:04.357 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 8, missCount = 1]
2023-04-24 16:39:04.358 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:04.358 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 9, missCount = 1]
2023-04-24 16:39:04.359 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:04.359 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 10, missCount = 1]
2023-04-24 16:39:04.360 DEBUG 36120 --- [           main] c.DefaultCacheAwareContextLoaderDelegate : Retrieved ApplicationContext [1293462056] from cache with key [[WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]]
2023-04-24 16:39:04.360 DEBUG 36120 --- [           main] org.springframework.test.context.cache   : Spring test ApplicationContext cache statistics: [DefaultContextCache@11ad095c size = 1, maxSize = 32, parentContextCount = 0, hitCount = 11, missCount = 1]
2023-04-24 16:39:04.361 DEBUG 36120 --- [           main] tractDirtiesContextTestExecutionListener : After test method: context [DefaultTestContext@6cb107fd testClass = FileApplicationTest, testInstance = org.xiaozhang.FileApplicationTest@19d27c27, testMethod = test13@FileApplicationTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]], class annotated with @DirtiesContext [false] with mode [null], method annotated with @DirtiesContext [false] with mode [null].
2023-04-24 16:39:04.361 DEBUG 36120 --- [           main] o.s.t.c.w.ServletTestExecutionListener   : Resetting RequestContextHolder for test context [DefaultTestContext@6cb107fd testClass = FileApplicationTest, testInstance = org.xiaozhang.FileApplicationTest@19d27c27, testMethod = test13@FileApplicationTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@710636b0 testClass = FileApplicationTest, locations = '{}', classes = '{class org.xiaozhang.MybatisApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@6ae5aa72, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@16293aa2, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@5c33f1a9, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@49139829, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@351d00c0, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1888ff2c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]].

成功4条 其他全部回滚 这里看下数据库
在这里插入图片描述
在这里插入图片描述

头发哐哐掉
关注
  • 1
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SpringBoot+Atomikos分布式事务及多数据源动态切换，两种demo
08-29
SpringBoot+Atomikos分布式事务及多数据源动态切换，两种demo，两条数据源，是满足事务唯一性的，看清楚是demo
SpringBoot 集成 atomikos 实现分布式事务
jslzcydd的博客
02-05 658
这里初始化会结合 MybatisConfig ：有几个数据源就会初始化几个 SqlSessionFactory 具体执行语句的时候就会使用具体的 SqlSessionFactory 去执行。在项目中当涉及到多数据源操作的时候，例如增加、更新、删除。例如rocketMQ.2、TCC事务：可以通过补偿的方式来进行事务的逆向处理。本文是介绍的一种基于XA事务的方式，采用轻量级的atomikos 的方式来保证动态多数据源的事务。1、XA事务：通过两阶段进行事务确认。自定义SqlSessionTemplate。
SpringBoot+mybatisPlus+atomikos+druid.zip
09-07
Spring Boot：mybatis-plus + atomikos + druid 实现不同实例数据库的多数据源配置和分布式事务管理（demo项目），想到工作上可能会用到多数据源，但是自己在这方面并不是很熟悉，于是在网上查阅了很多文章，结果发现，网上的文章要么版本太老有些过时，要么用的不是mybatis-plus而是mybaits，要么步骤繁琐、需要自己手动编写aop切面代码，要么在同一service层方法中只能使用@Transactional实现单个数据源的事务管理控制，总是觉得有点不太完美，所以综合了以上文章的不足之处和可以借鉴之处，在这里总结出了一个适应多方面需求的多数据源配置思路。
SpringBoot+Atomikos+动态多数据源+事务+2种切换数据源的方式
09-24
SpringBoot+Atomikos+动态多数据源+事务+2种切换数据源的方式 SpringBoot+Atomikos+动态多数据源+事务+2种切换数据源的方式
springboot-atomikos 多数据源统一事物管理demo
10-30
springboot-atomikos 多数据源统一事物管理demo！！！！
分布式事务管理Atomikos
zhangm2020的博客
09-15 4744
Atomikos是一个非常流行的开源事务管理器，并且可以嵌入到你的Spring Boot应用中。Tomcat应用服务器没有实现JTA规范，当使用Tomcat作为应用服务器的时候，需要使用第三方的事务管理器类来作为全局的事务管理器，而Atomikos框架就是这个作用，将事务管理整合到应用中，而不依赖于application server。
Spring Boot+Atomikos进行多数据源的分布式事务管理详解和实例
日拱一卒无有尽，功不唐捐终入海
08-24 3157
背景： 一直零散的使用着Spring Boot 的各种组件和特性，从未系统性的学习和总结，本次借着这个机会搞一波。共同学习，一起进步。哈哈Atomikos是一个易用、可靠、开放源码的事务管理器，它可以用于管理分布式事务，尤其在微服务架构中非常实用。它支持JTA（Java Transaction API）规范，能够与各种JTA兼容的资源管理器（如数据库和消息队列）配合使用。
【SpringBoot框架篇】4.集成jta-atomikos实现分布式事务
皓亮君的博客
04-25 4008
springboot集成jta-atomikos实现分布式事务简介引入依赖修改配置文件添加配置读取类创建多数据源,管理事务数据持久化数据库DLL文件模拟事务回滚 简介 1.分布式事务 说到分布式事务，可以理解为，由于分布式而引起的事务不一致的问题。随着项目做大，模块拆分，数据库拆分。一次包含增删改操作数据库涉及到了更新两个不同物理节点的数据库，这样的数据库事务只能保证自己处理的部分的事务，但是整个...
分布式事务之 Atomikos
【欢迎关注公众号：冬瓜白】
09-26 2666
关于分布式事务的解决方案被提到最多的就是“TCC”、“基于消息”。但其实还有一种非常经典的解决方案：JTA。而 Atomikos 就是 XA、JTA 那一套的实现，属于 2PC。 之前在项目中使用 Atomikos 主要是用来解决单服务多数据源的场景，当然它也可以解决跨服务之间的分布式事务问题。本文主要是从源码的角度简要分析一下 Atomikos 的实现。 #Atomikos+Spring Boot+MyBatis+Druid 的使用 在网上找了一个 Atomikos+Spring Boot+MyBatis
Atomikos的使用
weixin_55229531的博客
03-11 6917
Atomikos的使用
springboot jta atomikos实现分布式事物管理
08-25
主要介绍了springboot jta atomikos实现分布式事物管理,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
Spring Boot + Druid + Mybatis + Atomikos 配置多数据源 并支持分布式事务
01-23
本用例基于 Spring Boot + Druid + Mybatis 配置多数据源，并采用 JTA 实现分布式事务。
Atomikos简介
热门推荐
猎户星座
01-27 1万+
开发原因 在Java后端开发过程中事务控制非常重要，而Spring为我们提供了方便的声明式事务方法@transactional。但是默认的Spring事务只支持单数据源，而实际上一个系统往往需要写多个数据源，这个时候我们就需要考虑如何通过Spring实现对分布式事务的支持。 开发思路 对于数据库层面的分布式事务而言，JTA（Java Transaction API，XA的JAVA实现方案）是...
Spring Cloud Alibaba基础教程：Atomikos概览
yueerba126的博客
10-31 389
Atomikos
（二）atomikos 源码初探
LiMianDeRen的博客
06-02 808
atomikos最重要的入口分析
分布式事务解决方案——基于Atomikos的实现
向心行者
01-30 1703
声明：以下关于“JTA规范事务模型”、“Spring JTA分布式事务的实现”等内容均来源于其他大佬的博客内容，并已经表明出处。 1、JTA规范事务模型   Java Transaction API，通常称为JTA，是用于管理 Java中的事务的API 。它允许我们以资源无关的方式启动，提交和回滚事务。   JTA为J2EE平台提供了分布式事务服务（distributed transaction）的能力。 某种程度上，可以认为JTA规范是XA规范的Java版，其把XA规范中规定的DTP模型交互接口抽象成.
【万字长文】SpringBoot整合Atomikos实现多数据源分布式事务（提供Gitee源码）
黄团团的个人博客
08-04 1930
在最近的实际开发的过程中，遇到了在多数据源的情况下要保证原子性的问题，这个问题当时遇到了也是思考了一段时间，后来通过搜集大量资料与学习，最后是采用了分布式事务来解决这个问题，在讲解之前，在我往期的博客提前搭好了一个SpringBoot整合MyBatis搭建MySQL多数据源的教程，本篇博客我是在原有的这个项目的基础之上进行的改造，主要新增了几个配置项进行实现的，大家可以先简单的看一下这篇文章！
分布式事务解决方案之Atomikos
tiantiantbtb的博客
11-02 209
12Atomikos是一款Java/JTA事务处理工具,在SpringBoot的官网文档的分布式事务处理中Atomikos作为一种分布式事务的解决方案.文档地址: https://docs.spring.io/spring-boot/docs/2.1.18.RELEASE/reference/html/boot-features-jta.html123456789101112131415。
基于Spring Boot的校园疫情防控系统设计与实现
最新发布
wudixiuluo的博客
05-02 906
我通过对新冠病毒的到来懵生了开发一套关于校园疫情防控系统，本系统采用了Java技术，将所有业务模块采用以浏览器交互的模式，选择MySQL数据库，springboot作为系统的后台框架，开发工具选择My eclipse来进行系统的设计。基本实现了校园疫情防控系统应有的主要功能模块，本系统有管理员、学生。管理员：首页、个人中心、核酸检测管理、体温状态管理、学生管理、学生状态管理、休假申请管理、出入登记管理、疫情知识管理、论坛管理、系统管理。学生权限；首页、个人中心、学生状态管理、休假申请管理、出入登记管理；
springboot整合mybatis多数据源
04-07
好的，关于springboot整合mybatis多数据源的问题，可以给您提供一些参考。首先，在使用SpringBoot整合MyBatis时，我们可以通过配置多个数据源来实现多数据源的功能。其次，如果您需要在同一个事务中同时操作多个数据源，可以使用分布式事务框架，例如Atomikos或Bitronix。希望以上信息能对您有所帮助。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值