Spring Boot+PostgreSQL中Products表外键约束违反问题求助

DevOps 小满

2026-7-26

问题

基于Spring Boot开发API时，新增Order模型后出现数据库错误，删除所有表重新初始化后，请求Product模型时触发如下错误：

2023-03-27T15:00:48.189-03:00  WARN 31677 --- [nio-8011-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2023-03-27T15:00:48.190-03:00 ERROR 31677 --- [nio-8011-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: insert or update on table "products" violates foreign key constraint "fkselc31gul05wygg2llkv0v3yb"
  Detail: Key (product_id)=(9c2655d0-c5a4-45f1-ba97-8b5fe1a385d8) is not present in table "orders".
2023-03-27T15:00:48.231-03:00  INFO 31677 --- [nio-8011-exec-6] o.h.e.j.b.internal.AbstractBatchImpl     : HHH000010: On release of batch it still contained JDBC statements

尝试过删除所有表、新建数据库，问题依旧。

OrderModel代码

package com.api.business_manager_api.Models;

import jakarta.persistence.*;

import java.util.List;
import java.util.UUID;

@Entity
@Table(name = "ORDERS")
public class OrderModel {
    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private UUID order_id;
    @ManyToOne
    @JoinColumn(name = "customer_id")
    private CustomerModel customer;
    @OneToMany
    @JoinColumn(name = "product_id")
    private List<ProductModel> products;
    @Column(nullable = false, length = 80)
    private Float totalAmount;

    public UUID getOrder_id() {
        return order_id;
    }

    public void setOrder_id(UUID order_id) {
        this.order_id = order_id;
    }

    public CustomerModel getCustomer() {
        return customer;
    }

    public void setCustomer(CustomerModel customer) {
        this.customer = customer;
    }

    public List<ProductModel> getProducts() {
        return products;
    }

    public void setProducts(List<ProductModel> products) {
        this.products = products;
    }

    public Float getTotalAmount() {
        return totalAmount;
    }

    public void setTotalAmount(Float totalAmount) {
        this.totalAmount = totalAmount;
    }
}

ProductModel代码

package com.api.business_manager_api.Models;

import com.fasterxml.jackson.annotation.JsonIgnore;
import jakarta.persistence.*;

import java.util.UUID;

@Entity
@Table(name = "PRODUCTS")
public class ProductModel {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private UUID product_id;

    @Column(nullable = false, length = 80)
    private String product;
    @Column(nullable = true, length = 200)
    private String image_url;
    @Column(nullable = true, length = 80)
    private String brand;
    @Column(nullable = true, length = 80)
    private String description;
    @Column(nullable = true, length = 80)
    private Float price;

    @Column(nullable = true, length = 80)
    private Float extraPrice;

    @Column(nullable = false, length = 80)
    private Integer stock;
    @JsonIgnore
    @ManyToOne
    @JoinColumn(name = "category_id")
    private CategoryModel productCategory;

    public UUID getProduct_id() {
        return product_id;
    }

    public void setProduct_id(UUID product_id) {
        this.product_id = product_id;
    }

    public String getProduct() {
        return product;
    }

    public void setProduct(String product) {
        this.product = product;
    }

    public String getImage_url() {
        return image_url;
    }

    public void setImage_url(String image_url) {
        this.image_url = image_url;
    }

    public String getBrand() {
        return brand;
    }

    public void setBrand(String brand) {
        this.brand = brand;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Float getPrice() {
        return price;
    }

    public void setPrice(Float price) {
        this.price = price;
    }

    public Integer getStock() {
        return stock;
    }

    public void setStock(Integer stock) {
        this.stock = stock;
    }

    public CategoryModel getProductCategory() {
        return productCategory;
    }

    public void setProductCategory(CategoryModel productCategory) {
        this.productCategory = productCategory;
    }

    public Float getExtraPrice() {
        return extraPrice;
    }

    public void setExtraPrice(Float extraPrice) {
        this.extraPrice = extraPrice;
    }
}

Postman返回数据

{
    "order_id": "982f2270-28fa-4dcf-ba24-89b2c9f18bb5",
    "customer": {
        "customer_id": "c33d4cf7-a931-4818-8d86-94b6c56b9426",
        "name": "Antoni Ancelotti",
        "description": "italian",
        "cellphone": "21 8494944",
        "email": "ancelotti@email.com",
        "note": "ok"
    },
    "products": [
        {
            "product_id": "47b0a1ff-71e7-4b08-a243-9cf01ff55af7",
            "product": null,
            "image_url": null,
            "brand": null,
            "description": null,
            "price": null,
            "extraPrice": null,
            "stock": null
        },
        {
            "product_id": "47b0a1ff-71e7-4b08-a243-9cf01ff55af7",
            "product": "Galaxy A13 128 GB Slim",
            "image_url": "/products/images/e40989d2-66g8-4531-be26-00c124a8dfd6-SM-A136UZRAATT-8.webp",
            "brand": null,
            "description": "galaxy",
            "price": 50.0,
            "extraPrice": null,
            "stock": 50
        }
    ],
    "totalAmount": 1800.0
}

问题分析与解决方案

核心问题

错误根源是OrderModel中的一对多关联映射配置逻辑颠倒：

你在OrderModel的@OneToMany注解上使用@JoinColumn(name = "product_id")，会让Hibernate在products表创建外键product_id，指向orders表的order_id字段。
但业务逻辑是一个订单对应多个产品，正确的外键应该是products表存在order_id字段，指向orders表的order_id，而非用product_id关联订单。
所以操作Product时，数据库会检查当前Product的product_id是否在orders表中存在，完全不符合逻辑，触发外键约束错误。

修复方案

方案一：配置双向关联（推荐）

修改OrderModel的一对多关联，指定关联由Product端维护：

@Entity
@Table(name = "ORDERS")
public class OrderModel {
    // 其他字段不变
    @OneToMany(mappedBy = "order", cascade = CascadeType.ALL)
    private List<ProductModel> products;
    // 其他getter/setter不变
}

在ProductModel中添加多对一关联，维护外键：

@Entity
@Table(name = "PRODUCTS")
public class ProductModel {
    // 其他字段不变
    @JsonIgnore
    @ManyToOne
    @JoinColumn(name = "order_id")
    private OrderModel order;
    
    // 添加对应的getter和setter
    public OrderModel getOrder() {
        return order;
    }

    public void setOrder(OrderModel order) {
        this.order = order;
    }
    // 其他getter/setter不变
}

方案二：配置单向一对多关联

如果不需要双向关联，仅在Order端维护关联，修改OrderModel的关联配置：

@Entity
@Table(name = "ORDERS")
public class OrderModel {
    // 其他字段不变
    @OneToMany
    @JoinColumn(name = "order_id") // 指定外键为products表中的order_id
    private List<ProductModel> products;
    // 其他getter/setter不变
}

后续操作

重新初始化数据库：删除所有表，或设置spring.jpa.hibernate.ddl-auto=create-drop启动项目自动生成正确表结构。
检查请求数据：Postman返回的products列表存在重复product_id，确保请求的产品数据合法有效，避免重复或无效ID。

内容的提问来源于stack exchange，提问作者Routfin

Spring Boot+PostgreSQL中Products表外键约束违反问题求助

问题 #

OrderModel代码 #

ProductModel代码 #

Postman返回数据 #

问题分析与解决方案 #

核心问题 #

修复方案 #