How to apply default constraint for Entity- Bean @OneToMany Relationships

Question

I have two entity models: Customer and Order. Each customer can have thousands of orders. I have a OneToMany and ManyToOne relationship between these two objects.

How to limit this list of relationships to only the top 10 orders?

Can the WHERE clause be applied as an attribute on @OneToMany or not?

Like:

@OneToMany("Where Order.orderNo > 100")

My problem is that the object created by Entity Manager, all Orders are created in memory. Lazy loading cannot solve my consideration, because I need to get the top 10 orders by default.

Answer 1

, "" @OneToMany ?

JPA. . , Hibernate @Where:

@OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER)
@Where(clause="1=1")
public Set<Ticket> getTickets() {
    return tickets;
}

• Hibernate Annotations
  • 2.4.6. ,

Answer 2

JPA . EclipseLink .

, http://wiki.eclipse.org/EclipseLink/Examples/JPA/MappingSelectionCriteria