[Spring] Mariadb - JPA 세팅

매번 찾아보고, 약간의 삽질을 하게 되는 JPA 초기 세팅

Mariadb <-> JPA 세팅방법

 

0. docker image run

docker run --name mariadb -d -p 3306:3306 --restart=always -e MYSQL_ROOT_PASSWORD=root mariadb

 

1. build.gradle

plugins {
  id 'java'
  id 'org.springframework.boot' version '3.2.0-SNAPSHOT'
  id 'io.spring.dependency-management' version '1.1.2'
}
group = 'com.boiler.backend'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '17'

configurations {
  compileOnly {
    extendsFrom annotationProcessor
  }
}

repositories {
  mavenCentral()
  maven { url 'https://repo.spring.io/milestone' }
  maven { url 'https://repo.spring.io/snapshot' }
}

dependencies {
  implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
  implementation 'org.springframework.boot:spring-boot-starter-web'
  runtimeOnly 'org.mariadb.jdbc:mariadb-java-client' // MariaDB
  runtimeOnly 'com.h2database:h2'
  testImplementation 'org.springframework.boot:spring-boot-starter-test'
  compileOnly 'org.projectlombok:lombok'
  annotationProcessor 'org.projectlombok:lombok'

}

 

 

2.application.yaml

spring:
  datasource:
    url: jdbc:mariadb://localhost:3306/db1
    driver-class-name: org.mariadb.jdbc.Driver
    username: root
    password: root
  jpa:
    open-in-view: false
    generate-ddl: true
    show-sql: true
    hibernate:
      ddl-auto: update