[Spring] DB 컨넥션 풀 이용하여 접속하기

by

pom.xml에 JPA와 Hibernate을 사용하기 위해 의존성 추가

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

application.properties에 DB 설정 추가

# 데이터베이스 연결 설정
spring.datasource.url=jdbc:mysql://localhost:3306/your_database
spring.datasource.username=your_username
spring.datasource.password=your_password

# Hibernate 설정 (옵션)
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update

# Conection Pool
spring.datasource.hikari.connection-timeout=60000
spring.datasource.hikari.maximum-pool-size=5

Spring에서는 보통 Bean을 이용해 DataSource를 생성하지만 직접 생성할 수도 있습니다.

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import javax.sql.DataSource;

@Configuration
public class DataSourceConfig {

    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/your_database");
        dataSource.setUsername("your_username");
        dataSource.setPassword("your_password");
        return dataSource;
    }
}

HikariCP를 이용해 Connection Pool을 관리하게 되는데, 따로 코드는 필요없습니다.

Leave a Comment