JPA Inheritance error mapping query retrieving parent field

Question

I have two related entities using hibernate:

@Entity
@Table(name = "OPERACION")
@Inheritance(strategy = InheritanceType.JOINED)
@DiscriminatorColumn(name = "DTYPE", discriminatorType = DiscriminatorType.STRING)
public abstract class Operacion


@Entity
@Table(name = "OPER_ALTA_NACIMIENTO")
@PrimaryKeyJoinColumn(name = "ID_OPERACION")
@DiscriminatorValue("NACIMIENTO")
public class OperacionAltaNacimiento extends Operacion

And i try to do a query to get the OperacionAltaNacimiento and return result by id but when i see the query:

select count(*) as col_0_0_ from MO_OPER_ALTA_NACIMIENTO operaciona0_ inner join MO_OPERACION operaciona0_1_ on operaciona0_.ID_OPERACION=operaciona0_1_.id **where operaciona0_.id=12**

It is doing well the join between tables but the where is using the child id and it doesn't exist... And it return me and error.

How can i accomplish to do the next query

select count(*) as col_0_0_ from MO_OPER_ALTA_NACIMIENTO operaciona0_ inner join MO_OPERACION operaciona0_1_ on operaciona0_.ID_OPERACION=operaciona0_1_.id **where operaciona0_1_.id=12**

question from:https://stackoverflow.com/questions/66050946/jpa-inheritance-error-mapping-query-retrieving-parent-field

Answer 1

Waitting for answers