Ignore Hibernate @Where annotation

user_109191 0
Viewed 16924

I have an Entity which has an association to another Entity annotated with @Where, like so

public class EntityA {

    @OneToMany
    @Where(...)
    private List<EntityB> entityBList;

}

Recently the inevitable has happened, I need to load EntityB's that don't conform to the @Where clause. I could remove the @Where annotation, but it is used a lot, so ideally I don't want to do that. Apart from loading the list of EntityB's manually, with another query, what are my options? Can I tell Hibernate to ignore the @Where annotation?

where-clause annotations hibernate
5 Answers

I just had the same question. I solved the problem like this:

@Query(value="SELECT * FROM EntityA", nativeQuery=true)
public ignoreWhereMethod(){}

The SQL in the @Query annotation must point the table's name and the fields' names (not entity's name).

user_100549700

Another solution is filter, as explained in this question. Hibernate how to ignore @Where annotation

I will be trying this myself because the combination of @where and @NamedNativeQueries is a very cumbersome solution in our situation. But I do not know yet if @Filter is any better.

user_64595500
Related