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;
}
}
'[Java] > [Spring]' 카테고리의 다른 글
[SpringBoot] Database Logging 설정 (0) | 2024.08.27 |
---|---|
[SpringBoot] Logback 설정 (0) | 2024.08.27 |
[SpringBoot] Jasypt 설정( 프로퍼티 암호화 ) (0) | 2024.08.26 |
[SpringBoot] Thymeleaf 설정 (0) | 2024.08.26 |
[SpringBoot] MyBatis 설정 (0) | 2024.08.26 |