Provide automatic configuration of multiple data sources for Spring boot
SpringBoot Configuration Sample
spring:
application:
name: sample
datasources:
# DataSource bean name as primaryDataSource, similar to DataSourceProperties and JdbcTemplate.
primary:
type: com.mchange.v2.c3p0.ComboPooledDataSource
driver-class-name: ${driverClass}
url: ${jdbc connection rul}
username: ${username}
password: ${password}
initialization-sql:
# ... see org.springframework.boot.autoconfigure.sql.init.SqlInitializationProperties
c3p0:
initialPoolSize: 3
minPoolSize: 5
maxPoolSize: 20
secondary:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: ${driverClass}
url: ${jdbc connection rul}
username: ${username}
password: ${password}
hikari:
connection-timeout: 3000
idle-timeout: 6000
max-lifetime: 18000
minimum-idle: 10
maximum-pool-size: 20