1app.datasource.primary.url=jdbc:postgresql://localhost:5432/appdb
2app.datasource.primary.username=app
3app.datasource.primary.password=secret
4
5app.datasource.reporting.url=jdbc:mysql://localhost:3306/reporting
6app.datasource.reporting.username=report
7app.datasource.reporting.password=secret

1package com.example.config;
2
3import javax.sql.DataSource;
4import org.springframework.beans.factory.annotation.Qualifier;
5import org.springframework.boot.context.properties.ConfigurationProperties;
6import org.springframework.boot.jdbc.DataSourceBuilder;
7import org.springframework.context.annotation.Bean;
8import org.springframework.context.annotation.Configuration;
9import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
10import org.springframework.orm.jpa.JpaTransactionManager;
11import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
12import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
13import org.springframework.transaction.PlatformTransactionManager;
14
15@Configuration
16@EnableJpaRepositories(
17    basePackages = "com.example.primary.repo",
18    entityManagerFactoryRef = "primaryEntityManagerFactory",
19    transactionManagerRef = "primaryTransactionManager"
20)
21public class PrimaryDbConfig {
22
23    @Bean
24    @ConfigurationProperties("app.datasource.primary")
25    public DataSource primaryDataSource() {
26        return DataSourceBuilder.create().build();
27    }
28
29    @Bean
30    public LocalContainerEntityManagerFactoryBean primaryEntityManagerFactory(
31            @Qualifier("primaryDataSource") DataSource dataSource) {
32        LocalContainerEntityManagerFactoryBean bean = new LocalContainerEntityManagerFactoryBean();
33        bean.setDataSource(dataSource);
34        bean.setPackagesToScan("com.example.primary.model");
35        bean.setJpaVendorAdapter(new HibernateJpaVendorAdapter());
36        return bean;
37    }
38
39    @Bean
40    public PlatformTransactionManager primaryTransactionManager(
41            @Qualifier("primaryEntityManagerFactory")
42            LocalContainerEntityManagerFactoryBean emf) {
43        return new JpaTransactionManager(emf.getObject());
44    }
45}

1@Configuration
2@EnableJpaRepositories(
3    basePackages = "com.example.reporting.repo",
4    entityManagerFactoryRef = "reportingEntityManagerFactory",
5    transactionManagerRef = "reportingTransactionManager"
6)
7public class ReportingDbConfig {
8
9    @Bean
10    @ConfigurationProperties("app.datasource.reporting")
11    public DataSource reportingDataSource() {
12        return DataSourceBuilder.create().build();
13    }
14
15    @Bean
16    public LocalContainerEntityManagerFactoryBean reportingEntityManagerFactory(
17            @Qualifier("reportingDataSource") DataSource dataSource) {
18        LocalContainerEntityManagerFactoryBean bean = new LocalContainerEntityManagerFactoryBean();
19        bean.setDataSource(dataSource);
20        bean.setPackagesToScan("com.example.reporting.model");
21        bean.setJpaVendorAdapter(new HibernateJpaVendorAdapter());
22        return bean;
23    }
24
25    @Bean
26    public PlatformTransactionManager reportingTransactionManager(
27            @Qualifier("reportingEntityManagerFactory")
28            LocalContainerEntityManagerFactoryBean emf) {
29        return new JpaTransactionManager(emf.getObject());
30    }
31}