em.persist 관련 질문이 있습니다!

2022-02-12T03:05:23.936Z

2022-02-11T02:09:02.736Z

0

"답변 감사드립니다. 그런데 말씀해주신 것처럼 DataIntegrityViolationException으로 Catch를 잡아도, Exception이 잡히지 않습니다 ㅠㅠ...

@Test
@Transactional
void 중복이름가입_실패해야함() {

    Member newMember1 = Member.createNewMember("abc", "abcd", "abcde", "abcde@naver.com");
    Member newMember2 = Member.createNewMember("abc", "abcd", "abcde", "abcde@naver.com");


    em.persist(newMember1);
    em.flush();
    em.clear();

    try {
        em.persist(newMember2);
        em.flush();
        em.clear();
    } catch (DataIntegrityViolationException e) {
        log.info("MYERROR = {}", e.getMessage());
    } catch (DbException d) {
        log.info("MYERROR = {}", d.getMessage());
    } catch (ConstraintViolationException e) {
        log.info("MYERROR = {}", e.getMessage());
    }

}

다음과 같이 코드를 작성했습니다.

em.persist(newMember2)를 하고 em.flush()로 DB에 밀어넣는 순간 유니크 제약 조건 확인할 것으로 예상했기 때문에 Try 안에 이렇게 넣었고... Catch로 잡을 수 있을 것이라 생각했는데... 안 잡히고 다음과 같이 에러 메세지가 발생합니다 ㅠㅠ..

혹시 다른 방법을 좀 더 시도해볼만한 것은 없을까요...??

Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement

at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)

at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)

at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3908)

at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)

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:344)

at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)

at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)

at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1402)

... 77 more

Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.UK_IM48PNV02C18VQLPRLYQC0UAR_INDEX_8 ON PUBLIC.MEMBER(JOIN_ID) VALUES 1"; SQL statement:

insert into member (created_time, last_modified_time, email, join_id, nickname, password, member_id) values (?, ?, ?, ?, ?, ?, ?) [23505-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:459)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)

at org.h2.message.DbException.get(DbException.java:205)

at org.h2.message.DbException.get(DbException.java:181)

at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:103)

at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:221)

at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:196)

at org.h2.mvstore.db.MVTable.addRow(MVTable.java:531)

at org.h2.command.dml.Insert.insertRows(Insert.java:195)

at org.h2.command.dml.Insert.update(Insert.java:151)

at org.h2.command.CommandContainer.update(CommandContainer.java:198)

at org.h2.command.Command.executeUpdate(Command.java:251)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:406)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:183)

at java.base/java.lang.Thread.run(Thread.java:833)