如何解决@OneTomany关系中的重复列名异常

Question

我试图@JoinColumn两个实体，分别命名为Customer和Account。一个客户可以有多个帐户，所以我认为在customer实体中使用@onetomany是正确的。和帐户实体中的@manytoone。但是，它总是在控制台中给我重复的列名。可以通过更改变量名来解决这个问题，但我不能简单地更改它，因为hibernate在DB中找不到列名。即使添加@column name属性也行不通。

有什么办法可以解决这个问题吗？

null

我已经尝试了数据库中的SQL查询。查询是工作，但我不知道如何在hibernate JPA中映射它。

Oracle查询

SELECT a.USR_ID, a.USR_MGNT_NO, a.CUST_NO, a.ACCT_STATUS,
        b.ACCT_SEQ, b.ACCT_NO, b.CUST_NO, b.CUST_NM, b.SBJ_CD, b.ACCT_PRD_NM
FROM LB_USR_BASE a LEFT OUTER JOIN
 LB_ACCT_BASE b ON
a.CUST_NO=b.CUST_NO
WHERE a.USR_MGNT_NO=:usrMgtNo;

客户实体

@Entity
@Table(name = "CUSTOMER")
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor

public class Customer implements Serializable{


    private static final long serialVersionUID = 1L;

    @Id
    private String custNo;

    private String usrId;
    private String usrMgntNo;
    private String acctStatus;

    @OneToMany(cascade = CascadeType.ALL, mappedBy = "user")
    @JoinColumn(name = "custNo")
    private Set<Account> accounts = new HashSet<Account>();


}

账户实体

@Entity
@Table(name = "ACCOUNT")
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class Account {
    @Id
    private String acctId;
    private String acctNo;

    @ManyToOne
    private UsrBase user;
    private String sbjCd;
    private String custNo;

}

public interface CustAcctRepository extends JpaRepository<Customer, String>{

    List<Customer> findAcctByUsrMgntNo(String usrMgntNo);

}

List<Customer> tes = CustAcctRepo.findAcctByUsrMgntNo("12345"));

Caused by: org.hibernate.DuplicateMappingException: Table [ACCOUNT] contains physical column name [cust_no] referred to by multiple physical column names: [cust_no], [custNo]

public class Account {
    @Id
    private String acctSeq;
    private String acctNo;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "custNo",insertable = false, updatable = false)
    private UsrBase user;

}

和

public class Customer implements Serializable{


    private static final long serialVersionUID = 1L;

    @Id
    private String custNo;

    private String usrId;
    private String usrMgntNo;
    private String acctStatus;

    @OneToMany(cascade = CascadeType.ALL)
    private Set<AcctBase> accounts = new HashSet<AcctBase>();


}

Answer 1

请看，在下面的代码中，您使用两个字段创建映射:'user'和'cust no'。使用user映射或使用account.custno映射

@OneToMany(cascade = CascadeType.ALL, mappedBy = "user")
@JoinColumn(name = "custNo")
private Set<Account> accounts = new HashSet<Account>();