springboot配置双数据源

最新推荐文章于 2024-08-13 15:23:11 发布

Cranberry_

最新推荐文章于 2024-08-13 15:23:11 发布

阅读量553

点赞数

文章标签： mybatis springboot 双数据源 springboot+mybatis springboot+mybatis+双数据源

本文链接：https://blog.csdn.net/qq_15418761/article/details/80654948

版权

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

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

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;
p