I'm simply trying to join two entities together w/ a @OneToOne but I'm not using primary keys on either side of the relationship.

Here are my (shortened) entities:

@Entity
@Table(name="call_req")
public class Incident implements Serializable
{
 @Column(name="status", insertable=false, updatable=false)
 private String status;

 @OneToOne(fetch=FetchType.LAZY)
 @JoinColumn(name="status", referencedColumnName="code")
 private IncidentStatus incidentStatus;
}

@Entity
@Table(name="cr_stat")
public class IncidentStatus implements Serializable
{
 @Column(name="code", nullable=false, insertable=false, updatable=false)
 private String code;

 @OneToOne
 private Incident incident;
}

Here's the EJBQL and the query that was generated:

Hibernate:
 /* select
 i
 from
 Incident i
 inner join
 fetch i.incidentStatus ist */ select
 top 50 incident0_.id as id927_0_,
 incidentst1_.id as id928_1_,
 incident0_.persid as persid927_0_,
 incident0_.ref_num as ref3_927_0_,
 incident0_.summary as summary927_0_,
 incident0_.description as descript5_927_0_,
 incident0_.status as status927_0_,
 incident0_.active_flag as active7_927_0_,
 incident0_.open_date as open8_927_0_,
 incident0_.time_spent_sum as time9_927_0_,
 incident0_.last_mod_dt as last10_927_0_,
 incident0_.close_date as close11_927_0_,
 incident0_.resolve_date as resolve12_927_0_,
 incident0_.rootcause as rootcause927_0_,
 incident0_.log_agent as log14_927_0_,
 incident0_.assignee as assignee927_0_,
 incident0_.group_id as group16_927_0_,
 incident0_.customer as customer927_0_,
 incident0_.charge_back_id as charge18_927_0_,
 incident0_.affected_rc as affected19_927_0_,
 incident0_.support_lev as support20_927_0_,
 incident0_.category as category927_0_,
 incident0_.solution as solution927_0_,
 incident0_.impact as impact927_0_,
 incident0_.priority as priority927_0_,
 incident0_.urgency as urgency927_0_,
 incident0_.severity as severity927_0_,
 incident0_.extern_ref as extern27_927_0_,
 incident0_.last_act_id as last28_927_0_,
 incident0_.cr_tticket as cr29_927_0_,
 incident0_.parent as parent927_0_,
 incident0_.template_name as template31_927_0_,
 incident0_.sla_violation as sla32_927_0_,
 incident0_.predicted_sla_viol as predicted33_927_0_,
 incident0_.created_via as created34_927_0_,
 incident0_.call_back_date as call35_927_0_,
 incident0_.call_back_flag as call36_927_0_,
 incident0_.event_token as event37_927_0_,
 incident0_.type as type927_0_,
 incident0_.change as change927_0_,
 incident0_.problem as problem927_0_,
 incident0_.incident_priority as incident41_927_0_,
 incidentst1_.persid as persid928_1_,
 incidentst1_.del as del928_1_,
 incidentst1_.sym as sym928_1_,
 incidentst1_.last_mod_dt as last5_928_1_,
 incidentst1_.description as descript6_928_1_,
 incidentst1_.code as code928_1_,
 incidentst1_.active as active928_1_,
 incidentst1_.hold as hold928_1_,
 incidentst1_.resolved as resolved928_1_,
 incidentst1_.cr_flag as cr11_928_1_,
 incidentst1_.in_flag as in12_928_1_,
 incidentst1_.pr_flag as pr13_928_1_,
 incidentst1_.incident_id as incident14_928_1_
 from
 call_req incident0_
 inner join
 cr_stat incidentst1_
 on incident0_.status=incidentst1_.code

...it's so *close* - if it wasn't creating that 'incident_id' field out of thin-air (which doesn't actually exist in the table) it would be perfect. Otherwise, the join is perfect - exactly what I needed. Of course the exception I get is:

javax.ejb.EJBException

.............

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:567)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:56)

.............

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

.............

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'incident_id'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
..............

I need Incident.status = IncidentStatus.code

I'm getting very close but I can't seem to get the right relationship. How can I simply join two entities, one-to-one, where I'm not using the primary keys in either of the two tables as part of the relationship?

Thanks very much in advance!