[OPENJPA-162] @OrderBy on @OneToMany does not allow ordering by @Id value

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.6
• Fix Version/s: 0.9.7
• Component/s: jpa
• Environment: Using PostgreSQL 8.1 as the database
• Assignee: Unassigned
• Reporter: Nick Johnson
• Created: 05/Mar/07 04:10
• Updated: 09/Mar/10 18:32
• Resolved: 05/Mar/07 20:14

Description

Using the following annotation:

@OneToMany(mappedBy="root", fetch=FetchType.LAZY)
@OrderBy("objectId ASC")
private List<Message> messages;

I get the exception "Cannot order "net.spatula.tally_ho.model.MessageRoot.messages" on "objectId", because that field is not in the default fetch group. You can only order on fields that will be selected when the related object is loaded."

I should certainly hope that the primary key of the related object is going to be selected when the object is loaded:

@Id
@Column(name = "object_id")
private long objectId;