문제의 부분
@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)
해결 → Mysql에서 Long은 없다... 기본적인걸 까먹은 나(대가리 박자)...
Long 값은 → BIGINT로 변경
Mysql 데이터 타입