I am quite proficient with SQL and Java but only starting with JPA/Hibernate.
I have a database table that stores some media clips. It might be a sound, image or both. The media itself is stored in BLOB column and each clip has a name and type (single character column). So, I created an abstract class Clip with following annotations:



My concrete classes have @DiscriminatorValue equal to "S" or "I" respectively, but they do not have type attribute.
Now I want to select all sound clips.
I know how to do it in native SQL but cannot figure out how to do it in JPQL.
Can someone please help me with that?
Thanks.

I don't know how exactly it is done in JPA but in HQL you query class attribute of your entity. Give it a try. It might be the same. Your query will look like




Farzad-

Apparently there is a Hibernate bug that does not add the value of discriminator column to the generated SQL.
I solved the problem by adding @Where annotation to the named query.
Just like in http://jroller.com/eyallupu/entry/getti ... en_mapping

It is not perfect but will do for a while.