如何修复“字段列表”中的未知列ERROR Glassfish服务器

Question

你们能看到我的代码有什么问题吗，我正在尝试将经理数据持久化到数据库中，但是，它说：“字段列表”中的未知列“EMAIL”。

错误:

引起原因:javax . Persistence . Persistence Exception:Exception[Eclipse link-4002](Eclipse Persistence Services-2 . 7 . 0 . v 2017 08 11-d 680 af 5):org . Eclipse . Persistence . exceptions . database Exception内部异常:Java . SQL . sqlsyntaxerrorexception:“字段列表”中的未知列“EMAIL”错误代码:1054调用:INSERT INTO MANAGER (ID，EMAIL，FIRSTNAME，LASTNAME，PHONENUMBER)值(？, ?, ?, ?, ?)绑定=

Manager.java

@Entity
@NamedQueries({
@NamedQuery(name= "viewManager", query ="select m from Manager m where m.id = :id"),
@NamedQuery(name= "findManager", query ="select m from Manager m where m.firstName = :firstName and m.lastName = :lastName"),
@NamedQuery(name= "findAllManager", query ="select m from Manager m"),
})
public class Manager implements Serializable{

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    private String firstName;
    private String lastName;
    private String phoneNumber;
    private String email;
    @OneToMany(
    cascade = CascadeType.ALL,
        orphanRemoval = true)
    @JoinColumn(name="manerger_fk")
    private List<Allocation> allocation;

    public Manager() {
    }

    public Manager( String firstName, String lastName, String phoneNumber, String email, List<Allocation> allocation) {
        this.firstName = firstName;
        this.lastName = lastName;
        this.phoneNumber = phoneNumber;
        this.email = email;
        this.allocation = allocation;
    }

    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 getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(String phoneNumber) {
        this.phoneNumber = phoneNumber;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public List<Allocation> getAllocation() {
        return allocation;
    }

    public void setAllocation(List<Allocation> allocation) {
        this.allocation = allocation;
    }
    
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    
}

我还添加了@Column（name=“accountid”，nullable=false，unique=true）但似乎没有用。

Answer 1

解决了 我将持久化中的模式生成.xml从“创建”更改为“拖放创建”，它的工作原理。