如何避免使用外键持久化对象时出现JavaEE/JPA错误

Question

当前在java EE中创建@JoinColumn时遇到问题，其中新列是导致运行时错误的对象。对象主要由字符串和整数组成。我不确定，但我相信外键是持久的，创建的列比我专门为它创建的列多。有什么方法可以解决这个问题吗？以下是错误。

[EL Warning]: 2020-09-04 01:14:18.148--ServerSession(843512726)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 14.
Error Code: 30000
Call: CREATE TABLE ORDER (ID BIGINT NOT NULL, ORDERDESCRIPTION VARCHAR(2000), TIMECREATED TIME, CAR_ID BIGINT, PRIMARY KEY (ID))
Query: DataModifyQuery(sql="CREATE TABLE ORDER (ID BIGINT NOT NULL, ORDERDESCRIPTION VARCHAR(2000), TIMECREATED TIME, CAR_ID BIGINT, PRIMARY KEY (ID))")
[EL Warning]: 2020-09-04 01:14:18.163--ServerSession(843512726)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 13.
Error Code: 30000
Call: ALTER TABLE ORDER ADD CONSTRAINT FK_ORDER_CAR_ID FOREIGN KEY (CAR_ID) REFERENCES CAR (ID)
Query: DataModifyQuery(sql="ALTER TABLE ORDER ADD CONSTRAINT FK_ORDER_CAR_ID FOREIGN KEY (CAR_ID) REFERENCES CAR (ID)")

这是代码：

@Entity
@NamedQueries({
@NamedQuery(name = "findAllCustomers", query = "SELECT c FROM Customer c"),
@NamedQuery(name = "findCustomerByName", query = "SELECT c FROM Customer c WHERE c.firstName = :firstName AND c.lastName = :lastName"),
})
public class Customer implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
private String firstName;
private String lastName;
private String officePhone;
private String mobile;
private String email;

@JoinColumn
@OneToMany(fetch = FetchType.EAGER, cascade=CascadeType.ALL)
private List<Order> orders = new ArrayList<Order>();
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getOfficePhone() {
return officePhone;
}
public void setOfficePhone(String officePhone) {
this.officePhone = officePhone;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public List<Order> getOrders() {
return orders;
}
public void setOrders(List<Order> orders) {
this.orders = orders;
}

@Override
public String toString() {
return "ass2.Customer[ id=" + id + " firstName=" + firstName + " lastName=" + lastName + " officePhone=" + officePhone + " mobile=" + mobile + " email=" + email + " orders=" + orders + " ]";
}
}

Answer 1

Order是一个保留的SQL关键字，您需要为Order类设置一个不同的表名，例如：

@Table(name = "client_order")
public class Order { ...