環境：
- 老板 7.2
- 爪哇 11
- 休眠
使用 java 屬性映射資料庫欄位時一定是某種錯誤，它將前綴 OFERTA_ 添加到 OFT_ID（主鍵），但我看不出這是在哪里發生的。
Oferta 1->N OfertaInscripcio
錯誤ORA-00904：“OFERTA_OFT_ID”：識別符號無效
它應該只是 OFT_ID
任何想法？
日志錯誤
...
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "OFERTA_OFT_ID": invalid identifier
...
Caused by: Error : 904, Position : 275, Sql = insert into AF_OFE_OFERTA_INSCRIPCIO (CREATEDAT, UPDATEDAT, oferta_OFT_ID,...ID) values (:1 , ... , :29 ), OriginalSql = insert into AF_OFE_OFERTA_INSCRIPCIO (CREATEDAT, UPDATEDAT, ...oferta_OFT_ID, ..., ID) values (?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-00904: "OFERTA_OFT_ID": invalid identifier
...
奧費爾塔
@Entity
@Table(name = "AF_OFE_OFERTA")
public class Oferta implements Serializable {
...
@Id
@Column(name = "OFT_ID")
@SequenceGenerator(name = "AF_OFERTA_GENERATOR", sequenceName = "AF_OFERTA_SEQ", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "AF_OFERTA_GENERATOR")
private Long id;
@OneToMany(mappedBy = "oferta", cascade = CascadeType.ALL, orphanRemoval = true)
private List<OfertaInscripcio> inscripcions = new ArrayList<>();
...
Oferta Inscipcio
@Entity
@Table(name = "AF_OFE_OFERTA_INSCRIPCIO")
public class OfertaInscripcio implements Serializable {
...
@Id
@Column(name = "ID")
@SequenceGenerator(name = "AF_OFERTAI_GENERATOR", sequenceName = "AF_OFERTAI_SEQ", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "AF_OFERTAI_GENERATOR")
private Long id;
@ManyToOne(fetch = FetchType.LAZY)
private Oferta oferta;
@Column(name = "OFERTAID", insertable = false, updatable = false)
private Long idOferta;
...
uj5u.com熱心網友回復：
您必須輸入指定列名@Joincolumn的欄位。oferta如果沒有，則通過變數名檢索名稱。
@Entity
@Table(name = "AF_OFE_OFERTA_INSCRIPCIO")
public class OfertaInscripcio implements Serializable {
@Id
@Column(name = "ID")
@SequenceGenerator(name = "AF_OFERTAI_GENERATOR", sequenceName = "AF_OFERTAI_SEQ", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "AF_OFERTAI_GENERATOR")
private Long id;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "OFERTAID", referencedColumnName = "OFT_ID")
private Oferta oferta;
@Column(name = "OFERTAID", insertable = false, updatable = false)
private Long idOferta;
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/437818.html