@ManyToOne mapping question

[Matthew Snow]

This is a watered down version of my code (excuse and simple syntax errors).

@Entity (name="EMPL_TBL")
@NamedQueries ({
@NamedQuery (name=Employee.QUERY_GET_EMPLOYEES_WITH_TIMEENTRIES, 
query="select e " +
"from Empl_Tbl e " +
"join e.timeEntries t" +
"where t.date between to_date(:startDate, 'MM/DD/YYYY') and to_date(:endDate, 'MM/DD/YYYY')"),
})
public class Employee {
public static final String QUERY_GET_EMPLOYEES_WITH_TIMEENTRIES = "getEmployeesWithTimeEntries";
 
@Id
private String emplid;

@OneToMany
@JoinColumn (name="emplid")
private List<TimeEntry> timeEntries;

@Column
private String name;
}

@Entity (name="Time_Ent_Tbl")
@NamedQueries ({
@NamedQuery (name=TimeEntry.QUERY_GET_TIMEENTRIES_BY_DATE, 
query="select t " +
"from Time_Ent_Tbl t " +
"where emplid = :emplid " +
"and t.date between to_date(:startDate, 'MM/DD/YYYY') and to_date(:endDate, 'MM/DD/YYYY')"),
})
public class TimeEntry {
public static final String QUERY_GET_TIMEENTRIES_BY_DATE = "getTimeEntriesByDate";
 
@Id
private String emplid;

@ManyToOne
private Employee employee;

@Column
private String date;
@Column
private String time;
@Column
private String type;
}

The named query of the Employee entity works just fine, but when I try to create the named query for TimeEntry, I get this error:

java.sql.SQLException: ORA-00904: "TIMEENTRY0_"."EMPLOYEE_EMPLID": invalid identifier

I know this has to do with the annotations I use to map these two together. I've been playing around with different configuration, but I keep getting this error:

org.hibernate.MappingException: Repeated column in mapping for entity: egg.myapp.payroll.model.TimeEntry column: emplid (should be mapped with insert="false" update="false")

and I don't see how to define these attributes. I am in no way saying that the configuration I have is the best way to do this. Any help would be appreciated.

[Matthew Snow]

Resolution

Change the @OneToMany mapping in Employee to:
    @OneToMany  (mappedBy="employee")
    private List<TimeEntry> timeEntries;
 
Change the @ManyToOne mapping in TimeEntry to:
    @ManyToOne
    @JoinColumn (name="emplid", insertable=false, updatable=false)
    private Employee employee;