EJB3 Help needed: @PrimaryKeyJoinColumn not working
I have to tables (FIELD and FIELDACCESS) in our DB that share the same
primary key. There is a one-to-one relationship from FIELD to
FIELDACCESS. I've read two accounts of how to setup the annotations
to get this relationship to work but I haven't been able to get either
of them to work. In both cases I have the same problem but I will
only present one case here.
The following is how "EJB3 In Action" says to do it:
@Entity
@Table(name = "FIELDNAME")
public class Field implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column(name = "fieldid")
protected long oid;
@OneToOne
@PrimaryKeyJoinColumn
protected FieldAccess fieldAccess;
}
@Entity
@Table(name = "FIELDACCESS")
public class FieldAccess implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column (name = "fieldid")
private long oid;
public long getOid() {
return this.oid;
}
}
The problem I'm having is with the "@OneToOne" annotation in Field. I
get the error "Join column 'fieldAccess_fieldid' cannot be resolved".
However, it appears to me that "fieldid" does exist in FieldAccess.
Could someone tell me what I'm doing wrong?
Thanks,
Dave.