@Transactional导致切换动态数据源失败

背景：
Spring Cloud项目中，两个数据库，业务数据库是主数据库，管理员数据库是其他数据库，在删除管理员数据库时，报错。
相关代码：

mapper层：

@Mapper
@DS(DynamicDataSource.ADMIN_DB)
public interface UserMapper extends BaseMapper<User> {}

服务层：

    @Override
    @Transactional
    public ResultBean<String> delete(Long id) {
        User user = userService.getById(id);

        if (user == null) {
            throw SystemUserException.USER_NOTFOUND;
        }

        userService.removeById(id);
		
		// 其他操作

        return ResultBean.success("删除成功！");
    }

执行删除时：

Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c93e16d]
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@31965b10] will be managed by Spring
==>  Preparing: SELECT id,phone,nickname,password,remark,create_time,update_time,deleted FROM user WHERE id=? AND deleted=false
==> Parameters: 1675877645810360322(Long)
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c93e16d]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c93e16d]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c93e16d]
2023-07-04 09:33:10.827 ERROR 43867 --- [nio-8021-exec-1] o.a.c.c.C.[.[.[.[dispatcherServlet]      : Servlet.service() for servlet [dispatcherServlet] in context with path [/admin] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'micro-base.user' doesn't exist
### The error may exist in io/github/zhinushannan/admin/mapper/UserMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,phone,nickname,password,remark,create_time,update_time,deleted FROM user WHERE id=?  AND deleted=false
### Cause: java.sql.SQLSyntaxErrorException: Table 'micro-base.user' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'micro-base.user' doesn't exist] with root cause

解决方案1：

    @Override
    @Transactional
    @DS(DynamicDataSource.ADMIN_DB)
    public ResultBean<String> delete(Long id) {
    	// ...
    }

解决方法2：
在服务层代码手动切换数据源

原因：
Spring在进行事务管理时，先创建了事务、再获取了数据源（默认数据源），然后执行代码，然而这个流程，当执行到mapper层时，就已经存在了数据源，即主数据源。