失效原因:配置多数据源,自定义的sqlsessionFactory不会加载mybatisplus配置,而单数据源的sqlsessionFactory不是自定义的默认去加载了mybatisplus配置
打印sql语句
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
解决方式:手动加载配置
@Bean
@ConfigurationProperties(prefix = "mybatis-plus.configuration")
public org.apache.ibatis.session.Configuration globalConfiguration() {
return new org.apache.ibatis.session.Configuration();
}
@Bean
public SqlSessionFactory sessionFactory(@Qualifier("targetDataSource") DataSource dynamicDataSource,org.apache.ibatis.session.Configuration config) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setMapperLocations(
new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/*"));
bean.setDataSource(dynamicDataSource);
bean.setConfiguration(config);
return bean.getObject();
}