Spring Boot 2.0多数据源配置

╰半橙微兮° 2022-05-12 01:08 151阅读 0赞

两个数据库实例，一个负责读，一个负责写。

datasource-reader:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://192.168.43.61:3306/test?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false
        username: icbc
        password: icbc
        driver-class-name: com.mysql.jdbc.Driver
        continue-on-error: false
        sql-script-encoding: UTF-8
    
    datasource-writer:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://192.168.43.61:3306/hdfs?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false
        username: icbc
        password: icbc
        driver-class-name: com.mysql.jdbc.Driver
        continue-on-error: false
        sql-script-encoding: UTF-8

**读数据库配置**

@Configuration
    @EnableTransactionManagement
    @EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactoryPrimary", transactionManagerRef = "transactionManagerPrimary", basePackages = {
            "cn.cib.repository.read"})
    public class RepositoryPrimaryConfig { 
    
        @Autowired
        @Qualifier("r_ds")
        private DataSource r_ds;
    
        @Bean(destroyMethod = "", name = "entityManagerPrimary")
        @Primary
        public EntityManager entityManager() {
            return entityManagerFactoryPrimary().getObject().createEntityManager();
        }
    
        @Bean(destroyMethod = "", name = "entityManagerFactoryPrimary")
        @Primary
        public LocalContainerEntityManagerFactoryBean entityManagerFactoryPrimary() {
            HibernateJpaVendorAdapter jpaVendorAdapter = new HibernateJpaVendorAdapter();
    
            LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
            factoryBean.setDataSource(r_ds);
            factoryBean.setJpaVendorAdapter(jpaVendorAdapter);
            factoryBean.setJpaProperties(HibernatePropertiesBuilder.hibernateProperties());
            factoryBean.setPackagesToScan("cn.cib.repository.read", "cn.cib.entity.read");
            factoryBean.setPersistenceUnitName("read");
            return factoryBean;
        }
    
        @Bean(destroyMethod = "", name = "transactionManagerPrimary")
        @Primary
        PlatformTransactionManager transactionManagerPrimary() {
            return new JpaTransactionManager(entityManagerFactoryPrimary().getObject());
        }
    
    }

**写数据库配置**

@Configuration
    @EnableTransactionManagement
    @EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactorySecondary", transactionManagerRef = "transactionManagerSecondary", basePackages = {
            "cn.cib.repository.write"})
    public class RepositorySecondaryConfig { 
    
        @Autowired
        @Qualifier("w_ds")
        private  DataSource w_ds;
    
        @Bean(destroyMethod = "", name = "entityManagerSecondary")
        public  EntityManager entityManager() {
            return entityManagerFactorySecondary().getObject().createEntityManager();
        }
    
        @Bean(destroyMethod = "", name = "entityManagerFactorySecondary")
        public LocalContainerEntityManagerFactoryBean entityManagerFactorySecondary() {
            HibernateJpaVendorAdapter jpaVendorAdapter = new HibernateJpaVendorAdapter();
    
            LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
            factoryBean.setDataSource(w_ds);
            factoryBean.setJpaVendorAdapter(jpaVendorAdapter);
            factoryBean.setJpaProperties(HibernatePropertiesBuilder.hibernateProperties());
            factoryBean.setPackagesToScan("cn.cib.repository.write","cn.cib.entity.write");
            factoryBean.setPersistenceUnitName("write");
            return factoryBean;
        }
    
        @Bean(destroyMethod = "", name = "transactionManagerSecondary")
        PlatformTransactionManager transactionManagerSecondary() {
            return new JpaTransactionManager(entityManagerFactorySecondary().getObject());
        }
    
    }

**Hibernate相关属性配置**

public class HibernatePropertiesBuilder {
    
        public static Properties hibernateProperties() {
            final Properties hibernateProperties = new Properties();
            hibernateProperties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
            hibernateProperties.setProperty("hibernate.hbm2ddl.auto", "update");
            hibernateProperties.setProperty("hibernate.show_sql", "true");
            hibernateProperties.setProperty("hibernate.format_sql", "true");
            return hibernateProperties;
        }
    }

*更多源码请参考链接：*

[https://github.com/ypmc/spring-cloud/tree/master/spring-batch][https_github.com_ypmc_spring-cloud_tree_master_spring-batch]

[https_github.com_ypmc_spring-cloud_tree_master_spring-batch]: https://github.com/ypmc/spring-cloud/tree/master/spring-batch