我有以下物體：
@Entity
@Getter
@Setter
@Table(name = "nomenclature", schema = "public")
public class Nomenclature implements Serializable {
@Id
@Column(name = "id")
private Long id;
@Column(name = "name")
private String name;
@OneToMany
@JoinTable(name="nomenclature_versions",
joinColumns= @JoinColumn(name="nomenclature_id", referencedColumnName="id"))
private List<NomenclatureVersion> version;
}
和
@Entity
@Setter
@Getter
@Table(name = "nomenclature_versions", schema = "public")
@NoArgsConstructor
public class NomenclatureVersion implements Serializable {
@Id
@Generated(GenerationTime.INSERT)
@Column(name = "id")
private Long id;
@Column(name = "nomenclature_id")
private Long nomenclatureId;
@Column(name = "user_id")
private Long userId;
@Column(name = "creation_date")
private LocalDateTime creationDate;
@Column(name = "puls_code")
private String pulsCode;
@Column(name = "pic_url")
private String picUrl;
@Column(name = "current")
private boolean current;
}
當我嘗試使用 JPARepository getById(id) 方法獲取命名法時，我得到了 org.postgresql.util.PSQLException: ERROR: column version0_.version_id does not exist
感覺問題出在Hibernate Naming Strategies，但我無法解決。
有沒有其他方法可以讓 Hibernate 知道它應該使用哪一列來連接表？
uj5u.com熱心網友回復：
不要使用@JoinTable，該表與您參考的物體相同。您只需指定@JoinColumn，hibernate 將在表中查找您將串列映射到的物體所參考的列，NomenclatureVersion：
@OneToMany
@JoinColumn(name="nomenclature_id")
private List<NomenclatureVersion> version;
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/413713.html
標籤：