Ошибка could not execute

I am developing Rest web services for two entities: patient and address. During a post request, I intend to pass the address as an object along with the patient attribute. However, I am encountering the error mentioned above.

PatientController.java

@ApiOperation(value = "Add a patient")
    @RequestMapping(value = "/patients", method= RequestMethod.POST, produces = "application/json")
    public ResponseEntity

patient.java

@Entity
@Table(name = "patients")
@JsonIgnoreProperties({"hibernateLazyInitializer", "handler"}) 
public class Patient implements Serializable {
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "patient_id", updatable = false)
    private UUID id;
    private String name;
    private String age;
    @JsonFormat(pattern="yyyy-MM-dd")
    private Date dob;
    private String occupation;
    @Enumerated(EnumType.STRING)
    private Gender gender= Gender.MALE;
    @OneToMany(mappedBy = "patient", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    private List
 address = new ArrayList<>();
    @OneToMany(mappedBy = "patient", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    private List contact;
    @OneToMany(mappedBy = "patient", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    private List references;
    public Patient() {}
    }

I encounter an error when trying to add data to the candidates table, which is an extension of the users table. The email and password columns are inherited from the users table. I suspect there may be an issue with the database, specifically with my use of postreSql. Can you help me determine the cause?

User Table

package com.example.hrmsdemo.entities.concretes;
import com.sun.istack.NotNull;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import javax.persistence.*;
@Data
@Entity
@AllArgsConstructor
@NoArgsConstructor
@Table(name="users",uniqueConstraints = {@UniqueConstraint(columnNames = {"email"})})
@Inheritance(strategy = InheritanceType.JOINED)
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @NotNull
    private int id;
    @Column(name = "email")
    @NotNull
    private String email;
    @NotNull
    @Column(name = "password")
    private String password;
}

Candidate Table

package com.example.hrmsdemo.entities.concretes;
import com.sun.istack.NotNull;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
@Table(name="candidates",uniqueConstraints = {@UniqueConstraint(columnNames = {"identity_number"})})
@EqualsAndHashCode(callSuper = true)
@Entity
public class Candidate extends User {
    @Column(name = "first_name")
    @NotNull
    private String first_name;
    @NotNull
    @Column(name = "last_name")
    private String last_name;
    @NotNull
    @Column(name = "identity_number")
    private String identity_number;
    @NotNull
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @Column(name = "birth_date")
    private Date birth_date;
}

Error

2021-05-26 15:59:53.230  WARN 24964 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23502
2021-05-26 15:59:53.230 ERROR 24964 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : HATA: null value in column "email_address" of relation "users" violates not-null constraint
  Ayrıntı: Hata veren satır (7, null, 123414, veyselhim@gmail.com) içeriyor.
2021-05-26 15:59:53.245 ERROR 24964 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [email_address" of relation "users]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause

Are you mapping

User#email

to a column called

email_address

? The database is complaining about that specific column, but you haven’t shown a mapping for it.

Given that is accurate, it appears that you have specified that this characteristic must not be empty, which aligns with the database’s definition. This indicates that you are attempting to store a User object without assigning a value to its email attribute.

It’s difficult to determine whether you haven’t mapped that column in Hibernate, which is why it never attempts to write to it. The information provided is limited, making it hard to say for sure.

During the process of writing my application, I encountered an issue when attempting to execute
SQL statement
. Despite searching online for a solution, none of the suggestions I found were helpful in resolving the error I am currently facing. To provide more context, here is the exception message I received.

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint ["FKAM8LLDERP40MVBBWCEQPU6L2S: PUBLIC.BOOK_CATEGORY FOREIGN KEY(CATEGORY_ID) REFERENCES PUBLIC.CATEGORY(ID) (2)"; SQL statement:
insert into book_category (book_id, category_id) values (?, ?) [23506-196]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

This is the appearance of the classes:
Book.class

@Entity
@Table(name = "book")
public class Book {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    @Column(nullable = false)
    private String title;
    private String description;
    @Column(name = "release_date")
    @Temporal(TemporalType.TIMESTAMP)
    private Date releaseDate;
    @JoinColumn(name = "cover_image")
    @OneToOne(cascade = CascadeType.MERGE)
    private UploadFile coverImage;
    @OneToOne(cascade = CascadeType.MERGE)
    private UploadFile content;
    @ManyToMany
    @JoinTable(name = "book_category", joinColumns = {@JoinColumn(name = "book_id", referencedColumnName = "id")},
        inverseJoinColumns = {@JoinColumn(name = "category_id", referencedColumnName = "id")})
    private Set categories;
    // constructors, setters, getters
}

Category.class

@Entity
@Table(name = "category")
public class Category {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    @Column(name = "category_name")
    private String name;
    @ManyToMany(mappedBy = "categories", fetch = FetchType.LAZY)
    private List books;
    // ...
}

There is a lack of definitions for

cascade

in your content.

The book category should be written before the referenced entity (book or category) is inserted. However, this violates the specified constraint. To resolve this issue, it is necessary to establish a definition.

cascade = CascadeType.ALL

To ensure the correct order of entity persistence, it is necessary to have consistency on both sides of the join, whether it be in books or categories.

I can effectively transition from
insert data
to
mysql database
. However, I am currently facing a challenge while migrating my database to postgresql.

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [admin_pkey]; nested exception is org.hibernate.exception.ConstraintViolationException: 
could not execute statement

«Rephrased MSDTHOT»:
Despite adding a generation_auto annotation to my id column, the error continues to persist. Here are my class mappings.

@Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "id")
    private Integer id;
    @Column(unique = true, nullable = false)
    private String name;
    @Column(unique = true, nullable = false)
    private String email;
    @Column(unique = false, nullable = false)
    private String password;
    @Column(unique = false, nullable = false)
    private Date date;
    public Integer getId() {
        return id;
    }

Modifying your database requires a corresponding update to the hibernate configuration XML. Here is the

hibernate.cfg.xml

.

    
        org.hibernate.dialect.PostgreSQLDialect
        org.postgresql.Driver
        postgres
        password
        jdbc:postgresql://localhost:5432/hibernatedb
        1
        create
        true