创建表时出现JPA/EclipseLink错误

Question

我正在尝试使用EclipseLink创建一个表。正在使用的java类是：-

import java.util.Date;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Id;

@Entity
public class Submissions {

 @Id
 @GeneratedValue(strategy = GenerationType.IDENTITY)
 private Long Id;
 private String XID;
 private String Y;
 @Temporal(TemporalType.DATE)
 private Date uDate;
 private String level;
 private String state;

 public Submissions() {
 }

 //All Relevant getter and setter functions
}

<persistence-unit name="SubmissionIds">
    <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
    <class>com.obp.selenium.DataObjects.OriginationSubmissions</class>
    <properties>

        <property name="javax.persistence.jdbc.driver" value="oracle.jdbc.OracleDriver" />
        <property name="javax.persistence.jdbc.url"
            value="jdbc:oracle:thin:@localhost:1521:orcl" />
        <property name="javax.persistence.jdbc.user" value="------" />
        <property name="javax.persistence.jdbc.password" value="------" />

        <!-- EclipseLink should create the database schema automatically -->
        <property name="eclipselink.ddl-generation" value="create-tables" />
        <property name="eclipselink.ddl-generation.output-mode"
            value="database" />
        <!-- <property name="eclipselink.canonicalmodel.subpackage"
            value="originationSubmissions" /> -->
    </properties>
</persistence-unit>

EntityManagerFactory factory = Persistence.createEntityManagerFactory("SubmissionIds");
    EntityManager em = factory.createEntityManager();
    em.getTransaction().begin();
    em.getTransaction().commit();
    em.close();

EL警告]:2017-04-07 14:04:53.768--ServerSession(1650327539)--异常[EclipseLink-4002]（Eclipse持久性服务-2.6.3.v20160428-59C81C5):org.Eclipse.Persistence.exceptions.DatabaseException内部异常：java.sql.sqlsyntaxerrorexception：ora-00904::无效标识符

错误代码：904调用：CREATE TABLE SUBMISSIONS（ID NUMBER（19）NOT NULL,XID VARCHAR2(255)NULL,YVarchar2(255)NULL,LEVEL VARCHAR2(255)NULL,STATE VARCHAR2(255)NULL,UDATE DATE NULL,PRIMARY KEY(ID)）查询：DataModifyQuery(sql=“CREATE TABLE SUBMISSIONS（ID NUMBER（19）NOT NULL,XID VARCHAR2(255)NULL,YVarchar2(255)NULL,LEVEL VARCHAR2(255)NULL,LEVEL

Answer 1

实际上，Eclipse报告了一个bug，当使用保留词时会出现这个bug，您可以在这里进行处理：
https://bugs.Eclipse.org/bugs/show_bug.cgi？id=260637。

问题来自于使用一个保留词我实际上不知道您的DBMS，如果它是Mysql，您的属性XID和LEVEL是一个保留词。您可以在这里找到mysql保留字:https://dev.mysql.com/doc/refman/5.7/en/keywords.html。

您还可以从用于构建表的sql代码中发现有一个类型为DATE的列名更新

UDATE日期为空

所以依我之见，你也需要注意你在uDate上的名字