[JPA] ORACLE JPA 시퀀스 생성 적용 / ORA-02289: 시퀀스가 존재하지 않습니다 해결 방법

 

📌 원인 : 오라클은 mySql과 다르게 id 자동 증가가 불가하다.

 

📌 해결 방법

JPA를 통해 시퀀스 생성기를 만들어서 @ID 값에 직접 주입해주자

 

1. DB에 시퀀스 생성

CREATE SEQUENCE FOLDER_SEQ START WITH 1 INCREMENT BY 1;

 

2. 시퀀스 생성기 만들기

@SequenceGenerator(
		name = "FOLDER_SEQ_GENERATOR"
	    , sequenceName = "FOLDER_SEQ"
	    , initialValue = 1
	    , allocationSize = 1
	)
public class Folder implements Serializable{
...
}

 

3. 시퀀스 적용

@Id
@Column(name="folder_Id")
@GeneratedValue(
    strategy = GenerationType.SEQUENCE
    , generator = "FOLDER_SEQ_GENERATOR"
)
private int folderId;

 

 

 

📌 전체 코드

package com.dalc.one.domain;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@SuppressWarnings("serial")
@Entity
@Table(name="folder")
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@SequenceGenerator(
		name = "FOLDER_SEQ_GENERATOR"
	    , sequenceName = "FOLDER_SEQ"
	    , initialValue = 1
	    , allocationSize = 1
	)
public class Folder implements Serializable{
	@Id
	@Column(name="folder_Id")
	@GeneratedValue(
    	strategy = GenerationType.SEQUENCE
    	, generator = "FOLDER_SEQ_GENERATOR"
    )
	private int folderId;
	
	@Column(name="user_id")
	private String userId;
	
	@Column(name="folder_name")
	private String folderName;
}

 

📌 해결 완료