How to get all objects of concrete class in table-per-hierarchy with hibernate?

Question

I'm developing a web application with Netbeans (Maven Web Application) using Spring MVC and Hibernate. I have an abstract class (User) with multiple concrete classes (Parent, Child, etc.). I chose for a table-per-hierarchy construction so that I have 1 tables with all the objects of these concrete classes. But I can't find a way to get all the objects of a certain concrete class. I'm getting following error:

java.lang.IllegalArgumentException: Type specified for TypedQuery [domain.Parent] is incompatible with query return type [class domain.User]

Anyone who knows how I can cast these objects?

can you also post your query and the code calling it please? — Julien, Feb 28 '14 at 15:45
I solved it using the HQL and Query-class. Well, I hope I do, I checked the class of the return type of my query and it said parent — TheCodeNoob, Feb 28 '14 at 18:15

score 0 · Accepted Answer · answered Feb 28 '14 at 17:00

0

You should have a discriminator columen in your BD, and a mapping like that:

@DiscriminatorColumn(name="TYPE", discriminatorType=DiscriminatorType.INTEGER)
public abstract class User {

and:

@DiscriminatorValue("1")
public class Parent extends User {

Then you can use the attribute class in your queries. For example:

getSession().createCriteria(User.class).add(Restrictions.eq("class", 1))

or in HQL:

FROM User WHERE class = 1

answered Feb 28 '14 at 17:00

polypiel

2,321
1
19
27

I used the HQL: String hql = "FROM User WHERE type = 'parent'"; Query query = em.createQuery(hql); return query.getResultList(); Thanks so much ! – TheCodeNoob Feb 28 '14 at 18:11

How to get all objects of concrete class in table-per-hierarchy with hibernate?

1 Answers1