public DataSource primaryDataSource() { return DataSourceBuilder.create().build(); } @Bean(name = "secondDataSource") @Qualifier("secondDataSource") @ConfigurationProperties(prefix = "spring.datasource.sencond") public DataSource secondDataSource() { return DataSourceBuilder.create().build(); }...
@ConfigurationProperties(prefix = "spring.datasource.slave") public DataSource slaveDataSource() { log.info("create slave datasource..."); return DataSourceBuilder.create().type(dataSourceType).build(); } @Bean(name = "routingDataSource") public AbstractRoutingDataSource routingDataSource(@Quali...
@ConfigurationProperties(prefix ="spring.datasource.sencond") publicDataSourcesecondDataSource() { returnDataSourceBuilder.create().build(); } } PrimaryConfig数据源 /** *@Description: 主数据源配置 *@date */ @Configuration @EnableTransactionManagement @EnableJpaRepositories(entityManagerFactoryRef ="enti...
@PrimarypublicLocalContainerEntityManagerFactoryBean entityManagerFactoryBean() {returnfactoryBuilder.dataSource(dataSource)//这一行的目的是加入jpa的其他配置参数比如(ddl-auto: update等)//当然这个参数配置可以在事务配置的时候也可以.properties(jpaProperties.getHibernateProperties(newHibernateSettings())) .packages...
jpa: show-sql: true database-platform: org.hibernate.dialect.MySQL5InnoDBDialect hibernate: ddl-auto: update datasource: primary: driver-class-name: com.mysql.jdbc.Driver jdbc-url: jdbc:mysql://127.0.0.1:3306/db01?characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true ...
jpa: show-sql: true database-platform: org.hibernate.dialect.MySQL5InnoDBDialect hibernate: ddl-auto: update datasource: primary: driver-class-name: com.mysql.cj.jdbc.Driver jdbc-url: jdbc:mysql://ip:port/springboot_demo?characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true ...
return new JpaTransactionManager(entityManagerFactory()); } } application.properties # database configuration spring.datasource.url=jdbc:h2:file:~/main-source;AUTO_SERVER=TRUE spring.datasource.username=sa spring.datasource.password= spring.datasource.driver-class-name=org.h2.Driver ...
第一个数据源配置文件JPAPrimaryConfig.java 放在配置类package下。 packagecom.example.demomultisource.config;importorg.springframework.boot.autoconfigure.orm.jpa.HibernateProperties;importorg.springframework.boot.autoconfigure.orm.jpa.HibernateSettings;importorg.springframework.boot.autoconfigure.orm.jpa.JpaPropertie...
spring:datasource:primary:jdbc-url:jdbc:h2:file:./multi-datasource/data/testdb1driver-class-name:org.h2.Driverusername:sapassword:passwordsecondary:jdbc-url:jdbc:h2:file:./multi-datasource/data/testdb2driver-class-name:org.h2.Driverusername:sapassword:passwordh2:console:enabled:truejpa:hibernate:...
public class MultiDataSourceConfig { @Primary @Bean(name = "dataSource1")public DataSource data...