인프런 영문 브랜드 로고
인프런 영문 브랜드 로고

인프런 커뮤니티 질문&답변

stomboy2님의 프로필 이미지
stomboy2

작성한 질문수

자바 ORM 표준 JPA 프로그래밍 - 기본편

Hello JPA - 애플리케이션 개발

Exception in thread "main" javax.persistence.RollbackException: Error while committing the transaction 에러가 발생합니다

작성

·

2.8K

0

안녕하세요 강사님! 

강의 정말 잘보고있습니다! 항상 감사합니다

현재 아래와 같은에러가 계속해서 발생하고있습니다

tx.commit(); 

위부분에서 에러가 나는것 같은데 혹시 이유를 알 수 있을까요?

INFO: HHH000204: Processing PersistenceUnitInfo [name: hello]

2월 16, 2021 9:21:38 오후 org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {5.4.1.Final}

2월 16, 2021 9:21:38 오후 org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>

INFO: HCANN000001: Hibernate Commons Annotations {5.1.0.Final}

2월 16, 2021 9:21:40 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)

2월 16, 2021 9:21:40 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: using driver [org.h2.Driver] at URL [jdbc:h2:tcp://localhost/~/jpashop]

2월 16, 2021 9:21:40 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {user=sa}

2월 16, 2021 9:21:40 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

2월 16, 2021 9:21:40 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections <init>

INFO: HHH000115: Hibernate connection pool size: 20 (min=1)

2월 16, 2021 9:21:40 오후 org.hibernate.dialect.Dialect <init>

INFO: HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2월 16, 2021 9:21:42 오후 org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator initiateService

INFO: HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]

Hibernate: 

    /* insert Member

        */ insert 

        into

            Member

            (name, id) 

        values

            (?, ?)

2월 16, 2021 9:21:42 오후 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

WARN: SQL Error: 42102, SQLState: 42S02

2월 16, 2021 9:21:42 오후 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

ERROR: Table "MEMBER" not found; SQL statement:

/* insert Member */ insert into Member (name, id) values (?, ?) [42102-200]

2월 16, 2021 9:21:42 오후 org.hibernate.internal.ExceptionMapperStandardImpl mapManagedFlushFailure

ERROR: HHH000346: Error during managed flush [org.hibernate.exception.SQLGrammarException: could not prepare statement]

Exception in thread "main" javax.persistence.RollbackException: Error while committing the transaction

at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:81)

at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:107)

at JpaMain.main(JpaMain.java:19)

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)

at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)

at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:65)

... 2 more

Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement

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

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.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:78)

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

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

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

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

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

at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)

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

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

at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:515)

at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3348)

at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2519)

at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)

at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)

at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)

... 1 more

Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "MEMBER" not found; SQL statement:

/* insert Member */ insert into Member (name, id) values (?, ?) [42102-199]

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

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

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

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

at org.h2.command.Parser.readTableOrView(Parser.java:7146)

at org.h2.command.Parser.readTableOrView(Parser.java:7117)

at org.h2.command.Parser.parseInsert(Parser.java:1682)

at org.h2.command.Parser.parsePrepared(Parser.java:891)

at org.h2.command.Parser.parse(Parser.java:788)

at org.h2.command.Parser.parse(Parser.java:760)

at org.h2.command.Parser.prepareCommand(Parser.java:683)

at org.h2.engine.Session.prepareLocal(Session.java:627)

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

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

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

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

at org.h2.engine.SessionRemote.done(SessionRemote.java:611)

at org.h2.command.CommandRemote.prepare(CommandRemote.java:85)

at org.h2.command.CommandRemote.<init>(CommandRemote.java:51)

at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:481)

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)

at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)

at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:87)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)

... 18 more

답변 1

0

김영한님의 프로필 이미지
김영한
지식공유자

안녕하세요. stomboy2님

Table "MEMBER" not found 오류입니다.

member 테이블이 있는지 데이터베이스에서 확인해주세요.

감사합니다.

stomboy2님의 프로필 이미지
stomboy2

작성한 질문수

질문하기