springboot配置双数据源

最新推荐文章于 2025-07-09 17:11:25 发布

原创最新推荐文章于 2025-07-09 17:11:25 发布 · 580 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #springboot #双数据源 #springboot+mybatis #springboot+mybatis+双数据源

本文介绍了如何在SpringBoot项目中配置双数据源，分别针对Oracle和PostgreSQL数据库。通过Druid数据源和注解方式，详细展示了Oracle及PostgreSQL的数据源配置，并实现了针对每个数据源的SqlSessionFactory。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

springboot双数据源通过注解配置

1、在application.properties配置数据源的信息

#xxx oracle DB config
xxx.oracle.jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
xxx.oracle.jdbc.username=root
xxx.oracle.jdbc.password=root
xxx.oracle.druid.initialSize=5
xxx.oracle.druid.maxActive=10
#xxx pg DB config
xxx.pg.jdbc.driverClassName=org.postgresql.Driver
xxx.pg.jdbc.url=jdbc:postgresql://@127.0.0.1/xxx
xxx.pg.jdbc.username=root
xxx.pg.jdbc.password=root
xxx.pg.druid.initialSize=5

xxx.pg.druid.maxActive=10

2、oracle配置

@Component
@MapperScan(basePackages = "com.xxx.dao.oracle",sqlSessionFactoryRef = "oracleSqlSessionFactory")
public class DataSourceOracle {

private static final Logger LOGGER = LoggerFactory.getLogger(DataSourceOracle.class);

private static final String driverClassName = "oracle.jdbc.driver.OracleDriver";

private static final String validationQuery = "SELECT 1 FROM DUAL";
private static final int maxWait = 60;
private static final boolean testOnBorrow = false;
private static final boolean testOnReturn = false;
private static final boolean testWhileIdle = true;
private static final int maxPoolPreparedStatementPerConnectionSize = 50;
private static final int timeBetweenEvictionRunsMillis = 60000;
private static final int minEvictableIdleTimeMillis = 300000;
private static final boolean removeAbandoned = true;
private static final int removeAbandonedTimeout = 1800;
private static final boolean poolPreparedStatements = true;
private static final String filters = "stat";
private static final int minIdle=3;

@Value("${xxx.oracle.jdbc.url}")
private String url;
@Value("${xxx.oracle.jdbc.username}")
private String userName;
@Value("${xxx.oracle.jdbc.password}")
private String password;
@Value("${xxx.oracle.druid.initialSize}")
private int initialSize;
@Value("${xxx.oracle.druid.maxActive}")
private int maxActive;

@Bean("oracleDataSource")
public DataSource oracleDataSource() {
DruidDataSource datasource = new DruidDataSource();

datasource.setUrl(url);
datasource.setUsername(userName);
datasource.setPassword(password);
datasource.setDriverClassName(driverClassName);
datasource.setInitialSize(initialSize);
datasource.setMinIdle(minIdle);
datasource.setMaxActive(maxActive);
datasource.setMaxWait(maxWait);
datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
datasource.setRemoveAbandoned(removeAbandoned);
datasource.setRemoveAbandonedTimeout(removeAbandonedTimeout);
datasource.setPoolPreparedStatements(poolPreparedStatements);
datasource.setValidationQuery(validationQuery);
datasource.setTestWhileIdle(testWhileIdle);
datasource.setTestOnBorrow(testOnBorrow);
datasource.setTestOnReturn(testOnReturn);
datasource.setMinIdle(minIdle);
try {
datasource.setFilters(filters);
} catch (SQLException e) {
LOGGER.error("druid oracle configuration initialization filter", e);
}
return datasource;
}

@Bean(name = "oracleSqlSessionFactory")
public SqlSessionFactory oracleSqlSessionFactory(@Qualifier("oracleDataSource") DataSource dataSource)
throws Exception {
final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource);
sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/oracle/*.xml"));
return sessionFactory.getObject();
}

}

3、postgresql配置

@Component
@MapperScan(basePackages = "com.xxx.dao.pg", sqlSessionFactoryRef = "pgSqlSessionFactory")
public class DataSourcePg {

private static final Logger LOGGER = LoggerFactory.getLogger(DataSourcePg.class);

private static final String driverClassName = "org.postgresql.Driver";

private static final String validationQuery = "SELECT 1";
private static final int maxWait = 60;
private static final boolean testOnBorrow = false;
private static final boolean testOnReturn = false;
private static final boolean testWhileIdle = true;
private static final int maxPoolPreparedStatementPerConnectionSize = 50;
private static final int timeBetweenEvictionRunsMillis = 60000;
private static final int minEvictableIdleTimeMillis = 300000;
private static final boolean removeAbandoned = true;
private static final int removeAbandonedTimeout = 1800;
private static final boolean poolPreparedStatements = true;
private static final String filters = "stat";
private static final int minIdle = 3;

@Value("${xxx.pg.jdbc.url}")
private String url;
@Value("${xxx.pg.jdbc.username}")
private String userName;
@Value("${xxx.pg.jdbc.password}")
private String password;
@Value("${xxx.pg.druid.initialSize}")
private int initialSize;
@Value("${xxx.pg.druid.maxActive}")
private int maxActive;

@Bean("pgDataSource")
public DataSource pgDataSource() {
DruidDataSource datasource = new DruidDataSource();

datasource.setUrl(url);
datasource.setUsername(userName);
datasource.setPassword(password);
datasource.setDriverClassName(driverClassName);
datasource.setInitialSize(initialSize);
datasource.setMinIdle(minIdle);
datasource.setMaxActive(maxActive);
datasource.setMaxWait(maxWait);
datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
datasource.setRemoveAbandoned(removeAbandoned);
datasource.setRemoveAbandonedTimeout(removeAbandonedTimeout);
datasource.setPoolPreparedStatements(poolPreparedStatements);
datasource.setValidationQuery(validationQuery);
datasource.setTestWhileIdle(testWhileIdle);
datasource.setTestOnBorrow(testOnBorrow);
datasource.setTestOnReturn(testOnReturn);
datasource.setMinIdle(minIdle);
try {
datasource.setFilters(filters);
} catch (SQLException e) {
LOGGER.error("druid pg configuration initialization filter", e);
}
return datasource;
}

@Bean(name = "pgSqlSessionFactory")
public SqlSessionFactory pgSqlSessionFactory(@Qualifier("pgDataSource") DataSource dataSource)
throws Exception {
final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource);
sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/pg/*.xml"));
return sessionFactory.getObject();
}

}

双数据源集成mybatis