spring data jpa 多数据源

最新推荐文章于 2025-07-23 14:50:37 发布

txxs

最新推荐文章于 2025-07-23 14:50:37 发布

阅读量977

点赞数 1

CC 4.0 BY-SA版权

分类专栏： springboot 文章标签： springdatajpa

本文链接：https://blog.youkuaiyun.com/maoyeqiu/article/details/78784751

springboot 专栏收录该内容

18 篇文章

订阅专栏

本文介绍如何在Spring Boot项目中配置并使用Spring Data JPA实现多数据源，包括配置文件设置、Java配置类编写等步骤，并解决了@Autowired默认按类型注入导致的数据源选择问题。

由于业务需要把原来项目的单数据源变成了两个数据源，方式和mybatis的差不多但是还是要在这里记录一下，顺便记录一下花了一个多小时解决的坑。首先看一下配置文件：

spring.datasource.primary.url=ip1
spring.datasource.primary.username=username1
spring.datasource.primary.password=password1
spring.datasource.primary.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.secondary.url=ip2
spring.datasource.secondary.username=username2
spring.datasource.secondary.password=password2
spring.datasource.secondary.driver-class-name=com.mysql.jdbc.Driver

三个Java文件：

@Configuration
public class DataSourceConfig {
    @Bean(name = "primaryDataSource")
    @Qualifier("primaryDataSource")
    @Primary
    @ConfigurationProperties(prefix="spring.datasource.primary")
    public DataSource primaryDataSource() {
        return DataSourceBuilder.create().build();
    }


    @Bean(name = "secondaryDataSource")
    @Qualifier("secondaryDataSource")
    @ConfigurationProperties(prefix="spring.datasource.secondary")
    public DataSource secondaryDataSource() {
        return DataSourceBuilder.create().build();
    }
}


@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef="entityManagerFactoryPrimary",
        transactionManagerRef="transactionManagerPrimary",
        basePackages= { "com.txxs.dao1" }) //设置Repository所在位置
public class PrimaryConfig {


    @Autowired
    @Qualifier("primaryDataSource")
    private DataSource primaryDataSource;


    @Autowired
    private JpaProperties jpaProperties;


    @Primary
    @Bean(name = "entityManagerPrimary")
    public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
        return entityManagerFactoryPrimary(builder).getObject().createEntityManager();
    }


    @Primary
    @Bean(name = "entityManagerFactoryPrimary")
    public LocalContainerEntityManagerFactoryBean entityManagerFactoryPrimary (EntityManagerFactoryBuilder builder) {
        return builder
                .dataSource(primaryDataSource)
                .properties(getVendorProperties(primaryDataSource))
                .packages("com.txxs.po1") //设置实体类所在位置
                .persistenceUnit("primaryPersistenceUnit")
                .build();
    }


    private Map<String, String> getVendorProperties(DataSource dataSource) {
        return jpaProperties.getHibernateProperties(dataSource);
    }


    @Primary
    @Bean(name = "transactionManagerPrimary")
    public PlatformTransactionManager transactionManagerPrimary(EntityManagerFactoryBuilder builder) {
        return new JpaTransactionManager(entityManagerFactoryPrimary(builder).getObject());
    }


}


@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(
        entityManagerFactoryRef="entityManagerFactorySecondary",
        transactionManagerRef="transactionManagerSecondary",
        basePackages= { "com.txxs.dao2" }) //设置Repository所在位置
public class SecondaryConfig {


    @Autowired
    @Qualifier("secondaryDataSource")
    private DataSource secondaryDataSource;


    @Autowired
    private JpaProperties jpaProperties;


    @Bean(name = "entityManagerSecondary")
    public EntityManager entityManager(EntityManagerFactoryBuilder builder) {
        return entityManagerFactorySecondary(builder).getObject().createEntityManager();
    }


    @Bean(name = "entityManagerFactorySecondary")
    public LocalContainerEntityManagerFactoryBean entityManagerFactorySecondary (EntityManagerFactoryBuilder builder) {
        return builder
                .dataSource(secondaryDataSource)
                .properties(getVendorProperties(secondaryDataSource))
                .packages("com.txxs.po2") //设置实体类所在位置
                .persistenceUnit("secondaryPersistenceUnit")
                .build();
    }


    private Map<String, String> getVendorProperties(DataSource dataSource) {
        return jpaProperties.getHibernateProperties(dataSource);
    }


    @Bean(name = "transactionManagerSecondary")
    PlatformTransactionManager transactionManagerSecondary(EntityManagerFactoryBuilder builder) {
        return new JpaTransactionManager(entityManagerFactorySecondary(builder).getObject());
    }


}

这样就可以实现spring data jpa的多数据源了，还是很简单的，有个问题是在实现的过程中总是会去加载第一个数据源，而不加载第二个数据源，报的错误如下：

14:49:22.316 [http-nio-9102-exec-2] INFO  c.txxs.task.ask - com.Aspect#aspect:50 - action=GET/v1/
Hibernate: select t.* from table1 t where ENAME like 'like%'
14:49:26.466 [http-nio-9102-exec-2] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 1146, SQLState: 42S02
14:49:26.467 [http-nio-9102-exec-2] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - Table 'datasource.table1' doesn't exist

table1是数据源2中的表，怎么解决呢，添加如下注解，原因是@Autowired默认按照类型进行注入，加上@Qualifier后spring注解按照里边的字符串的名字进行注入了

    @Qualifier("secondaryDataSource")
    private DataSource secondaryDataSource;