Using JSF with Entity Relationships - EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g - page 323

public void setId(String id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
@ManyToOne(cascade = { CascadeType.MERGE, CascadeType.PERSIST,
CascadeType.REFRESH }, fetch = FetchType.EAGER)
@JoinTable(name = "Section_Article", joinColumns = {
@JoinColumn(name = "section_id",
referencedColumnName = "id") },
inverseJoinColumns = {
@JoinColumn(name = "article_id",
referencedColumnName = "id") })
public Section getSection() {
return section;
}
public void setSection(Section section) {
this.section = section;
}
@ManyToOne(cascade = { CascadeType.MERGE, CascadeType.PERSIST,
CascadeType.REFRESH }, fetch = FetchType.EAGER)
@JoinTable(name = "Edition_Article", joinColumns = {
@JoinColumn(name = "edition_id",
referencedColumnName = "id") },
inverseJoinColumns = {
@JoinColumn(name = "article_id",
referencedColumnName = "id") })
public Edition getEdition() {
return edition;
}
public void setEdition(Edition edition) {
this.edition = edition;
}
}
You may build the queries using the TopLink/Eclipse Link editing facilities, which
you can access from the persistence.xml file.