JPA 날짜 넣기

Question

mysql이구요. dbeaver사용중입니다. project라는 테이블에 createdAt 이라는 컬럼이 datetime 으로 들어가있고 기본값은 current_timestamp 입니다. jpa로 이 테이블에 insert 하려고 하는데요, 500에러가 뜹니다.import java.time.LocalDateTime; import org.springframework.data.annotation.CreatedDate; import org.springframework.data.jpa.domain.support.AuditingEntityListener; import com.fasterxml.jackson.annotation.JsonProperty; import io.swagger.v3.oas.annotations.media.Schema; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.EntityListeners; import jakarta.persistence.GeneratedValue; import jakarta.persistence.GenerationType; import jakarta.persistence.Id; import jakarta.persistence.Table; import lombok.Getter; import lombok.NoArgsConstructor; import lombok.Setter; &#64;Table(name &#61; &#34;project&#34;) // 테이블 이름을 project로 지정 &#64;Schema(description &#61; &#34;프로젝트 정보&#34;) &#64;Getter &#64;Setter &#64;NoArgsConstructor &#64;EntityListeners(AuditingEntityListener.class) &#64;Entity public class Project{ &#64;Id &#64;GeneratedValue(strategy &#61; GenerationType.IDENTITY) &#64;Schema(description &#61; &#34;프로젝트ID&#34;) &#64;Column(name &#61; &#34;id&#34;) private Integer id; &#64;CreatedDate &#64;Column(name &#61; &#34;createdAt&#34;) private LocalDateTime createdAt; &#64;CreatedDate &#64;Column(name &#61; &#34;updatedAt&#34;) private LocalDateTime updatedAt; } 근데 이상한 오류가 떠요.2024-12-19T14:38:45.150&#43;09:00 ERROR 9740 --- [DeepInspector API Server] [io-9090-exec-10] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.orm.ObjectOptimisticLockingFailureException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.deepinspection.deepinspector.apiserver.project.Project#0]] with root cause org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.deepinspection.deepinspector.apiserver.project.Project#0] at org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:426) ~[hibernate-core-6.6.2.Final.jar:6.6.2.Final] at org.hibernate.event.internal.DefaultMergeEventListener.merge(DefaultMergeEventListener.java:214) ~[hibernate-core-6.6.2.Final.jar:6.6.2.Final] at org.hibernateSwagger로 해보면 500에러라고 뜨긴하는데, 로그를 보면 이런 말이 나오네요무슨 말인지 도통 모르겠어요. 참고로 아래 보면 MyApiServerApplication에 &#64;EnableJpaAuditing 도 붙였고,Project 클래스도 보면 &#64;EntityListeners(AuditingEntityListener.class) 붙였습니다.import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.data.jpa.repository.config.EnableJpaAuditing; &#64;SpringBootApplication &#64;EnableJpaAuditing public class MyApiServerApplication { public static void main(String[] args) { SpringApplication.run(MyApiServerApplication .class, args); } }

나는바뿌다 · Answer

@CreatedDate @Column(name = "updatedAt") private LocalDateTime updatedAt;여기 때문이네요.@CreatedDate를 @UpdatedDate로 바꿔보세요

JPA 날짜 넣기

1개의 답변

Q&A 목록