SpringBoot 多数据源配置 不同数据库 配置

今天做个呆呆，明天依旧呆呆

sqlserver 和 oracle

properties配置信息

spring.datasource.secondary2012.jdbc-url=jdbc:sqlserver://ip:端口;databasename=库名
spring.datasource.secondary2012.username= 
spring.datasource.secondary2012.password=
spring.datasource.secondary2012.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
#SQLServer 连接超时配置
#验证连接的有效性
spring.datasource.secondary.test-while-idle=true
#获取连接时候验证，会影响性能
spring.datasource.secondary.test-on-borrow=true
spring.datasource.secondary.validation-query=SELECT 1 
#空闲连接回收的时间间隔，与test-while-idle一起使用，设置5分钟
spring.datasource.secondary.time-between-eviction-runs-millis=300000
#连接池空闲连接的有效时间 ，设置30分钟
spring.datasource.secondary.min-evictable-idle-time-millis=1800000

# ********************** 2014 配置 *************************************** #
spring.datasource.oracle2014.jdbc-url=jdbc:oracle:thin:@ip:端口:ORACLE
spring.datasource.oracle2014.username=
spring.datasource.oracle2014.password=
spring.datasource.oracle2014.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5

config

 

import com.github.pagehelper.PageInterceptor;
import com.proapplysvr.historyMapper.history2014.Oracle2014Mapper;
import org.apache.ibatis.plugin.Interceptor;
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.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;
import java.util.Properties;


@Configuration  
@MapperScan(basePackages = {"com.historyMapper.history2014"}, sqlSessionTemplateRef = "oracle2014Template")
public class Oracle2014DataConfig {
    /**
     * @author
     * @description  2014
     * @date 2020/9/14
     */
    @Bean(name = "oracle2014Properties")
    @ConfigurationProperties(prefix = "spring.datasource.oracle2014")
    public DataSource oracle2014Properties() {
        return DataSourceBuilder.create().build();
    }
    @Bean(name = "oracle2014Factory")
    public SqlSessionFactory sqlSessionFactory(@Qualifier("oracle2014Properties") DataSource dataSource)
            throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(
                new PathMatchingResourcePatternResolver().getResources("classpath:com/historyMapper/history2014/xml/*.xml"));
        return bean.getObject();
    }

    @Bean(name = "oracle2014Manager")
    public DataSourceTransactionManager transactionManager(@Qualifier("oracle2014Properties") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "oracle2014Template")
    public SqlSessionTemplate sqlSessionTemplate(
            @Qualifier("oracle2014Factory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

依赖

 <mssql-jdbc.version>8.2.2.jre8</mssql-jdbc.version>
 <oracle.ojdbc6.version>11.2.0.3</oracle.ojdbc6.version>
 
		    <dependency>
                <groupId>com.microsoft.sqlserver</groupId>
                <artifactId>mssql-jdbc</artifactId>
                <version>${mssql-jdbc.version}</version>
            </dependency>
			<dependency>
                <groupId>com.oracle</groupId>
                <artifactId>ojdbc6</artifactId>
                <version>${oracle.ojdbc6.version}</version>
            </dependency>