You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/12/01 11:42:33 UTC

[GitHub] [shardingsphere] yeruilong commented on issue #13873: about ShardingSphereXA Distributed transaction:

yeruilong commented on issue #13873:
URL: https://github.com/apache/shardingsphere/issues/13873#issuecomment-983558339


   The following are the main Class
   
   1、
   @Configuration
   @MapperScan(basePackages = "com.xx.cloud.uc.admin.mapper", sqlSessionFactoryRef = "sqlSessionFactory")
   public class DataSourceConfig {
   
       @Resource
       @Qualifier("shardingDataSource")
       private DataSource dataSource;
   
       @Bean
       public DataSourceSwitch dataSourceSwitch() {
           Map<Object, Object> targetDataSources = new HashMap<>();
           return new DataSourceSwitch(dataSource, targetDataSources);
       }
   
       @Bean
       public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSourceSwitch") DataSource dynamicDataSource) throws Exception {
           MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
           bean.setDataSource(dynamicDataSource);
           return bean.getObject();
       }
   
       @Bean(name = "sqlSessionFactory")
       public SqlSessionTemplate sqlSessionTemplate(@Qualifier("sqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
           return new SqlSessionTemplate(sqlSessionFactory);
       }
   }
   
   
   
   2、
   @Slf4j
   public class DataSourceSwitch extends AbstractRoutingDataSource {
   
   
       public  final Map<Object, Object> dataSources;
   
       /**
        * 动态数据源构造器
        *
        * @param defaultDataSource 默认数据源
        * @param targetDataSource  目标数据源映射
        */
       public DataSourceSwitch(DataSource defaultDataSource,Map<Object, Object> targetDataSource) {
           dataSources = targetDataSource;
           super.setDefaultTargetDataSource(defaultDataSource);
           // 存放数据源的map
           super.setTargetDataSources(dataSources);
           // afterPropertiesSet 的作用很重要,它负责解析成可用的目标数据源
           super.afterPropertiesSet();
       }
   
       @Override
       protected Object determineCurrentLookupKey() {
           return DynamicDataSourceContextHolder.get();
       }
   
       public void addDataSource(DatasourceDto datasource) {
           HikariDataSource dataSource = new HikariDataSource();
           String jdbcUrl = "jdbc:mysql://" +
                   datasource.getHost() +
                   ":" +
                   datasource.getPort() +
                   "/" +
                   datasource.getDbName() +
                   "?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true";
           dataSource.setJdbcUrl(jdbcUrl);
           dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
           dataSource.setUsername(datasource.getUsername());
           dataSource.setPassword(datasource.getPwd());
           dataSource.setMaximumPoolSize(3);
           dataSource.setIdleTimeout(30000);
           dataSource.setMinimumIdle(3);
           // 将传入的数据源对象放入动态数据源类的静态map中,然后再讲静态map重新保存进动态数据源中
           dataSources.putIfAbsent(datasource.getDbCode(), dataSource);
           super.setTargetDataSources(dataSources);
           super.afterPropertiesSet();
       }
   }
   
   
   3、
   
   public class DynamicDataSourceContextHolder {
   
       private static final ThreadLocal<String> contextHolder = new InheritableThreadLocal<>();
   
       public static void set(String dbType) {
           contextHolder.set(dbType);
       }
   
       public static String get() {
           return contextHolder.get();
       }
   
       public static void remove() {
           contextHolder.remove();
       }
   }
   
   
   4、
   @Service
   @Slf4j
   public class BusinessConfigServiceImpl extends ServiceImpl<BusinessConfigMapper, BusinessConfig> implements BusinessConfigService {
   
       @Resource
       private BusinessConfigMapper businessConfigMapper;
   
   
   
   
       @Override
       @ShardingTransactionType(TransactionType.XA)
       @Transactional
       public Boolean updateBusinessConfig() {
   
           LambdaQueryWrapper<BusinessConfig> wrapper = new LambdaQueryWrapper<>();
           wrapper.eq(BusinessConfig::getId, 1);
           // DynamicDataSourceContextHolder.get();
           BusinessConfig businessConfig = businessConfigMapper.selectOne(wrapper);
           businessConfig.setType(1111);
           businessConfigMapper.updateById(businessConfig);
           // DynamicDataSourceContextHolder.remove();
   
           BusinessConfigServiceImpl businessConfigServiceImpl = SpringContextUtil.getBean("businessConfigServiceImpl", BusinessConfigServiceImpl.class);
           businessConfigServiceImpl.updateBusinessConfig2();
   
   
   
           //int l = 1 / 0;
   
           return true;
       }
   
   
       @Override
       //@ShardingTransactionType(TransactionType.XA)
       @Transactional(propagation = Propagation.REQUIRES_NEW,rollbackFor = Exception.class)
       public Boolean updateBusinessConfig2() {
   
           // 切换数据源
           DataSourceSwitch dataSourceSwitch = SpringContextUtil.getBean("dataSourceSwitch", DataSourceSwitch.class);
           DatasourceDto datasourcedto = new DatasourceDto();
           datasourcedto.setHost("127.0.0.1");
           datasourcedto.setPort(3306);
           datasourcedto.setUsername("root");
           datasourcedto.setPwd("123456");
           datasourcedto.setDbName("uc-center");
           datasourcedto.setDbCode("localhost");
           datasourcedto.setBelongCode("localhost");
           dataSourceSwitch.addDataSource(datasourcedto);
           DynamicDataSourceContextHolder.set(datasourcedto.getDbCode());
   
           LambdaQueryWrapper<BusinessConfig> wrapper = new LambdaQueryWrapper<>();
           wrapper.eq(BusinessConfig::getId, 1);
           // DynamicDataSourceContextHolder.get();
           BusinessConfig businessConfig = businessConfigMapper.selectOne(wrapper);
           businessConfig.setType(3333);
           //int l = 1 / 0;
           int count = businessConfigMapper.updateById(businessConfig);
   
           DynamicDataSourceContextHolder.remove();
           //int l = 1 / 0;
           return true;
       }
   }


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org