java - 使用 Postgres 通过 JDBC 语句执行 DDL 时出现休眠错误

问题描述

我的实体有点麻烦（使用 Spring-boot）。我似乎无法理解可能是什么问题。hibernate 找不到实体之间的关系的原因可能是什么？

尝试运行应用程序时出现以下异常：

Error executing DDL "alter table order_barcode drop constraint FK16yppq17qkt9vaiw536c468xq" via JDBC Statement
Caused by: org.postgresql.util.PSQLException: ERROR: relation "order_barcode" does not exist
Error executing DDL "alter table "orders" drop constraint FK7nkj808174vaoen3hn8lp39i6" via JDBC Statement
ERROR: relation "orders" does not exist
ERROR: relation "order_ticket" does not exist

实体

@Entity
@Table(name="\"orders\"")
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class Order {

    public enum OrderStatus {
     
        INITIALIZED("initialized"),
        COMPLETE("complete"),
        FAILED("failed");

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

  
    @NotNull
    @Enumerated(EnumType.STRING)
    private OrderStatus status;

    @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL, orphanRemoval = true)
    @JoinColumn(name = "order_id")
    private Set<OrderTicket> tickets;

    @OneToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    private OrderPayment payment;
}

@Entity
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class OrderBarcode {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY) 
    private Long id;

    private String barcode;
}

@Entity
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class OrderPayment {

    public enum PaymentStatus {
        INITIALIZED("initialized"),
        AUTHORIZED("authorized"),

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY) 
    private Long id;

    @NotNull
    @Enumerated(EnumType.STRING)
    private PaymentStatus status;
}

@Entity
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class OrderTicket {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY) 
    private Long id;

    private Long templateId;
   
    @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    @JoinColumn(name = "ticket_id")
    private Set<OrderBarcode> barcodes;
}

配置

spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/test
    username: ${DATABASE_USERNAME}
    password: ${DATABASE_PASSWORD}
    driver-class-name: org.postgresql.Driver
  jpa:
    hibernate:
    database-platform: org.hibernate.dialect.PostgreSQL82Dialect
      ddl-auto: create-drop
      # ddl-auto: update
    properties:
      hibernate:
       connection:
          characterEncoding: utf-8
          CharSet: utf-8
          useUniCode: true
       show-sql: false
        hbm2ddl:
          import_files: sql/import.sql
          import_files_sql_extractor: org.hibernate.tool.hbm2ddl.MultipleLinesSqlCommandExtractor

标签： javapostgresqlspring-boothibernatespring-data-jpa

java - 使用 Postgres 通过 JDBC 语句执行 DDL 时出现休眠错误

问题描述

解决方案

推荐阅读