Spring-jpa-data：多个DataSource和一个Spring配置

Question

我正在尝试使用Spring-jpa-data中的Crud存储库:

我的数据访问bean配置如下：

@Configuration
@EnableTransactionManagement
@ComponentScan (basePackages = {"com.comp.olme"})
@PropertySource("classpath:OlmeSmb-${env}.properties")
@EnableJpaRepositories(basePackages="com.comp.olme", entityManagerFactoryRef ="emGapSort", transactionManagerRef = "txManagerGapSort")
@EnableScheduling
public class OlmeSmbConfig {

   @Bean
    public BasicDataSource olmeDataSource() {
        BasicDataSource olmeDataSource = new BasicDataSource();
        ...
        return olmeDataSource;
    }



    @Bean
    public BasicDataSource gapSortDataSource() {
        BasicDataSource gapSortDataSource = new BasicDataSource();
      ...
        return gapSortDataSource;
    }



    @Bean
    public LocalContainerEntityManagerFactoryBean emFactoryOLME(@Qualifier("olmeDataSource") BasicDataSource olmeDataSource) {
        LocalContainerEntityManagerFactoryBean localConnectionFactoryBean = new LocalContainerEntityManagerFactoryBean();
      ...
        return localConnectionFactoryBean;
    }



    @Bean
    public LocalContainerEntityManagerFactoryBean emFactoryGapSort(@Qualifier("gapSortDataSource") BasicDataSource gapSortDataSource) {
        LocalContainerEntityManagerFactoryBean localConnectionFactoryBeanGapSort = new LocalContainerEntityManagerFactoryBean();
     ...
        return localConnectionFactoryBeanGapSort;
    }


    @Bean
    public EntityManager emOLME(@Qualifier("emFactoryOLME") EntityManagerFactory entityManagerFactory) {
        return entityManagerFactory.createEntityManager();
    }

    @Bean
    public EntityManager emGapSort(@Qualifier("emFactoryGapSort") EntityManagerFactory entityManagerFactory) {
        return entityManagerFactory.createEntityManager();
    }



    @Bean
    public JpaTransactionManager txManagerOLME(@Qualifier("emFactoryOLME") EntityManagerFactory entityManagerFactoryOLME) {
        JpaTransactionManager txManagerOLME = new JpaTransactionManager();
        ...
        return txManagerOLME;
    }


    @Bean
    public JpaTransactionManager txManagerGapSort(@Qualifier("emFactoryGapSort") EntityManagerFactory entityManagerFactoryGapSort) {
        JpaTransactionManager txManagerGapSort = new JpaTransactionManager();
      ....
        return txManagerGapSort;
    }

}

因此，如您所见，我有两个数据源、两个EntityManagerFactories、两个TransactionManager和其他。。。

但我只将一个EntityManagerFactory传递到@EnableJpaRepositories注释中（EntityManager FactoryRef=“emGapSort”）。

问题是:两个如何通过Spring-jpa-data使用多个数据源(entityManagerFactory)？

我读过一个示例，其中拆分配置被描述为一种解决方案，但我想使用一个 Spring Config。有可能吗？谢谢。

Answer 1

来自Spring靴- #5401

经过深思熟虑，我们决定不实施此项。您的注释建议是配置密钥前缀、bean前缀和其他bean相关设置的混合。虽然它在纸面上听起来很吸引人，但它很难实现，甚至很难与用户的定制保持一致。

因此，您可以尝试将其放在两个@Configuration类（每个@Configuration一个@EnableJpaRepositories）。