'Can I search subclasses by type without joining every subclass table using Hibernate?

I am using spring data jpa. I am using InheritanceType.JOINED for my inheritance strategy. Say I have the following entity relationships:

Animal (abstract class)
Cow extends Animal
Pig extends Animal
Cat extends Animal
etc..

Each animal has a "TYPE" column populated with the name of the class.

How would I query for some subset of animal types without joining every subclass table? For example, if I wanted to retrieve all cows and pigs but not any cats.

I have tried @Query("select a from Animal where a.type in (Cow, Pig)"), but this will still perform a LEFT JOIN on the Cat table which is undesirable.

Is there some workaround for this?

javahibernatespring-data-jpajoined-subclass


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions