[SpringBoot] Database Connetion 설정

Spring Boot MariaDB 연결 설정 관련 메모

 

1. 의존성 추가 

 - pom.xml

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-configuration-processor</artifactId>
	<optional>true</optional>
</dependency>
<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
	<groupId>org.mariadb.jdbc</groupId>
	<artifactId>mariadb-java-client</artifactId>
	<scope>runtime</scope>
</dependency>

 

 

2. Database 관련 설정 추가

 - application.properties

spring.datasource.hikari.driver-class-name=org.mariadb.jdbc.Driver
spring.datasource.hikari.jdbc-url=jdbc:mariadb://아이피:포트/데이터베이스명
spring.datasource.hikari.username=사용자명
spring.datasource.hikari.password=비밀번호
spring.datasource.hikari.connection-timeout=3000
spring.datasource.hikari.validation-timeout=3000
spring.datasource.hikari.minimum-idle=2
spring.datasource.hikari.max-lifetime=240000
spring.datasource.hikari.maximum-pool-size=3
spring.datasource.hikari.auto-commit=false

 

 

3. Spring Boot 설정 파일 추가

@Configuration
@EnableTransactionManagement
public class DatabaseConfig {

	@Primary @Bean
	@ConfigurationProperties(prefix = "spring.datasource.hikari")
	HikariConfig hikariConfig() {
		return new HikariConfig();
	}

	@Primary @Bean
	DataSource dataSource(HikariConfig hikariConfig) {
		return new HikariDataSource(hikariConfig);
	}

	@Primary @Bean
	PlatformTransactionManager platformTransactionManager(DataSource dataSource) {
		DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager(dataSource);
		dataSourceTransactionManager.setGlobalRollbackOnParticipationFailure(false);
		return dataSourceTransactionManager;
	}

}