无法使用实体管理器插入 ORA00904

Question

我对EJB的概念非常陌生。我正在尝试使用实体类将前端的值插入到数据库中，但每次我这样做时，我都会收到此错误：

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10657)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

这是我的实体类：

@Entity
@Table(name="EMPLOYEE", schema="SYSTEM")
public class Employee {

    @Id
    @GeneratedValue(strategy=GenerationType.SEQUENCE)
    private int employeeId;
    private String employeeName;
    private int employeeAge;
    private String employeeAddress;
    private String employeePhone;
    private String employeeEmailAddress;

    @Column(name="EMPLOYEE_ID", nullable=false, insertable=true, updatable=false)
    public int getEmployeeId() {
        return employeeId;
    }
    public void setEmployeeId(int employeeId) {
        this.employeeId = employeeId;
    }

    @Column(name="EMPLOYEE_NAME", nullable=false, insertable=true, updatable=false)
    public String getEmployeeName() {
        return employeeName;
    }
    public void setEmployeeName(String employeeName) {
        this.employeeName = employeeName;
    }

    @Column(name="EMPLOYEE_AGE", nullable=false, insertable=true, updatable=false)
    public int getEmployeeAge() {
        return employeeAge;
    }
    public void setEmployeeAge(int employeeAge) {
        this.employeeAge = employeeAge;
    }

    @Column(name="EMPLOYEE_ADDRESS", nullable=false, insertable=true, updatable=false)
    public String getEmployeeAddress() {
        return employeeAddress;
    }
    public void setEmployeeAddress(String employeeAddress) {
        this.employeeAddress = employeeAddress;
    }

    @Column(name="EMPLOYEE_PHONE", nullable=true, insertable=true, updatable=true)
    public String getEmployeePhone() {
        return employeePhone;
    }
    public void setEmployeePhone(String employeePhone) {
        this.employeePhone = employeePhone;
    }

    @Column(name="EMPLOYEE_EMAIL_ADDRESS", nullable=false, insertable=true, updatable=false)
    public String getEmployeeEmailAddress() {
        return employeeEmailAddress;
    }
    public void setEmployeeEmailAddress(String employeeEmailAddress) {
        this.employeeEmailAddress = employeeEmailAddress;
    }

    public Employee(){
        super();
    }

我使用的是seam 2.2.1、EJB 3和Oracle 10g。

请帮助我解决此错误。

Answer 1

字段和访问器方法中的注释不应混合使用。根据JPA规范，后果是未定义的:

未定义在实体层次结构中的字段和属性上混合放置批注而不显式指定 Access 批注的应用程序的行为。

在Hibernate的情况下，在中观察到@Id注释，并忽略包括以下内容的方法中的注释：

@Column(name="EMPLOYEE_ID", nullable=false, insertable=true, updatable=false)

解决方案是将所有注释移动到字段（或全部移动到方法）。