Hibernate @Filter does not work in JPA?

Question

I'm using JPA with Hibernate as a JPA provider. I cannot figure out how to configure my entities to apply a hibernate filter to a One-to-Many association. I have a `Master` with a collection of `Details`. Here are my entity definitions: ``` @Entity public class Master extends Base { private List details; @OneToMany @OrderColumn @JoinTable(name = "master_details") @Filter(name = "notDeleted") // @Where(clause = "deleted = 'false'") public List getDetails() { return details; } public void setDetails(List details) { this.details = details; } } @Entity @FilterDef(name = "notDeleted", defaultCondition = "deleted = false") public class Detail extends Base { private Boolean deleted = false; public Boolean getDeleted() { return deleted; } public void setDeleted(Boolean deleted) { this.deleted = deleted; } } ``` The `Base` is nothing special but a simple `MappedSuperClass`: ``` @MappedSuperclass public class Base { private Long id; @Id @GeneratedValue(strategy = Generat…

Accepted Answer

The Hibernate `@Filter` needs to be manually activated via `enableFilter` method:

```
session.enableFilter("myFilter").setParameter("myFilterParam", "some-value");
```

However, filters are useful when you need to parameterize the filtering condition. And, you don't seem to need a dynamic filtering clause.

For this reason, you could use the Hibernate `@Where` filter, like this:

```
@org.hibernate.annotations.Where(clause="deleted=false")        
public List<Detail> getDetails() {
    return details;
}
```

This way, you should get the list of non-deleted `Detail` entities.

Hibernate @Filter does not work in JPA?

Solution

Problem