Spring Boot 2.0多数据源配置方法实例详解

2024-07-14 08:42:20

字体：大中小

来源：转载

供稿：网友

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

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-8datasource-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;  }}

总结

以上所述是小编给大家介绍的Spring Boot 2.0多数据源配置方法实例详解，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对VeVb武林网网站的支持！

注：相关教程知识阅读请移步到JAVA教程频道。

上一篇：struts2.5+框架使用通配符与动态方法常见问题小结

下一篇：Java中BigDecimal精度和相等比较的坑