JPA query for DTYPE

hibernate, jpa

Solution

Simply add a simple field dtype in your parent class.

@Column(insertable = false, updatable = false)
private String dtype;

And so, you can use it in your JPQL query

Problem

I have a single table which is generated from two jpa entities (inheritance). So we have a DTYPE column generated in the database table which has entity name has values. How do I write a jpa query to fetch data for any given entity. i.e DTYPE = 'A'? I just tried using DTYPE in jpa query but as expected I got an error "Could not resolve property". Please let me know how to write this query. Note - I dont want to use native query. Update: I have class A and subclass AA which extends A. DTYPE has two values A and AA. When I query for A, I get all the A plus AA entities. How to exclude AA when I query for A?

Original source