[java Spring ] hikariCP DB Connection Pool

[java Spring ] hikariCP  DB Connection Pool

 

Spring + HikariCP 로 요즘에는 많이 사용되고 있습니다.

 

하지만 HikariCP Multiple Datasource 를 지원하려면 아래와 같이 설정을 해야 합니다.

 

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import com.zaxxer.hikari.HikariDataSource;

@Configuration
@EnableConfigurationProperties
public class DataSourceProperties {

    @Bean(name = "apiDataSource")
    @Qualifier("apiDataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.hikari.api")
    public DataSource apiDataSource() {
        
        return DataSourceBuilder.create().type(HikariDataSource.class).build();
    }
}