多数据源读库打印sql

ByteX

已于 2024-04-11 15:54:27 修改

阅读量110

点赞数

分类专栏：问题排查文章标签： sql 数据库

于 2024-04-07 09:52:11 首次发布

本文链接：https://blog.csdn.net/u011067966/article/details/137452327

版权

问题排查专栏收录该内容

10 篇文章 0 订阅

订阅专栏

本文介绍了在本地开发时如何在Mybatis的只读数据库配置中设置打印SQL的日志，提供了两种方案：一种通过`logImpl`设置，另一种使用`MybatisProperties`。

摘要由CSDN通过智能技术生成

在本地进行开发的时候，需要打印读库的sql，但是常规的配置是无法打印的，需要在读库的配置中进行设置。

第一种方案

通过设置logImpl

@Configuration
@MapperScan(basePackages = "com.xxx.readonly.dao", sqlSessionFactoryRef = "readonlySqlSessionFactory")
public class ReadDbConfig {
    @Bean(name = "readDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.readonly")
    public DataSource createDataSource() {
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "readonlySqlSessionFactory")
    public SqlSessionFactory createSqlSessionFactory(@Qualifier("readDataSource") DataSource masterDataSource)
            throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(masterDataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath:readmapper/*.xml"));
		// 打印sql
         org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
         configuration.setLogImpl(org.apache.ibatis.logging.stdout.StdOutImpl.class);
         sessionFactory.setConfiguration(configuration);

        return sessionFactory.getObject();
    }

    @Bean(name = "readTransactionManager")
    public DataSourceTransactionManager createTransactionManager(@Qualifier("readDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }
}

第二种方案

添加 MybatisProperties

@Configuration
@MapperScan(basePackages = "com.xxx.readonly.dao", sqlSessionFactoryRef = "readonlySqlSessionFactory")
public class ReadDbConfig {
    @Bean(name = "readDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.readonly")
    public DataSource createDataSource() {
        return DruidDataSourceBuilder.create().build();
    }

    @Bean(name = "readonlySqlSessionFactory")
    public SqlSessionFactory createSqlSessionFactory(@Qualifier("readDataSource") DataSource masterDataSource, MybatisProperties mybatisPropertie)
            throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(masterDataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath:readmapper/*.xml"));

//         org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
//         configuration.setLogImpl(org.apache.ibatis.logging.stdout.StdOutImpl.class);
//         sessionFactory.setConfiguration(configuration);
        sessionFactory.setConfiguration(mybatisPropertie.getConfiguration());

        return sessionFactory.getObject();
    }

    @Bean(name = "readTransactionManager")
    public DataSourceTransactionManager createTransactionManager(@Qualifier("readDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }
}