To configure two different databases in Spring Boot

最新推荐文章于 2025-12-04 10:15:57 发布

原创

最新推荐文章于 2025-12-04 10:15:57 发布 · 488 阅读

9 ·

CC 4.0 BY-SA版权

文章标签：

#spring boot #数据库 #后端

本文介绍了如何在Spring Boot中使用HikariDataSource配置两个不同的数据库。你需要在配置文件中为每个数据库定义单独的属性，然后创建指向不同数据库的多个DataSource bean。可选地，可以创建JdbcTemplate bean以简化数据库交互。

@Service
public class MyService {
    private final Entity1Repository entity1Repository;
    private final Entity2Repository entity2Repository;

    @Autowired
    public MyService(Entity1Repository entity1Repository, Entity2Repository entity2Repository) {
        this.entity1Repository = entity1Repository;
        this.entity2Repository = entity2Repository;
    }

    public void doSomething() {
        // Use entity1Repository and entity2Repository to interact with databases
    }
}

To configure two different databases in Spring Boot using HikariDataSource, you can use the following approach:

Define separate properties for each database in your application.properties or application.yml file.
Configure multiple DataSource beans, each pointing to a different database.
Optionally, create JdbcTemplate beans for easier database interaction.

Here's how you can do it: