[해결 방법] org.hibernate.exception.ConstraintViolationException

👉 기본 환경

- Language: Java

- DB: H2 Database

- IDE: IntelliJ

 

 

⌨️ 코드

@Entity
public class MemberClctn {
 
    @Id
    @GeneratedValue
    private long id;
 
    private String username;
 
    // Address
    @Embedded
    private Address homeAddress;
 
    @ElementCollection
    @CollectionTable(name = "FAVORITE_FOOD",
            joinColumns = @JoinColumn(name = "id"))
    private Set<String> favoriteFoods = new HashSet<>();
 
    @OneToMany(cascade = CascadeType.ALL, orphanRemoval = true)
    @JoinColumn(name = "id")
    private List<AddressEntity> addressesHist = new ArrayList<>();
 
}
 

 

 

🖨️오류

ERROR: Referential integrity constraint violation: "FKAXD8WBKC203QQ3EKY4KJIV7MO: PUBLIC.ADDRESS FOREIGN KEY(ID) REFERENCES PUBLIC.MEMBERCLCTN(ID) (3)"; SQL statement:
/* insert jpa_basic.AddressEntity */ insert into ADDRESS (city, street, zipcode, id) values (?, ?, ?, ?) [23506-200]
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1356)
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1339)
    at jpa_basic.Main.main(Main.java:526)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:109)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:129)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105)
    at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:148)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633)
    at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
    at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348)
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
    at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:102)
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1352)
    ... 2 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: "FKAXD8WBKC203QQ3EKY4KJIV7MO: PUBLIC.ADDRESS FOREIGN KEY(ID) REFERENCES PUBLIC.MEMBERCLCTN(ID) (2)"; SQL statement:
/* insert jpa_basic.AddressEntity */ insert into ADDRESS (city, street, zipcode, id) values (?, ?, ?, ?) [23506-200]
    at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1235)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)
    ... 13 more
 

 

 

📡 원인

AddressEntity와 일대다 매핑키 키 이름을 id로 부여하고자 함

= MemberClctn의 PK값을 AddressEntity의 FK로 사용

이 때, FK로 사용하고자 하는 컬럼을 AddressEntity의 id 필드로 지정하여 MemberClctn의 기본 키를 참조하는 외래 키로 간주

PK값이 중복된 값을 갖을 수 없으므로 무결성 제약 조건 위반 오류 발생

 

 

📰 해결 방법

@Entity
public class MemberClctn {
 
    @Id
    @GeneratedValue
    private long id;
 
    private String username;
 
    // Address
    @Embedded
    private Address homeAddress;
 
    @ElementCollection
    @CollectionTable(name = "FAVORITE_FOOD",
            joinColumns = @JoinColumn(name = "id"))
    private Set<String> favoriteFoods = new HashSet<>();
 
    @OneToMany(cascade = CascadeType.ALL, orphanRemoval = true)
    @JoinColumn(name = "MCLCTN_NAME")
    private List<AddressEntity> addressesHist = new ArrayList<>();
 
}
 

FK값을 갖는 새로운 Col 생성

 

⭐ @JoinColumn()

- 현재 엔티티(애노테이션이 적용된 클래스)가 매핑할 테이블의 컬럼