问在独立的Spring Boot应用程序中配置DataSource和JdbcTemplate

EN

# Oracle DB - "foo"
spring.datasource.hikari.jdbcUrl=jdbc:oracle:thin:@//db-server-foo:1521/FOO
spring.datasource.hikari.username=fooadmin
spring.datasource.hikari.password=foo123
spring.datasource.hikari.driverClassName=oracle.jdbc.OracleDriver
# Ignite DB - "bar"
bar.datasource.hikari.url=jdbc:postgresql://db-server-bar:5432/bar
bar.datasource.hikari.username=baradmin
bar.datasource.hikari.password=bar123
bar.datasource.driver-class-name=org.postgresql.Driver

 /**
 * Auto-configured DataSource
 */
@ConfigurationProperties(prefix = "spring.datasource.hikari")
@Bean
@Primary
public DataSource dataSource() {
    return DataSourceBuilder.create().build();
}

/**
 * New Data source declared to connect to the Ignite in-memory Cache database.
 *
 * @return instance of DriverManagerDataSource
 */
@ConfigurationProperties(prefix = "bar.datasource.hikari")
@Bean
public DataSource igniteDataSource() {
    return DataSourceBuilder.create().build();
}

/**
 * Initialize the jdbc template to connect to ignite datasource.
 *
 * @return instance of JdbcTemplate to connect ot <code>igniteDataSource()</code>
 */
@Bean
@Primary
public JdbcTemplate igniteTemplate() {
    return new JdbcTemplate(igniteDataSource());
}

/**
 * Initialize the jdbc template to connect to the Oracle database.
 *
 * @return instance of JdbcTemplate to connect ot <code>dataSource()</code>
 */
@Bean
public JdbcTemplate dbjdbcTemplate() {
    return new JdbcTemplate(dataSource());
}