解决SpringBoot集成Mybatis 配置多数据源后，打印SQL失效问题

在Spring框架中使用MyBatis时，如果配置了多数据源，可能会导致之前配置的打印SQL语句的设置失效。这通常是因为在多数据源配置中，MyBatis的SQL打印功能只对默认数据源生效，而对于其他数据源，需要手动开启SQL打印。

确保你已经在application.properties或application.yml中启用了MyBatis的SQL日志打印功能

# mybatis 配置
mybatis:
  type-aliases-package: com.roborock.framework.entity
  mapper-locations: classpath*:mappers/**/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true

单数据源直接增加上面的配置mybatis.configuration.log-impl: org.apache.ibatis.logging.stdout.StdOutImpl 即可打印SQL语句

多数据源时，只需要在其中的一个配置类中增加如下配置即可打印SQL语句，不需要在所有数据源配置中都增加

@Bean
@ConfigurationProperties(prefix = "mybatis.configuration")
public org.apache.ibatis.session.Configuration globalConfiguration() {
    return new org.apache.ibatis.session.Configuration();
}

然后在其中一个配置类的SqlSessionFactory方法中增加入参Configuration configuration，使用bean.setConfiguration(configuration)即可！

完整代码如下：

package com.study.framework.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
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.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * @description rbk数据源配置类
 *  //basePackages  自己mapper包路径
 */
@Configuration
@MapperScan(basePackages = {"com.study.framework.mapper.rbkmapper"}, sqlSessionFactoryRef = "rbkSqlSessionFactory")
public class rbkDataSourceConfiguration {

    //配置打印SQL语句configuration
    @Bean
    @ConfigurationProperties(prefix = "mybatis.configuration")
    public org.apache.ibatis.session.Configuration globalConfiguration() {
        return new org.apache.ibatis.session.Configuration();
    }


    @Primary
    @Bean(name = "rbkDataSourceProperties")
    @ConfigurationProperties(prefix = "spring.datasource.druid.rbk")
    public DataSourceProperties rbkDataSourceProperties() {
        return new DataSourceProperties();
    }

    @Primary
    @Bean(name = "rbkDataSource")
    public DataSource storyDataSource(@Qualifier("rbkDataSourceProperties") DataSourceProperties rbkDataSourceProperties) {
        return rbkDataSourceProperties.initializeDataSourceBuilder().build();
    }

    @Primary
    @Bean("rbkSqlSessionFactory")
    public SqlSessionFactory rbkSqlSessionFactory(@Qualifier("rbkDataSource") DataSource rbkDataSource, 
org.apache.ibatis.session.Configuration configuration) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(rbkDataSource);
        //其中一个数据源中增加如下代码即可打印SQL语句
        bean.setConfiguration(configuration);
        bean.setMapperLocations(
                // 设置mybatis的xml所在位置
                new PathMatchingResourcePatternResolver().getResources("classpath*:mappers/rbkmapper/*.xml"));
        bean.setTypeAliasesPackage("com.study.framework.entity"); //自己entity包路径
        return bean.getObject();
    }

    @Primary
    @Bean(name = "rbkTransactionManager")
    public DataSourceTransactionManager rbkTransactionManager(@Qualifier("rbkDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Primary
    @Bean(name = "rbkSqlSessionTemplate")
    public SqlSessionTemplate rbkSqlSessionTemplate(@Qualifier("rbkSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

原文链接: https://onlyou.blog.csdn.net//article/details/140469592

解决SpringBoot集成Mybatis 配置多数据源后，打印SQL失效问题

目录