Newbie - Join Problem

ehandbury · **Joined:** Mon Jun 22, 2009 8:41 am **Posts:** 3

private static final String EJBQL = "from Student as student left join student.Person";

The above join syntax is generating errors, I don't know how to correct it. Below is my classes. Thanks for any help.

public class Student implements java.io.Serializable {
private int studentkey;
private int status;
public Student() {}

@OneToOne (optional=false, cascade=CascadeType.ALL)
@JoinColumn(name="MASTERKEY", unique=true, nullable=false, insertable=true, updatable=true)
private Person person;
/* setters-getters */
}
public class Person implements java.io.Serializable {
private int personkey;
private String lname;
private String fname;

@OneToOne (optional=false, mappedBy="person")
private Student student;
/* setters-getters */
}

andydale · **Posted:** Mon Jun 22, 2009 9:22 am

try changing

Code:

private static final String EJBQL = "from Student as student left join student.Person";

to

Code:

private static final String EJBQL = "from Student as student left join student.person";

Cheers,

Andy