使用JPA的持久性表示实体不存在于描述符中

Question

我们在尝试用数据库实现梯子游戏应用程序时遇到了一个问题。我们有一个名为'spill'的实体，它与另一个名为'brett'的实体有一个ManyToOne关系。

Exception [EclipseLink-93] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DescriptorException
Exception Description: The table [brett] is not present in this descriptor.
Descriptor: RelationalDescriptor(no.hib.dat101.entities.Spill --> [DatabaseTable(stigespill.spill)])

Exception [EclipseLink-41] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DescriptorException
Exception Description: A non-read-only mapping must be defined for the sequence number field.
Descriptor: RelationalDescriptor(no.hib.dat101.entities.Spill --> [DatabaseTable(stigespill.spill)])

@Entity
@Table(name="spill",schema = "stigespill")

@Entity
@Table(name="spill",schema = "stigespill")
public class Spill {

  // FELTVARIABLER
  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Integer spillid;

  private Integer ferdig;
  private Timestamp dato;

  @OneToMany(mappedBy = "spill" , cascade = CascadeType.ALL)
  private List<Spiller> spillere; // TODO Skiftet fra Queue til ArrayList

  @OneToMany(mappedBy = "spill" , cascade = CascadeType.ALL)
  private List<Trekk> trekklog;

  @ManyToOne( cascade = CascadeType.ALL)
  @JoinColumn(name = "brett", referencedColumnName="brettid", insertable = false, updatable = false)
  private Brett brett;
}

@Entity
@Table(name = "brett", schema = "stigespill")
public class Brett {

  // FELTVARIABLER
  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Integer brettid;

  @OneToMany(mappedBy = "brett", cascade = CascadeType.ALL)
  private List<Rute> ruter;
}

在过去的几个小时里，我们一直在网上搜索，试图找出这个问题，但我们找不到解决办法。

完整控制台日志：

[EL Info]: server: 2016-04-26 15:58:15.551--ServerSession(1348949648)--Detected server platform: org.eclipse.persistence.platform.server.NoServerPlatform.
[EL Warning]: metadata: 2016-04-26 15:58:15.876--ServerSession(1348949648)--The reference column name [spillid] mapped on the element [field spill] does not correspond to a valid id or basic field/column on the mapping reference. Will use referenced column name as provided.
[EL Info]: server: 2016-04-26 15:58:15.951--ServerSession(1348949648)--Detected server platform: org.eclipse.persistence.platform.server.NoServerPlatform.
[EL Info]: 2016-04-26 15:58:16.63--ServerSession(1348949648)--EclipseLink, version: Eclipse Persistence Services - 2.6.0.v20150309-bf26070
[EL Severe]: 2016-04-26 15:58:17.084--ServerSession(1348949648)--Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.IntegrityException
Exception[EclipseLink-93]（Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.DescriptoreXception
异常说明：表[brett]不存在于此描述符中。
描述符:RelationalDescriptor(No.hib.dat101.entities.spill-->[databasetable(stigespill.spill)])
Exception[EclipseLink-93]（Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.DescriptoreXception
异常说明：表[brett]不存在于此描述符中。
描述符:RelationalDescriptor(No.hib.dat101.entities.spill-->[databasetable(stigespill.spill)])
Exception[EclipseLink-41]（Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.DescriptoreXception
异常说明：必须为序号字段定义非只读映射。
描述符:RelationalDescriptor(No.hib.dat101.entities.spill-->[databasetable(stigespill.spill)])
线程“main”javax.Persistence.persistenceException:Exception[EclipseLink-28019]（Eclipse Persistence Services-2.6.0.v20150309-bf26070):org.Eclipse.Persistence.exceptions.EntityManagerSetupException
异常说明：PersistenceUnit[eclipselink]部署失败。关闭此PersistenceUnit的所有工厂。
内部异常:Exception[EclipseLink-0](Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.IntegrityException
Exception[EclipseLink-41]（Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.DescriptoreXception
异常说明：必须为序号字段定义非只读映射。
描述符:RelationalDescriptor(No.hib.dat101.entities.spill-->[databasetable(stigespill.spill)])
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.createDeployFailedPersistenceException(EntityManagerSetupImpl.java:866)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:806)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:205)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:305)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:337)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:303)
at no.hib.dat101.database.Emh.slettAlt(Emh.java:137)
at no.hib.dat101.main.Main_Tekst.main(Main_Tekst.java:12)
原因：Exception[EclipseLink-28019](Eclipse Persistence Services-2.6.0.v20150309-bf26070):org.Eclipse.Persistence.exceptions.EntityManagerSetupException
异常说明：PersistenceUnit[eclipselink]部署失败。关闭此PersistenceUnit的所有工厂。
内部异常:Exception[EclipseLink-0](Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.IntegrityException
Exception[EclipseLink-93]（Eclipse Persistence Services-2.6.0.v20150309-BF26070):org.Eclipse.Persistence.exceptions.DescriptoreXception
异常说明：表[brett]不存在于此描述符中。
描述符:RelationalDescriptor(No.hib.dat101.entities.spill-->[databasetable(stigespill.spill)])
at org.eclipse.persistence.exceptions.EntityManagerSetupException.deployFailed(EntityManagerSetupException.java:239)
... 8 more
                

Answer 1

在一个例子中，为了让@table正常工作，我还必须添加catalog。另外，我必须在@entity中命名表。尝试：

@Entity(name="spill")
@Table(name="spill",schema = "stigespill", catalog="public")

等等。