문제의 부분
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", columnDefinition = "Long")
private Long id;
// 이렇게 해서 될줄 알았는데...
에러 메세지
22:38:15 WARN 38227 --- [main] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "
create table user (
id Long not null auto_increment,
created_at TIMESTAMP,
update_at TIMESTAMP,
email VARCHAR(50) not null,
nickname VARCHAR(50),
password VARCHAR(50) not null,
point BIGINT,
profile_image VARCHAR(50),
profile_introduce VARCHAR(50),
role VARCHAR(50) not null,
username VARCHAR(50) not null,
primary key (id)
) engine=InnoDB" via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "
create table user (
id Long not null auto_increment,
created_at TIMESTAMP,
update_at TIMESTAMP,
email VARCHAR(50) not null,
nickname VARCHAR(50),
password VARCHAR(50) not null,
point BIGINT,
profile_image VARCHAR(50),
profile_introduce VARCHAR(50),
role VARCHAR(50) not null,
username VARCHAR(50) not null,
primary key (id)
) engine=InnoDB" via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:440)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:424)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:315)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:167)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:136)
at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:122)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:164)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:81)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:327)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1498)
...
Caused by: java.sql.SQLSyntaxErrorException: Incorrect column specifier for column 'id'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
Long 값은 → BIGINT로 변경
Mysql 데이터 타입
https://blog.martinwork.co.kr/mysql/2020/01/17/mysql-data-type.html