Oracle + Kotlin + JPA 연결

Oracle Sequence 생성

CREATE SEQUENCE YOUR_SEQ_NAME
    START WITH 1
    INCREMENT BY 1
    NOCACHE
    NOCYCLE;

Entity 설정

import jakarta.persistence.*
import java.time.LocalDateTime

@Entity
@Table(name = "YOUR_TABLE_NAME")
data class YourEntity(
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "your_seq_generator")
    @SequenceGenerator(
        name = "your_seq_generator",      // generator 이름
        sequenceName = "YOUR_SEQ_NAME",   // Oracle에 생성된 시퀀스 이름
        allocationSize = 1                // Oracle은 보통 1로 설정
    )
    val id: Long? = null,

    @Column(name = "name")
    val name: String,

    @Column(name = "created_at")
    val createdAt: LocalDateTime = LocalDateTime.now()
)

JPA에서 entity.id = null 로 .save()  하면,  id 자동 증가 되어 등록 됨.