annotation to filter results of a @OneToMany association

by

It is not supported by JPA but if you are using hibernate as JPA provider then you can use annotation @FilterDef and @Filter.

Hibernate Core Reference Documentation

Hibernate3 has the ability to pre-define filter criteria and attach
those filters at both a class level and a collection level. A filter
criteria allows you to define a restriction clause similar to the
existing “where” attribute available on the class and various
collection elements. These filter conditions, however, can be
parameterized. The application can then decide at runtime whether
certain filters should be enabled and what their parameter values
should be. Filters can be used like database views, but they are
parameterized inside the application.

Exemple 

@Entity
public class A implements Serializable{
    @Id
    @Column(name = "REF")
    private int ref;

    @OneToMany
    @JoinColumn(name = "A_REF", referencedColumnName = "REF")   
    @Filter(name="test")
    private Set<B> bs;
}

@Entity
@FilterDef(name="test", defaultCondition="other = 123")
public class B implements Serializable{
    @Id
    @Column(name = "A_REF")
    private int aRef;

    @Id
    @Column(name = "OTHER")
    private int other;
}

Session session = entityManager.unwrap(Session.class);
session.enableFilter("test");
A a = entityManager.find(A.class, new Integer(0))
a.getb().size() //Only contains b that are equals to 123

More Related Contents:

  1. Mapping PostgreSQL JSON column to a Hibernate entity property
  2. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  3. How to choose the id generation strategy when using JPA and Hibernate
  4. JPQL Create new Object In Select Statement – avoid or embrace?
  5. Hibernate, @SequenceGenerator and allocationSize
  6. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  7. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  8. JPA/Hibernate Native Queries do not recognize Parameters
  9. What is the easiest way to ignore a JPA field during persistence?
  10. Default fetch type for one-to-one, many-to-one and one-to-many in Hibernate
  11. @Transactional method called from another method doesn’t obtain a transaction
  12. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  13. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  14. JPA how to make composite Foreign Key part of composite Primary Key
  15. Getting [SQLITE_BUSY] database file is locked with select statements
  16. Silently ignored remove()
  17. Hibernate/JPA DB Schema Generation Best Practices
  18. How to set a default query timeout with JPA and Hibernate?
  19. Is it possible to dynamically define column names in Hibernate / JPA?
  20. Change database schema during runtime based on logged in user
  21. Hibernate: “Field ‘id’ doesn’t have a default value”
  22. How to map sql native query result into DTO in spring jpa repository?
  23. Persisting UUID in PostgreSQL using JPA
  24. Batch inserts with JPA/EJB3
  25. Name attribute in @Entity and @Table
  26. Why should anybody put annotations on the getters or setters when using JPA to map the classes?
  27. Hibernate using JPA (annotated Entities) and liquibase
  28. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  29. JPA: Override Auto generated ID [duplicate]
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment