전체 글 6

6단계: SQL Error: 1052, SQLState: 23000 Column 'is_deleted' in field list is ambiguous

[문제]    [원인] [해결]package com.example.plan.plan5.repository;import com.example.plan.plan5.entity.Plan;import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.data.jpa.repository.Modifying;import org.springframework.data.jpa.repository.Query;import org.springframework.http.HttpStatus;import org.springframework.transaction.annotation.Transactional;import org.springfr..

7단계: SQL Error: 1048, SQLState: 23000 Column 'member_id' cannot be null

[문제]  [원인] package com.example.plan.note7.entity;import com.example.plan.common.entity.BaseEntity;import com.example.plan.member7.entity.Member;import com.example.plan.plan7.entity.Plan;import jakarta.persistence.*;import lombok.Getter;import lombok.Setter;import org.hibernate.annotations.Comment;/** * 댓글 C 완료 * * * * */@Getter@Entity@Table(name = "notes7")public class Note extends BaseEntity { ..

6단계:Query did not return a unique result: 2 results were returned (2)

[문제] [원인]  [해결]package com.example.plan.member5.entity;import com.example.plan.common.entity.BaseEntity;import jakarta.persistence.*;import lombok.Getter;import org.hibernate.annotations.Comment;@Getter@Entity@Table(name = "members5")public class Member extends BaseEntity { // 속성 @Comment("사용자 식별자") @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(columnDefinition =..

카테고리 없음 2025.03.17

6단계: SQL Error: 1406 Data truncation: Data too long for column 'password' at row 1

[문제]   [원인]   [해결]package com.example.plan.member5.entity;import com.example.plan.common.entity.BaseEntity;import jakarta.persistence.*;import lombok.Getter;import org.hibernate.annotations.Comment;@Getter@Entity@Table(name = "members5")public class Member extends BaseEntity { // 속성 @Comment("사용자 식별자") @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(columnDefinitio..

6단계: SQL Error: 1406 Data truncation: Data too long for column 'password' at row 1

[문제]   [원인]   [해결]package com.example.plan.member5.entity;import com.example.plan.common.entity.BaseEntity;import jakarta.persistence.*;import lombok.Getter;import org.hibernate.annotations.Comment;@Getter@Entity@Table(name = "members5")public class Member extends BaseEntity { // 속성 @Comment("사용자 식별자") @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(columnDefinitio..

알림 기능 찾아 삼만리 - 3시간 동안 지옥에 갔다 온 이야기

더보기package com.project.cheerha.domain.notification.dto;import com.querydsl.core.annotations.QueryProjection;/** * 이메일 알림을 받을 사용자 정보를 담은 DTO * @param keywordId: 사용자가 선택한 기술 키워드 ID * @param email: 사용자의 이메일 */public record NotificationRecipientDto( Long keywordId, String email) { @QueryProjection public NotificationRecipientDto { }}더보기package com.project.cheerha.domain.notification.r..