CODEWITHSUNDEEP
javasqldatabasehibernatehql
flybywire
flybywire

Reputation: 273502

java hibernate: selecting the discriminator column in polymorphic hql query

In hibernate, I want to select the discriminator value. Something like

select discriminator, id, name, age from Animal

The idea is to send the result of this query to the client side, so that I can display a different icon based on the value of the discriminator column (i.e. cat, dog, elephant, etc).

Is that possible? How?

Upvotes: 19

Views: 17820

Answers (2)

Santiago Taba
Santiago Taba

Reputation: 21

Hibernate query objects, does not know columns. So unless you have a property named discriminator in your Animal object you cant do that. You can do the query in sql or get the entire object and then to get the inherited type, for that you can use "instanceof"

Upvotes: 1

axtavt
axtavt

Reputation: 242686

You can do it as follows:

select a.class, a.id, a.name, a.age from Animal a

From Hibernate Documentation:

The special property class accesses the discriminator value of an instance in the case of polymorphic persistence.

Upvotes: 32

Related Questions