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

기본 키 매핑 강의에서 @GeneratedValue의 전략 중 IDENTITY로 코드를 실행하니까
데이터베이스에서 member 테이블 자체가 사라지고 인서트 쿼리도 안 나갑니다. 뭐가 문제인지 모르겠네요ㅠㅠ

오류 코드는 다음과 같습니다.

8월 21, 2024 7:27:28 오후 org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation

INFO: HHH000204: Processing PersistenceUnitInfo [name: hello]

8월 21, 2024 7:27:28 오후 org.hibernate.Version logVersion

INFO: HHH000412: Hibernate ORM core version 6.4.2.Final

8월 21, 2024 7:27:28 오후 org.hibernate.cache.internal.RegionFactoryInitiator initiateService

INFO: HHH000026: Second-level cache disabled

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

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

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: Loaded JDBC driver class: org.h2.Driver

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001012: Connecting with JDBC URL [jdbc:h2:tcp://localhost/~/test]

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {password=****, user=sa}

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections <init>

INFO: HHH10001115: Connection pool size: 20 (min=1)

8월 21, 2024 7:27:29 오후 org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl constructDialect

WARN: HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)

8월 21, 2024 7:27:30 오후 org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator initiateService

INFO: HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)

Hibernate:

drop table if exists Member cascade

8월 21, 2024 7:27:30 오후 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection

INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@3902bd2c] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.

Hibernate:

create table Member (

id varchar(255) generated by default as identity,

name varchar(255) not null,

primary key (id)

)

8월 21, 2024 7:27:31 오후 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection

INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@6ee99964] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.

8월 21, 2024 7:27:31 오후 org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException

WARN: GenerationTarget encountered exception accepting command : Error executing DDL "

create table Member (

id varchar(255) generated by default as identity,

name varchar(255) not null,

primary key (id)

)" via JDBC [Feature not supported: "CHARACTER VARYING(255)";]

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "

create table Member (

id varchar(255) generated by default as identity,

name varchar(255) not null,

primary key (id)

)" via JDBC [Feature not supported: "CHARACTER VARYING(255)";]

at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:94)

at org.hibernate.tool.schema.internal.Helper.applySqlString(Helper.java:233)

at org.hibernate.tool.schema.internal.Helper.applySqlStrings(Helper.java:217)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createTables(SchemaCreatorImpl.java:420)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createSequencesTablesConstraints(SchemaCreatorImpl.java:340)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:239)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:172)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:142)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:118)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:256)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:145)

at java.base/java.util.HashMap.forEach(HashMap.java:1421)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:142)

at org.hibernate.boot.internal.SessionFactoryObserverForSchemaExport.sessionFactoryCreated(SessionFactoryObserverForSchemaExport.java:37)

at org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35)

at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:315)

at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:450)

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1507)

at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:55)

at jakarta.persistence.Persistence.createEntityManagerFactory(Persistence.java:80)

at jakarta.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)

at hellojpa.JpaMain.main(JpaMain.java:9)

Caused by: org.h2.jdbc.JdbcSQLFeatureNotSupportedException: Feature not supported: "CHARACTER VARYING(255)"; SQL statement:

create table Member (

id varchar(255) generated by default as identity,

name varchar(255) not null,

[50100-224]

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

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

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

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

at org.h2.message.DbException.getUnsupportedException(DbException.java:287)

at org.h2.command.ddl.SequenceOptions.getBounds(SequenceOptions.java:316)

at org.h2.command.ddl.SequenceOptions.getBounds(SequenceOptions.java:244)

at org.h2.schema.Sequence.<init>(Sequence.java:100)

at org.h2.table.Column.initializeSequence(Column.java:459)

at org.h2.command.ddl.CommandWithColumns.generateSequences(CommandWithColumns.java:103)

at org.h2.command.ddl.CreateTable.update(CreateTable.java:113)

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

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

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

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

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

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

at org.h2.engine.SessionRemote.readException(SessionRemote.java:650)

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

at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:237)

at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:262)

at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:231)

at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:80)

... 21 more

Hibernate:

/* insert for

hellojpa.Member */insert

into

Member (name, id)

values

(?, default)

8월 21, 2024 7:27:31 오후 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

WARN: SQL Error: 42104, SQLState: 42S04

8월 21, 2024 7:27:31 오후 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions

ERROR: Table "MEMBER" not found (this database is empty); SQL statement:

/* insert for hellojpa.Member */insert into Member (name,id) values (?,default) [42104-224]

8월 21, 2024 7:27:31 오후 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PoolState stop

INFO: HHH10001008: Cleaning up connection pool [jdbc:h2:tcp://localhost/~/test]

Process finished with exit code 0