JPA列不存在

我有一個物體B，其中包含一個物體映射，<VC, P>其中P，例如 中的某些欄位A未與我的連接表鏈接并給出錯誤：

PSQLException：錯誤：列pricing1_.pricing_a 不存在

我試圖做到這一點，當我堅持我的主要物體時，B我的地圖中的所有物體也將一次性保存（如果可能的話）。

當我這樣做時會發生此錯誤

bRepo.save(b);

和

pRepo.saveAll(b.getPricing().values()); // by here the values at least exists in its own table (p)
bRepo.save(b);

這是我所擁有的

主要物體B

@Setter
@Getter
@Entity
@Table(name = "b")
public class B implements Serializable {

  @Id
  @Column(nullable = false)
  private String name;

  @OneToMany(cascade = CascadeType.ALL)
  @JoinTable(
          name = "b_p",
          joinColumns = @JoinColumn(name = "b_name", referencedColumnName = "name"))
  @MapKeyJoinColumns({
          @MapKeyJoinColumn(name = "p_c"),
          @MapKeyJoinColumn(name = "c_id")
  })
  private Map<VC, P> pricing = new LinkedHashMap<>();

  ...
}

該pricing地圖密鑰

@Setter
@Getter
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "v_c")
public class VC implements Serializable {

  @EmbeddedId private VCId vcId;
}

及其（VC）復合鍵

@Setter
@Getter
@NoArgsConstructor
@AllArgsConstructor
@Embeddable
public class VCId implements Serializable {

  @Enumerated(EnumType.STRING)
  @Column(name = "p_c")
  private PC pC;

  @Column(name = "c_id")
  private String cId;
}

定價地圖的價值

@Setter
@Getter
@NoArgsConstructor
@AllArgsConstructor
@Embeddable
@Entity
@Table(name = "p")
public class P implements Serializable {

  @EmbeddedId private PId pId;
}

和它的 (P) 鍵

@Setter
@Getter
@NoArgsConstructor
@Embeddable
public class PId implements Serializable {

  @Column(name = "a")
  private BigDecimal a; // complains about this field

  @Column(name = "d_a")
  private BigDecimal dA; // and will probably complain about this one too
}

我的桌子

CREATE TABLE b
(
    name   VARCHAR(100) NOT NULL PRIMARY KEY,
    ...
);

CREATE TABLE v_c
(
    p_c   TEXT         NOT NULL,
    c_id  VARCHAR(50)  NOT NULL,

    PRIMARY KEY (p_c, c_id)
);

CREATE TABLE p
(
    a       NUMERIC      NOT NULL,
    d_a     NUMERIC      NOT NULL DEFAULT 0.0,

    PRIMARY KEY (a, d_a)
);

CREATE TABLE b_p
(
    b_name     VARCHAR(100) NOT NULL,
    p_c        TEXT         NOT NULL,
    c_id       VARCHAR(50)  NOT NULL,
    a          NUMERIC      NOT NULL,
    d_a        NUMERIC      NOT NULL DEFAULT 0.0,

    PRIMARY KEY (b_name, p_c, c_id),
    
    FOREIGN KEY (b_name) REFERENCES b (name) ON DELETE CASCADE,
    FOREIGN KEY (p_c, c_id) REFERENCES v_c (p_c, c_id) ON DELETE CASCADE,
    FOREIGN KEY (a, d_a) REFERENCES p (a, d_a) ON DELETE CASCADE
);

我究竟做錯了什么？

uj5u.com熱心網友回復：

最后，我進行了以下更改，并且奏效了：

用自動增量 id替換 和 的復合 id，p并在我的表中v_c添加了另一個新的自動增量欄位：pricing_p_idb_p

CREATE TABLE v_c
(
    vc_id               BIGSERIAL    NOT NULL PRIMARY KEY,
    p_c   TEXT          NOT NULL,
    coin_id             VARCHAR(50)  NOT NULL
);

CREATE TABLE p
(
    p_id                BIGSERIAL    NOT NULL PRIMARY KEY,
    a                   NUMERIC      NOT NULL,
    d_a                 NUMERIC      NOT NULL DEFAULT 0.0,
    vc_id               BIGSERIAL,

    FOREIGN KEY (vc_id) REFERENCES v_c(vc_id) ON DELETE CASCADE
);

CREATE TABLE b_p
(
    b_name              VARCHAR(100)    NOT NULL,
    vc_id               BIGSERIAL       NOT NULL,
    pricing_p_id        BIGSERIAL       NOT NULL,

    PRIMARY KEY (b_name, vc_id, pricing_p_id),

    FOREIGN KEY (b_name) REFERENCES b (name) ON DELETE CASCADE,
    FOREIGN KEY (vc_id) REFERENCES v_c (vc_id) ON DELETE CASCADE,
    FOREIGN KEY (pricing_p_id) REFERENCES p (p_id) ON DELETE CASCADE
);

然后將定價欄位的映射更新為僅如下所示：

  @OneToMany(cascade = CascadeType.ALL)
  @MapKeyJoinColumn(name = "vc_id") // this
  private Map<VC, P> pricing = new LinkedHashMap<>();

標籤：爪哇 PostgreSQL jpa 弹簧数据-jpa

上一篇：嘗試使用JPA連接到Java中的DockerisedDB2時，物體管理器為空，也使用maven和OpenLiberty

下一篇：如何使用Junit和Mockito捕獲JDBCConnectionException？