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.